How to display Excel file on IE
-
Hello All, I am working on ASP.NET 2008 (C#) and I have to display data in ExcelSheet on IE. I have some data and thro which I create Excel file in code behind. This excel file has some formulas also. Now I need to show this Excel file on IE and if any changes made then all the related Formulas must be fired and updated file should be display. Can someone help me .... Thanks in advance...
-
Hello All, I am working on ASP.NET 2008 (C#) and I have to display data in ExcelSheet on IE. I have some data and thro which I create Excel file in code behind. This excel file has some formulas also. Now I need to show this Excel file on IE and if any changes made then all the related Formulas must be fired and updated file should be display. Can someone help me .... Thanks in advance...
You're not talking about prompting the user to either open or download the file the typical web way are you? Because if you are not then you'll want to make a web version of excel... pretty much like spreadsheets on Google Docs... And I bet that is complicated and took *some* time. Anyhow, I guess you'd have manually render a table, link it to a stylesheet for coloring and such, then attach events or javascript [I'd personally go for AJAX] to cells which contain formulas on the excel file, etc. Now, processes for reading from/writing to Excel files will vary depending on whether your excel file is 97-2003 version or an OOXML one...
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
-
Hello All, I am working on ASP.NET 2008 (C#) and I have to display data in ExcelSheet on IE. I have some data and thro which I create Excel file in code behind. This excel file has some formulas also. Now I need to show this Excel file on IE and if any changes made then all the related Formulas must be fired and updated file should be display. Can someone help me .... Thanks in advance...
IE have its in-build mechanism for opening an excel file.You no need to worry about how to open it. Only give proper path in browser. User gets option for "Open" or "Save". If user opts for save that excel file is saved to user's system and if users opts for "open" the its opened into browser automatically!!!
Thanks, Arindam D Tewary