Loads a CSV stream into a worksheet. The default encoding of the text in CSV is assumed to be UTF-8.
The values from CSV will be imported in the top left corner of the worksheet.
Namespace: Winnovative.ExcelLib
Assembly: wnvxls (in wnvxls.dll) Version: 10.0.0.0 (10.0.0.0)
Syntax
public static ExcelWorkbook LoadFromCsv( Stream csvStream, string fieldsSeparator, ExcelWorkbookFormat workbookFormat )
Parameters
- csvStream
- Type: System.IOStream
The stream containing the CSV document. - fieldsSeparator
- Type: SystemString
The fields separator in CSV (usually ',') - workbookFormat
- Type: Winnovative.ExcelLibExcelWorkbookFormat
The format of the created workbook ( Excel 97-2003 .xls or Excel 2007 .xlsx).
Return Value
Type: ExcelWorkbookThe newly created workbook.
See Also