Hi,
Hi Sunil,
Thank you for considering Aspose.
Well, Cells.ExportDataTable is used when you have Strongly Typed Data in Sheet Columns. As your column contains both Numeric Values and String Values, you may use Cells.ExportDataTableAsString. It works fine as per your template file. For further details, please check the following documentation link:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/exporting-data-from-worksheets.html
Thank You & Best Regards
Hi,
Thank you for considering Aspose.
Also, you may use Cells.ExportDataTable(DataTable dataTable,int firstRow, int firstColumn, int rowNumber, bool exportColumnName) method and set the data type of the columns by yourself by creating your own data table if it fits your need.
Thank You & Best Regards,