trying to use Cells.ImportDataTable. All works fine, apart from the displaying of bit values when output to excel document. The column is completely blank, whether the bit is 0 or 1.
Any ideas?
@Haydn,
This is to inform you that Aspose.Excel is discontinued and no more supported now. We have released Aspose.Cells which is much more advanced as compared to the previous product. It also supports importing data table into a worksheet as follows:
// Instantiating a Workbook object
Workbook workbook = new Workbook();
// Obtaining the reference of the worksheet
Worksheet worksheet = workbook.Worksheets[0];
// Instantiating a "Products" DataTable object
DataTable dataTable = new DataTable("Products");
// Adding columns to the DataTable object
dataTable.Columns.Add("Product ID", typeof(Int32));
dataTable.Columns.Add("Product Name", typeof(string));
dataTable.Columns.Add("Units In Stock", typeof(Int32));
// Creating an empty row in the DataTable object
DataRow dr = dataTable.NewRow();
// Adding data to the row
dr[0] = 1;
dr[1] = "Aniseed Syrup";
dr[2] = 15;
// Adding filled row to the DataTable object
dataTable.Rows.Add(dr);
// Creating another empty row in the DataTable object
dr = dataTable.NewRow();
// Adding data to the row
dr[0] = 2;
dr[1] = "Boston Crab Meat";
dr[2] = 123;
// Adding filled row to the DataTable object
dataTable.Rows.Add(dr);
// Importing the contents of DataTable to the worksheet starting from "A1" cell,
// Where true specifies that the column names of the DataTable would be added to
// The worksheet as a header row
worksheet.Cells.ImportDataTable(dataTable, true, "A1");
// Saving the Excel file
workbook.Save(dataDir + "DataImport.out.xls");
Following documents link explains this feature in detail:
Import data into Worksheet
Here is the latest version which can be downloaded for testing:
Aspose.Cells for .NET (Latest Version)
We have prepared a detailed solution containing hundreds of features that can be downloaded here.