ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using EXCEL with .NET (https://www.excelbanter.com/excel-programming/337104-using-excel-net.html)

Sachin Saki

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.

Ed Ferrero[_5_]

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.




Tim Williams

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