dataTable save as excel programatically

[michael_jhons]

hello everybody i have a function that save my datatable to an excel file:

            int columnIndex = 0;
            Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
            excel.Application.Workbooks.Add(true);
            foreach (DataColumn dc in dataSet.Tables\[1\].Columns)
            {
                columnIndex++;
                excel.Cells.ColumnWidth = 25;
                excel.Cells\[1, columnIndex\] = dc.ColumnName;
            }

            int rowIndex = 0;
            foreach (DataRow dr in dataSet.Tables\[1\].Rows)
            {
                rowIndex++;
                columnIndex = 0;
                foreach (DataColumn dc in dataSet.Tables\[1\].Columns)
                {
                    columnIndex++;
                    excel.Cells\[rowIndex + 1, columnIndex\] = dr\[dc.ColumnName\];
                }

            }

            
            excel.Save(@"C:\\SomeName.xls");

what is going on is that a pop up window ask me "if i need to save my excel sheet', if i agree both files are saved one in c:/someName.xls and another for the pop up window. i don't want the pop up to be displayed i just need to save programatically my datatable. i'm new in excel things please any help kind regards

[Wendelius]

If I remember correctly, you must set the Saved property of a workbook to true. Save method doesn't automatically mark the workbook as saved.

The need to optimize rises from a bad design

[michael_jhons]

dear Mika, thank you for your answer i aklready added to my code : excel.ThisWorkbook.Saved = true; it gave me an error "0x800A03EC"...get.thisWorkbooks()... please could you help me how to set this property to true. best regards

[michael_jhons]

i'm sorry it was ActiveWorkbook.Saved not thisWorkbook.saved, now it's working fine thank you for your advise

[Wendelius]

No problem, glad you got it solved :)

The need to optimize rises from a bad design