Open Excel

[session101]

How do you open Excel in ASP.NET in read-only form?

I am using C# as the language and have tried to use:
1.) Process.Start() <-- Wont work for web servers
2.) Made a hyperlink to my Excel file

Is there a good way to open an Excel file with read-only permissions?

 

[session101]

I create an Excel object with:

ExcelObj = new Excel.ApplicationClass();
ExcelObj.Visible = true;
Excel.Workbook theWorkbook = ExcelObj.Workbooks.Open(FILE_NAME, false, true, false, false, false, false, true, true, false, true, true, true, true, false);

But I still get errors when the program tries to launch Excel. What am I doing wrong?

 

[session101]

bump...Any ideas?

 

[PlausiblyDamp]

What errors are you getting? The more information you provide the better chance of getting an answer.

 

[Arch4ngel]

From my experience, using the Excel application is not really a good idea. One of my problem I had was simply to close Excel. Everytime you declare an object you must free it with Marshal. If one of them is not realease, Excel wont quit.

Really troublesome on a web server where hundreds of users might open it. I suggest that you use something like CSV or any other file type. But learning what you want to do might help you find an alternate solution.

 

[session101]

What is a good way to launch Excel via a web app instead of creating an Excel object? I tried to use process.start, but I dont think it works for web apps.

 

[Arch4ngel]

Tell me what you are trying to do and we might find an alternative.