ExcelWorkbookLoadFromCsv(String, String, ExcelWorkbookFormat) Method

Loads a CSV file 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.

Definition

Namespace: Winnovative.ExcelLib
Assembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 11.0.0
C#
public static ExcelWorkbook LoadFromCsv(
	string csvFileName,
	string fieldsSeparator,
	ExcelWorkbookFormat workbookFormat
)

Parameters

csvFileName  String
The full path of the CSV file.
fieldsSeparator  String
The fields separator in CSV (usually ',')
workbookFormat  ExcelWorkbookFormat
The format of the created workbook ( Excel 97-2003 .xls or Excel 2007 .xlsx).

Return Value

ExcelWorkbook
The newly created workbook.

See Also