ExpertXls Excel Library for .NET
LoadFromCsv Method (csvStream, fieldsSeparator, workbookFormat)
Namespaces ► ExpertXls.ExcelLib ► ExcelWorkbook ► LoadFromCsv(Stream, String, ExcelWorkbookFormat)
ExpertXls Excel Library for .NET
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.
Declaration Syntax

C# | Visual Basic | Visual C++

    public static ExcelWorkbook LoadFromCsv(
    	Stream csvStream,
    	string fieldsSeparator,
    	ExcelWorkbookFormat workbookFormat
    )

    Public Shared Function LoadFromCsv ( _
    	csvStream As Stream, _
    	fieldsSeparator As String, _
    	workbookFormat As ExcelWorkbookFormat _
    ) As ExcelWorkbook

    public:
    static ExcelWorkbook^ LoadFromCsv(
    	Stream^ csvStream,
    	String^ fieldsSeparator,
    	ExcelWorkbookFormat workbookFormat
    )

Parameters

csvStream (Stream)
  The stream containing the CSV document.

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
The newly created workbook.

Assembly: ExpertXls.ExcelLib (Module: ExpertXls.ExcelLib) Version: 2.1.0.0 (2.1.0.0)