export to excel from datatable

[phrajib]

Dear Friends,

I have a datatable in my application. Now I want to export the table into excel file by clicking a button in form. Please help me. I never export anything to excel before in C#.

-Rajib

[Bombdrop]

Take a look at my attached example should be of some help.

Hope this helps!!

[RaviIntegra]

Microsoft.Office.Interop.Excel.ApplicationClass excel = new ApplicationClass();            
            excel.Application.Workbooks.Add(true);            
            for (int col = 0; col<lstView.Columns.Count;col++ )
            {
                excel.Cells[1, col + 1] = lstView.Columns[col].Text.ToString();              
            }
            int rowIndex = 1;
            int row = 0;
            for (row=0; row <lstView.Items.Count;row++)
            {
                if (rowIndex <= lstView.Items.Count)
                    rowIndex++;
                for (int col = 0; col < lstView.Columns.Count; col++)
                {
                    excel.Cells[rowIndex, col + 1] = lstView.Items[row].SubItems[col].Text.ToString();                    
                }
            }
            tmpRow = row;
            tmpItx = rowIndex;
            for (row = 0; row < lstViewPdf.Items.Count; row++)
            {
                if (tmpItx <= (lstViewPdf.Items.Count * 2))
                    tmpItx++;
                for (int col = 0; col < lstViewPdf.Columns.Count; col++)
                {
                    excel.Cells[tmpItx, col + 1] = lstViewPdf.Items[row].SubItems[col].Text.ToString();
                }
            }
            Worksheet worksheet = (Worksheet)excel.ActiveSheet;
            worksheet.Activate();
            worksheet.SaveAs("D:\\Inputs\\test.xls", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing
            , Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            excel.Workbooks.Close();
            excel.Quit();
            MessageBox.Show("Process completed");

Before export the data you should load the data from database to a listview control and then export it to excel.
I make use of this code to export data to excel and it is working fine.

[phrajib]

Thanks for ur help.

All my data is in a DataTable in C#.Net form. Have u any clu that can help me?

Thanks again.

Rajib

[phrajib]

Dear RaviIntegra,

I have tried with ur example. But my C#.NET application is not allowing the namespace Microsoft.Office.......

It is telling that Office....... is not allowed in this namespace.

When I write Microsoft. it is giving only three options following it as Csharp, VisualBasic and Win32. But no Office under Microsoft.

Please help me if possible.

Rajib

[RaviIntegra]

You should add the reference (Microsoft Office library) in you project references. Then it will work.