but keep getting
System.FormatException: 'The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character among the padding characters. '
even when using the demo ImportDataFromDataTable.
- Code: Select all
Workbook workbook = new Workbook();
//Create an empty worksheet
workbook.CreateEmptySheets(1);
//Get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Create a DataTable object
DataTable dataTable = new DataTable("Customer");
dataTable.Columns.Add("No", typeof(Int32));
dataTable.Columns.Add("Name", typeof(string));
dataTable.Columns.Add("City", typeof(string));
//Create rows and add data
DataRow dr = dataTable.NewRow();
dr[0] = 1;
dr[1] = "Tom";
dr[2] = "New York";
dataTable.Rows.Add(dr);
dr = dataTable.NewRow();
dr[0] = 2;
dr[1] = "Jerry";
dr[2] = "China";
dataTable.Rows.Add(dr);
dr = dataTable.NewRow();
dr[0] = 3;
dr[1] = "Dive Time";
dr[2] = "Berkely";
dataTable.Rows.Add(dr);
dr = dataTable.NewRow();
dr[0] = 4;
dr[1] = "Amor Aqua";
dr[2] = "Florida";
dataTable.Rows.Add(dr);
//Import datatable in worksheet
sheet.InsertDataTable(dataTable, true, 1, 1);
//Save the Excel file
string result = "ImportDataFromDataTable_output.xlsx";
workbook.SaveToFile(result, ExcelVersion.Version2013);
//Launch the Excel file
ExcelDocViewer(result);