Using C# to work in Excel

[Falnom]

Hi, my application needs to open up an excel workbook and store data there. I'm able to write into the cells (I see them written there as the program excutes) but as soon as it's over and I open the excel file nothing is there. I really don't understand it. Here is my code

Excel.Workbook theWorkbook;    
Excel.Application ExcelObj = new Excel.Application();
theWorkbook = ExcelObj.Workbooks.Open(path + "\\Results.xls",0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
 
Excel.Worksheet worksheet = (Excel.WorksheettheWorkbook.Worksheets.get_Item(1);
 
worksheet.Activate();
ExcelObj.Visible = true;
 
int j = 1;
 
foreach(DictionaryEntry de in htMasterTable)
{
     ((Excel.Range)worksheet.Cells[j,1]).Interior.Color = 0x00ff0000;
     j++;
}
 
 
heWorkbook.Save();
 
theWorkbook.Close((System.Boolean)false,System.Reflection.Missing.Value,System.Reflection.Missing.Value );
 
ExcelObj.Quit();
 

Thanks. Any assitance would be great cause I'm dieing here.

[nateraaaa]

Hi, my application needs to open up an excel workbook and store data there. I'm able to write into the cells (I see them written there as the program excutes) but as soon as it's over and I open the excel file nothing is there. I really don't understand it. Here is my code

Excel.Workbook theWorkbook;    
Excel.Application ExcelObj = new Excel.Application();
theWorkbook = ExcelObj.Workbooks.Open(path + "\\Results.xls",0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
 
Excel.Worksheet worksheet = (Excel.WorksheettheWorkbook.Worksheets.get_Item(1);
 
worksheet.Activate();
ExcelObj.Visible = true;
 
int j = 1;
 
foreach(DictionaryEntry de in htMasterTable)
{
     ((Excel.Range)worksheet.Cells[j,1]).Interior.Color = 0x00ff0000;
     j++;
}
 
 
heWorkbook.Save();
 
theWorkbook.Close((System.Boolean)false,System.Reflection.Missing.Value,System.Reflection.Missing.Value );
 
ExcelObj.Quit();
 

Thanks. Any assitance would be great cause I'm dieing here.

Try this line of code

theWorkBook.SaveCopyAs(@"C:\Book1.xls");

Nathan