I know you can export a datatable to an Excel file, but can the same be done with data in an asp.net 2.0 gridview?
Is the API compatible with .net 2.0?
Thanks
//Get gridview data
object data = this.GridView1.DataSource;
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
//Insert in sheet
sheet.InsertDataTable((DataTable)data, true, 1, 1);
string result= "output.xlsx";
workbook.SaveToFile(result, ExcelVersion.Version2013);
//Get gridview data
object data = this.GridView1.DataSource;
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
CellStyle style = workbook.Styles.Add("newStyle");
//Set the display format of the date column
// style. NumberFormat = "dd/MM/yyyy";
style. NumberFormat = "dd-MM-yyyy";
sheet.Columns[0]. CellStyleName = style.Name;
//Insert in sheet
sheet.InsertDataTable((DataTable)data, true, 1, 1);
string result = "output.xlsx";
workbook. SaveToFile(result, ExcelVersion.Version2013);