API Reference
Class
ExcelDocumentCsvExtensions
Imports CSV data through the shared OfficeIMO.CSV reader pipeline.
Inheritance
- Object
- ExcelDocumentCsvExtensions
Methods
ImportCsv 2 overloads
public static ExcelCsvImportResult ImportCsv(ExcelDocument document, CsvDocument csv, ExcelCsvImportOptions options = null, CancellationToken cancellationToken = default) #Returns:
ExcelCsvImportResultImports a loaded CSV document into a new worksheet.
Parameters
- arg1 OfficeIMO.Excel.ExcelDocument
- arg2 OfficeIMO.CSV.CsvDocument
- arg3 OfficeIMO.Excel.Csv.ExcelCsvImportOptions = null
- arg4 System.Threading.CancellationToken = default
public static ExcelCsvImportResult ImportCsv(ExcelDocument document, Stream stream, ExcelCsvImportOptions options = null, CancellationToken cancellationToken = default) #Returns:
ExcelCsvImportResultReads a caller-owned CSV stream and imports it into a new worksheet.
Parameters
- arg1 OfficeIMO.Excel.ExcelDocument
- arg2 System.IO.Stream
- arg3 OfficeIMO.Excel.Csv.ExcelCsvImportOptions = null
- arg4 System.Threading.CancellationToken = default
public static ExcelCsvImportResult ImportCsvFile(ExcelDocument document, String path, ExcelCsvImportOptions options = null, CancellationToken cancellationToken = default) #Returns:
ExcelCsvImportResultOpens a CSV file and imports it into a new worksheet.
Parameters
- document OfficeIMO.Excel.ExcelDocument
- path System.String
- options OfficeIMO.Excel.Csv.ExcelCsvImportOptions = null
- cancellationToken System.Threading.CancellationToken = default
public static ExcelCsvImportResult ImportCsvText(ExcelDocument document, String text, ExcelCsvImportOptions options = null, CancellationToken cancellationToken = default) #Returns:
ExcelCsvImportResultParses CSV text and imports it into a new worksheet. Because the input is already decoded, Encoding applies only to file and stream imports.
Parameters
- document OfficeIMO.Excel.ExcelDocument
- text System.String
- options OfficeIMO.Excel.Csv.ExcelCsvImportOptions = null
- cancellationToken System.Threading.CancellationToken = default
SaveAsExcel 2 overloads
public static Void SaveAsExcel(CsvDocument csv, String path, ExcelCsvImportOptions importOptions = null, ExcelSaveOptions saveOptions = null, CancellationToken cancellationToken = default) #Returns:
VoidConverts a loaded CSV document and saves it as an Excel workbook.
Parameters
- arg1 OfficeIMO.CSV.CsvDocument
- arg2 System.String
- arg3 OfficeIMO.Excel.Csv.ExcelCsvImportOptions = null
- arg4 OfficeIMO.Excel.ExcelSaveOptions = null
- arg5 System.Threading.CancellationToken = default
public static Void SaveAsExcel(CsvDocument csv, Stream stream, ExcelCsvImportOptions importOptions = null, ExcelSaveOptions saveOptions = null, CancellationToken cancellationToken = default) #Returns:
VoidConverts a loaded CSV document and saves it to an Excel workbook stream.
Parameters
- arg1 OfficeIMO.CSV.CsvDocument
- arg2 System.IO.Stream
- arg3 OfficeIMO.Excel.Csv.ExcelCsvImportOptions = null
- arg4 OfficeIMO.Excel.ExcelSaveOptions = null
- arg5 System.Threading.CancellationToken = default
public static ExcelDocument ToExcelDocument(CsvDocument csv, ExcelCsvImportOptions options = null, ExcelCreateOptions createOptions = null, CancellationToken cancellationToken = default) #Returns:
ExcelDocumentCreates a detached Excel workbook from a loaded CSV document.
Parameters
- csv OfficeIMO.CSV.CsvDocument
- options OfficeIMO.Excel.Csv.ExcelCsvImportOptions = null
- createOptions OfficeIMO.Excel.ExcelCreateOptions = null
- cancellationToken System.Threading.CancellationToken = default
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object