C# export datagrid to excel windows application

PDF reader, Excel etc. Adeel Khalid. M Adeel Khalid , can you refer any example? Add a comment. Active Oldest Votes. WriteLine "Hello World! Write dset. Write Convert. ToString dset. Close ; MetroMessageBox. OK, MessageBoxIcon. Show this, v1. Error ; el. Improve this answer. You can open Excel file by following this link Always search before asking a question because everything is available here whatever you'd asked.

Hope it helps! Community Bot 1 1 1 silver badge. Adeel Khalid M. Adeel Khalid 1, 2 2 gold badges 22 22 silver badges 24 24 bronze badges.

While searching for windows desktop application related answers use keywords "Winforms","C ". The Overflow Blog. Podcast Making Agile work for data science. Thanks a lot! Follow Post Reply. Nicholas Paldino [.

Eric, It would be very different. Hope this helps. There is. This discussion thread is closed Start new discussion. Similar topics ASP. Exporting to Excel in ASP. Problem exporting datagrid with numeric values to Excel. Visual Basic. Exporting to Excel. For that you will have to create two tables in your SQL Server database.

I have already created these tables for you. Use it. Employee table: dbo. Employee Employee detail table: dbo. The final output will show data formatted automatically. The formatting actually happens once all the data is exported to the sheet. Please let me know if this example helped you in any way. If you have any queries or suggestions regarding this article and its example, please let me know.

Leave your message below. Please enable JavaScript to view this page properly. You must be aware of the AutoFormat feature in Excel, which allow users to format a sheet or a particular range with various formatting options.