//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); //Open csv with custom delimiter. CsvOpenOptions options = new CsvOpenOptions { ColumnSeparator = ",", RowSeparator = "\r\n", CellSeparator = '"' }; //Change the path to the real file path when open. workbook.Open("source.csv", options);
' Create a new Workbook Dim workbook As New Workbook 'Open csv with custom delimiter. Dim options As New CsvOpenOptions With { .ColumnSeparator = ",", .RowSeparator = vbCrLf, .CellSeparator = """"c } 'Change the path to the real file path when open. workbook.Open("source.csv", options)