Export report in datagrid to excel

Question

0.00/5 (No votes)

See more:

I have this kind of code. I would like to asked what should I do if I want to export this report into excel. Many of the example I found usually used data bind concept or data grid view. Can somebody teach me how to do it?

What I have tried:

<pre> private int LoadReport()
        {
            try
            {
                int rowcount;
                int result;
                DataTable records;
                Process process;

                dgResult.ItemsSource = null;

                switch (_process)
                {
                    case Process.I:
                        process = Process.I_RECEIVING;
                        break;
                    case Process.A:
                        process = Process.A_RECEIVING;
                        break;
                    case Process.c:
                        process = Process.C_RECEIVING;
                        break;
                    default:
                        return 0;
                }
                result = DB.GetReport(Session, out rowcount, out records, User, (int)process, DateTime.Now.AddMonths(-3), DateTime.Now);

                dgResult.ItemsSource = records.DefaultView;

                return 0;

            }
            catch
            {
                throw;
            }

Posted 14-Nov-19 14:46pm

Member 14638721

Updated 18-Nov-19 10:42am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2019-11-14T22:01:00

Solution 1

There is not space in Quick Answers to explain such a concept. However there are plenty of resources that Google will find for you. And you could also look into Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] and Microsoft.Office.Interop.Excel Namespace | Microsoft Docs[^]

Posted 14-Nov-19 22:01pm

Richard MacCutchan

Comments

Member 14638721 15-Nov-19 4:34am

Thank you. I will go through this during weekend.

Richard Deeming · Answer 2 · 2019-11-18T10:43:00

Solution 2

I'd recommend using a library which doesn't depend on the user having the correct version of Excel installed. For example:
GitHub - JanKallman/EPPlus: Create advanced Excel spreadsheets using .NET[^]

C#

result = DB.GetReport(Session, out rowcount, out records, User, (int)process, DateTime.Now.AddMonths(-3), DateTime.Now);

using (var package = new ExcelPackage())
{
    var sheet = package.Workbook.Worksheets.Add("Report");
    sheet.Cells["A1"].LoadFromDataTable(records, true, TableStyles.Medium9);
    package.SaveAs(filePath);
}

Posted 18-Nov-19 10:43am

Richard Deeming

Comments

Member 14638721 20-Nov-19 3:35am

result = DB.GetReport(Session, out rowcount, out records, User, (int)process, DateTime.Now.AddMonths(-3), DateTime.Now);

using (var package = new ExcelPackage())
{
var sheet = package.Workbook.Worksheets.Add("Report");
sheet.Cells["A1"].LoadFromDataTable(records, true, TableStyles.Medium9);
package.SaveAs(package.SaveAs(new
System.IO.FileInfo(@"C:\Users\Desktop\try.xlsx"));
}
I did it like that however nothing coming up. Can you advise? Plus I actually using combo box where there are other different report cases so is it possible to use button to export it?

Richard Deeming 20-Nov-19 6:26am

What do you mean by nothing coming up? You're saving a file to disk.

Were you expecting to see it on screen? If so, call Process.Start passing in the file path to open the file.

If you want to export when the user clicks a button, you can call this code from the click event handler for that button.