![]() |
Using EXCEL with .NET
I am facing the problem with excel. here is my question and what i m doing ?
At server side: When users comes to the .aspx page, he gets the option of downloading a excel file. when he clicks on download, (one blank template is already exist at server) excel file is created and populated with data from database using VBA and Macros are written for this and working fine. I am referencing a Interop.Excel dll which maps to excel.exe when excel is created at server side because i m creating excel.application, workbook, sheet objects which require excel must be installed on server. But Client do not want to install complete excel. He wants to install only "Run Time version of excel". Please let me know that whether run-time version is sufficient for above functionalitly or not. or Do we require to install complete excel setup on server. |
Using EXCEL with .NET
Hi Sachin Saki,
There is no Excel runtime version. You need to install the full Excel application on the server. Users could run your .aspx page and use the Excel viewer to see the finished workbook. But the Excel viewer cannot be used to add data to a workbook. Ed Ferrero http://edferrero.m6.net/ I am facing the problem with excel. here is my question and what i m doing ? At server side: When users comes to the .aspx page, he gets the option of downloading a excel file. when he clicks on download, (one blank template is already exist at server) excel file is created and populated with data from database using VBA and Macros are written for this and working fine. I am referencing a Interop.Excel dll which maps to excel.exe when excel is created at server side because i m creating excel.application, workbook, sheet objects which require excel must be installed on server. But Client do not want to install complete excel. He wants to install only "Run Time version of excel". Please let me know that whether run-time version is sufficient for above functionalitly or not. or Do we require to install complete excel setup on server. |
Using EXCEL with .NET
You might consider either
1. a server-side component eg "excelwriter" http://officewriter.softartisans.com...writer-37.aspx 2. save an Excel workbook as xml/html and use that as a template. Replace placeholders in the file with data from your app. If the Excel export isn't too complicated you might be able to output as HTML or XML if you can figure out the syntax. Tim -- Tim Williams Palo Alto, CA "Ed Ferrero" wrote in message ... Hi Sachin Saki, There is no Excel runtime version. You need to install the full Excel application on the server. Users could run your .aspx page and use the Excel viewer to see the finished workbook. But the Excel viewer cannot be used to add data to a workbook. Ed Ferrero http://edferrero.m6.net/ I am facing the problem with excel. here is my question and what i m doing ? At server side: When users comes to the .aspx page, he gets the option of downloading a excel file. when he clicks on download, (one blank template is already exist at server) excel file is created and populated with data from database using VBA and Macros are written for this and working fine. I am referencing a Interop.Excel dll which maps to excel.exe when excel is created at server side because i m creating excel.application, workbook, sheet objects which require excel must be installed on server. But Client do not want to install complete excel. He wants to install only "Run Time version of excel". Please let me know that whether run-time version is sufficient for above functionalitly or not. or Do we require to install complete excel setup on server. |
All times are GMT +1. The time now is 11:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com