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.
Namespace: Winnovative.ExcelLibAssembly: WnvXls_NetCore (in WnvXls_NetCore.dll) Version: 11.0.0
public static ExcelWorkbook LoadFromCsv(
string csvFileName,
string fieldsSeparator,
ExcelWorkbookFormat workbookFormat
)
Public Shared Function LoadFromCsv (
csvFileName As String,
fieldsSeparator As String,
workbookFormat As ExcelWorkbookFormat
) As ExcelWorkbook
public:
static ExcelWorkbook^ LoadFromCsv(
String^ csvFileName,
String^ fieldsSeparator,
ExcelWorkbookFormat workbookFormat
)
static member LoadFromCsv :
csvFileName : string *
fieldsSeparator : string *
workbookFormat : ExcelWorkbookFormat -> ExcelWorkbook
- 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).
ExcelWorkbookThe newly created workbook.