Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

Export DataTable to Execl spreadsheet giving problem in .xlsx file

Home
Forums
.NET

Export DataTable to Execl spreadsheet giving problem in .xlsx file

bharathi k

15yAsked Oct 11, 2011, 9:18 AM3.3k.NET

Hi All,

I would like to Export the Data from the dataTable in asp.net application,

I am able to export the data to Excel .xls format but i am not able to open the excel spreadsheet format(.xlsx).

when i open its opening only ms Office Execl window but datais not displaying.

please hell its very urgent

Thanks
Bharathi

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Suthish Nair15y ago
Both ways it should work.. Post more information about how you exporting the file.
Sam Hobbs15y ago
If the export is to be done in the server then I think Microsoft says not to do that.

You should look at the articles in this web site. It is very likely that there is at least one article that will help you.
Javeed M Shaikh15y ago
Hi Bharathi,

Since an .xlsx file is opened as a package used by 2007 office applications and .xls file is opened by 2007 using the
same content but by some tricks. I would recommend you look into the following to create the .XLSX format files and other MS Office activities.

http://npoi.codeplex.com/
http://www.leniel.net/2009/07/creating-excel-spreadsheets-xls-xlsx-c.html

Please do not forget to mark "Accepted Answer".