Export to Excel From Data Grid In C# Windows Application
-
I have creted windows application in which I am showing data in one grid.This grid having 50000 lines. I want grid data to be exported to excel . How do I expoert to excel from data grid view ? Thanks In advance !!!!!!!!! :)
-
I have creted windows application in which I am showing data in one grid.This grid having 50000 lines. I want grid data to be exported to excel . How do I expoert to excel from data grid view ? Thanks In advance !!!!!!!!! :)
You export your data, the easiest way is to write a csv.
Christian Graus Driven to the arms of OSX by Vista. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums. I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
-
I have creted windows application in which I am showing data in one grid.This grid having 50000 lines. I want grid data to be exported to excel . How do I expoert to excel from data grid view ? Thanks In advance !!!!!!!!! :)
A simple google search on c# to excel got over 10 million hits. I assume therefore, that you have read all of the relevant ones, distilled their content and attempted the task yourself. What have you tried so far? Where did it go wrong? Be precise, it's annoying to have to read through lots of irrelevant code. :)
Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”
-
I have creted windows application in which I am showing data in one grid.This grid having 50000 lines. I want grid data to be exported to excel . How do I expoert to excel from data grid view ? Thanks In advance !!!!!!!!! :)
-
Finally got solution....... Export a DataSet to Microsoft Excel without the use of COM objects[^]
-
I have creted windows application in which I am showing data in one grid.This grid having 50000 lines. I want grid data to be exported to excel . How do I expoert to excel from data grid view ? Thanks In advance !!!!!!!!! :)
Hi, as d@nish said you could use System.Data.OleDb but for faster and easier work you should use some 3rd party component like GemBox spreadsheet component
-
Hi, as d@nish said you could use System.Data.OleDb but for faster and easier work you should use some 3rd party component like GemBox spreadsheet component
I got the solution http://www.codeproject.com/KB/dotnet/ExportToExcel.aspx?