Winnovative Excel Library

ExcelWorkbookLoadFromCsv Method (Stream, String, ExcelWorkbookFormat)

Winnovative Excel Library Documentation
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: ExcelWorkbook
The newly created workbook.
See Also

Reference