Excel not visible in c#

  • Thread starter Thread starter psmith
  • Start date Start date
P

psmith

Hi,

I am running excel 2000. with version 9.0 type library.

I cannot see the excel application, althought it appears on the taskbar.
I have tried the following code:

Excel.Application xlApp;
Excel.Workbook ExcelWorkbook;
Excel.Worksheet ExcelWorkSheet;
xlApp = new Excel.ApplicationClass();
ExcelWorkbook = (Excel.Workbook)(xlApp.Workbooks.Add(Type.Missing));
ExcelWorkSheet = (Excel.Worksheet)ExcelWorkbook.Sheets["Sheet1"];
ExcelWorkSheet.Name = "My Sheet";
ExcelWorkSheet.Activate();
xlApp.Visible = true;
xlApp.UserControl = true;
ExcelWorkSheet.Cells[1, 1] = "test sheet";
xlApp.Quit();
Marshal.ReleaseComObject(ExcelWorkSheet);
Marshal.ReleaseComObject(ExcelWorkbook);
Marshal.ReleaseComObject(xlApp);

but it does not make the excel visible.

any help appreciated.
 
xlApp.Visible = True

This should enable you to see the app. Check Task Manager
to see if the app is running. If it doesn't appear in the
Applications tab,check the processes tab.
If it does appear in Applications, it may be that it's
coordinates got stuffed and it's off screen somewhere.
 
Thanks Patrick.

I have tried that. The process is running (checked task manager)
but I cannot see the excel.

Patrick Molloy said:
xlApp.Visible = True

This should enable you to see the app. Check Task Manager
to see if the app is running. If it doesn't appear in the
Applications tab,check the processes tab.
If it does appear in Applications, it may be that it's
coordinates got stuffed and it's off screen somewhere.

-----Original Message-----
Hi,

I am running excel 2000. with version 9.0 type library.

I cannot see the excel application, althought it appears on the taskbar.
I have tried the following code:

Excel.Application xlApp;
Excel.Workbook ExcelWorkbook;
Excel.Worksheet ExcelWorkSheet;
xlApp = new Excel.ApplicationClass();
ExcelWorkbook = (Excel.Workbook)(xlApp.Workbooks.Add (Type.Missing));
ExcelWorkSheet = (Excel.Worksheet)ExcelWorkbook.Sheets ["Sheet1"];
ExcelWorkSheet.Name = "My Sheet";
ExcelWorkSheet.Activate();
xlApp.Visible = true;
xlApp.UserControl = true;
ExcelWorkSheet.Cells[1, 1] = "test sheet";
xlApp.Quit();
Marshal.ReleaseComObject(ExcelWorkSheet);
Marshal.ReleaseComObject(ExcelWorkbook);
Marshal.ReleaseComObject(xlApp);

but it does not make the excel visible.

any help appreciated.
.
Click to expand...
Click to expand...
 
Back
Top