Ouvrir des fichiers texte en tant que classeurs
Contents
[
Hide
]
Ci-dessous se trouvent des exemples de code comparatif pour ouvrir des fichiers texte en tant que classeurs :
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);