Free Support Forum -

Export excel file to datagridview

Hi, how can i export a excel file to a datagridview? thanks for your helps


Well, I think you may try to export Excel sheet’s data to fill a datatable or array by using e.g Cells.ExportDataTable method or Cells.ExportArray method. Then you may try to bind it to your data grid view.

See a document on some exporting options with examples that you may try:

Thank you.

Thank you very much


Thanks for your comments and using Aspose.Cells for .NET.

If you face any other issue, please feel free to post, we will like to help you further.

Besides if you are new to Aspose.Cells APIs, we will like to inform you that we have lately done some major enhancements and added new features in our product, so you should also download and give a try to latest offline demos of Aspose.Cells which you can find from theses links.

These demos can work with Visual Studio 2005, 2008 or 2010. Please read the readme.txt file before running the demos.