office 编程（excel）的菜鸟问题# XML - WWW明日之星
w*g
1 楼
兄弟手上有那么几万个excel文件，需要把里面的内容存成tab或者逗号分隔的文本文件，
或者某种自己定义的简单的xml格式文件。哪位仁兄有此方面的经验？
或者某种自己定义的简单的xml格式文件。哪位仁兄有此方面的经验？
k*c
2 楼
The following are 2 vb code blocks, maybe helpful to you.
public sub ReadExcelFile
dim sTemp as string
Dim Range As Excel.Range
Set Range = Sheet.UsedRange
iCols = Range.Columns.Count
iRows = Range.Rows.Count
With Range.Cells
For i = 1 To iRows
For j = 1 To iCols
sTemp = .Item(i, j).Value
next j
next i
end sub
public sub SaveExcelFileAsText
Dim xl As Excel.Application
Dim Workbook As Excel.Workbook
Dim
【在 w*******g 的大作中提到】
: 兄弟手上有那么几万个excel文件，需要把里面的内容存成tab或者逗号分隔的文本文件，
: 或者某种自己定义的简单的xml格式文件。哪位仁兄有此方面的经验？
public sub ReadExcelFile
dim sTemp as string
Dim Range As Excel.Range
Set Range = Sheet.UsedRange
iCols = Range.Columns.Count
iRows = Range.Rows.Count
With Range.Cells
For i = 1 To iRows
For j = 1 To iCols
sTemp = .Item(i, j).Value
next j
next i
end sub
public sub SaveExcelFileAsText
Dim xl As Excel.Application
Dim Workbook As Excel.Workbook
Dim
【在 w*******g 的大作中提到】
: 兄弟手上有那么几万个excel文件，需要把里面的内容存成tab或者逗号分隔的文本文件，
: 或者某种自己定义的简单的xml格式文件。哪位仁兄有此方面的经验？
相关阅读
personally feel msft's xmldom object very easy tontel Products Support Fast, Secure XML-based Inte[转载] Urgent: Looking for Microsoft SQL Server 7.0WWW常见的错误信息介绍(from sunrise)How to use xml parser?请问那有xml的parse source(bsd 或 linux)可以download,多多多谢了!!1ALURe (Aggregation and Logging of User Requests)SMILXML All-purpose Protocol (XAP)欢迎到水母清华XML版来做客(null)请各位看看，他们是不是很难呢？又一初级问题：如何用<form>?XML Standard for Extraction, Transformation, andexcelon?如何在cgi中锁数据库中的一个字段Will XML become Ada second?Investment Research Markup Language (IRML).why do u use XML?what is WOF(web object format??))聊一聊Instant Messenger吧