Export data from asp.net gridview to Excel (xlsx)

[sconly]

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

[Annika.Zhou]

Hi,

Thanks for your inquiry.
Yes, the data of gridview can be exported in Excel too. Please refer to the code below. In addition, Our Spire.XLS has NET2.0, it can work with NET Framework 2.0. If there is any question, please feel free to write back.

Code: Select all

//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);

Sincerely,
Annika
E-iceblue support team

[sconly]

Thanks for the reply.

one more thing. I'm using Visual Studio 2005 - no nuget manager- on a Windows 2008 server machine.

Can I still install spire.xls without nuget manager on my PC? If so, how?

Thanks

[Annika.Zhou]

Hello,

Sorry for the late reply on the weekend.
Yes, you can apply our Spire.XLS without nuget. Please download the Spire.XLS Pack Version:11.6 from our website, kindly note this is a msi, please install it on your computer, then you can find the dlls in Bin folder under installing path. Please reference the dlls from NET2.0 in your project. If there is any question, please feel free to write back.

Sincerely,
Annika
E-iceblue support team

[Annika.Zhou]

Hello,

Greetings from e-iceblue.
How is your issue going? Did the methods we provided help you? Can you give us some feedback at your convenience? Thanks in advance.

Sincerely,
Annika
E-iceblue support team

[sconly]

Sorry for the really late reply, but yes they did help. Thanks.

Although, the dates are exporting/displaying as yyyy-MM-dd but I'd like them to be dd/MM/yyyy or dd-MM-yyyy. Is there anything I can do to achieve this?

Thanks

[Annika.Zhou]

Hello,

Thank you for your response.
Please use the following code to set the display format of the date column.

Code: Select all

//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);

Sincerely,
Annika
E-iceblue support team

[Annika.Zhou]

Hello,

Hope you are doing well!
How is your issue going? Did the code we provided work for you? Any feedback will be greatly appreciated.

Sincerely,
Annika
E-iceblue support team