We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Re: How to export data(datatable) to excel

Hi,

Can you please tell me how to export data to excel using aspose, i tried but i getting error like Index out of bound array.

Hi there,

Thanks for your inquiry. You can achieve your requirement using Aspose.Cells. I am moving your query to Aspose.Cells forum. My colleagues from Aspose.Cells team will reply you shortly.

Hi,


Please see the document with example code on different Data importing options (including importing DataTable) available (via Aspose.Cells APIs) for your reference:
http://www.aspose.com/docs/display/cellsnet/Importing+Data+to+Worksheets

Thank you.

Hi Amjad,

I checked that link, but i am getting Index out of bound array error.

Hi Lokesh,


We are sorry to know that the presented solution didn’t help in your scenario. Please confirm that you are using the latest version of Aspose.Cells for .NET 8.2.1 for your testing purposes. If yes, we would require to review your sample spreadsheet (if any) along with your source code to assist you further in this regard. Please provide us a standalone console application (without requiring database connectivity) to replicate the said exception on our end.