设置WorkbookSaveAsArgs(Workbook)对象的TextCodepage属性 [英] Seting TextCodepage property of WorkbookSaveAsArgs (Workbook) object
问题描述
我想尝试设置 WorkbookSaveAsArgs
的 TextCodepage
属性作为 Workbook
方法SaveAs。其中用于转换.csv文件中的.xls文件。但是,此属性接收通用对象,我不知道如何正确设置它。在msdn文档中,它只会说出 Microsoft Excel中所有语言的忽略。 不用于美国英语Excel。当我的文档正在转换,它生成无效的字符,因为我的输入文件是葡萄牙语。因此,我需要一个接受这种语言的编码模式。任何建议?
Folks, I'm trying to set the TextCodepage
property of WorkbookSaveAsArgs
used as argument for an Workbook
method SaveAs. Which is used to convert .xls files in .csv ones. However, this property receives a generic object and I don't know how to properly set it. In msdn documentation it only say Ignored for all languages in Microsoft Excel. or Not used in U.S. English Excel.. When my documents are being convert, it generate invalid characters cause my input files are in portuguese. Thus, I need a encode mode that accept this language. Any suggestions?
推荐答案
我只能建议使用FileFormat:= xlUnicodeText,而不是xlCSV。但是当你这样做时,使用.csv文件扩展名。这应该保留您的葡萄牙字符。
I can only suggest saving with FileFormat:=xlUnicodeText, instead of xlCSV. But use a ".csv" file extension when you do so. This should preserve your portuguese characters.
这篇关于设置WorkbookSaveAsArgs(Workbook)对象的TextCodepage属性的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!