Simple C# to Excel Export

[gustavd]

Hi everyone
I've got a very basic program that lists drivespace stats of important network computers. I want to export the variable data to excel so i can do a trend analysis over a given time to help predict when our servers will run out of space.
No fancy formatting is needed.

Any help will be much appreciated

Thanks
Gustav

[gustavd]

to answer my own question...:)
i figured it out, much simpler than i thought
so if anyone has a similar question, hope this helps:
it pulls data out of a listview and pumps it into Excel 2007.
Make sure you have the correct references.

Microsoft.Office.Interop.Excel.Application xla = new Microsoft.Office.Interop.Excel.Application();
 
            xla.Visible = true;
            Workbook wb = xla.Workbooks.Add(XlSheetType.xlWorksheet);
            Worksheet ws = (Worksheet)xla.ActiveSheet;
            int i = 1;
            int j = 1;
            foreach (ListViewItem comp in lvwResults.Items)
            {
                ws.Cells[i, j] = comp.Text.ToString();
                //MessageBox.Show(comp.Text.ToString());
                foreach (ListViewItem.ListViewSubItem drv in comp.SubItems)
                {
                    ws.Cells[i, j] = drv.Text.ToString();
                    j++;
                }
                j = 1;
                i++;

[kenobewan]

Well done! Thanks for sharing the solution.

[Telecomman]

I have three list views in my code. How I can export each one to a specific sheet in the excel file? How I can also give each sheet name.

[rshin2020]

How do i test this code? Do i just copy this code and paste it in Visual studio? Im new to this. Need guidance. Thanks.

[Her77]

Hi, I'm Hernán from Argentina. I found the post very useful! Thanks a lot! Congratulations!