Excel not visible in c#

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.
 
P

Patrick Molloy

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.
 
P

psmith

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.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top