将文本文件作为工作簿打开
Contents
[
Hide
]
下面是将文本文件作为工作簿打开的比较代码示例:
VSTO
this.Application.Workbooks.OpenText(@"OpenTextFilesAsWorkbooks.txt",
missing, 3,
Excel.XlTextParsingType.xlDelimited,
Excel.XlTextQualifier.xlTextQualifierNone,
missing, missing, missing, true, missing, missing, missing,
missing, missing, missing, missing, missing, missing);
Aspose.Cells
private static string fileName = "OpenTextFilesAsWorkbooks.xlsx";
private static string TextFile = "OpenTextFilesAsWorkbooks.txt";
//loadoption to represent the option of load file
LoadOptions loadOptions = new LoadOptions(LoadFormat.CSV);
Workbook newWorkbook = new Workbook(TextFile, loadOptions);
newWorkbook.Save(fileName);