On my ASP.Net Production Server, there is no MS-Office but for working with Excel (Like Reading and Exporting textual Table) we have installed AccessDatabaseEngine_x64.exe .
Now While Exporting textual Table we also want to export dynamic image formed by MS-Chart on .aspx page.
Paralelly we can not use Microsoft.Office.Interop.Excel.dll as we do not have installed MS-Office on Production Server.
So how we can export such type of dynamic MS-Chart image with data only in Excel ?
If anybody knows please let me know ?. It is highly appreciable.
It would be better if you can install Office program.
No, it is NOT, because you shouldn't use Office Interop on a web server:
"Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit
unstable behavior and/or deadlock when Office is run in this environment."
Thanks for your suggetion .we are not much more interested in Printing the page or Garph.
we are more interested in exporting the image with a Table ( this table are alraedy exporting) ,so that client can change the values and redraw the another Chart and compares this generated chart with old one of Exported MS-Chart.
Rajesh Kumar...
0 Points
9 Posts
Export Image into Excel while there is no MS-Office on server in ASP.Net
Jan 25, 2013 06:01 AM|LINK
Hi,
On my ASP.Net Production Server, there is no MS-Office but for working with Excel (Like Reading and Exporting textual Table) we have installed AccessDatabaseEngine_x64.exe .
Now While Exporting textual Table we also want to export dynamic image formed by MS-Chart on .aspx page.
Paralelly we can not use Microsoft.Office.Interop.Excel.dll as we do not have installed MS-Office on Production Server.
So how we can export such type of dynamic MS-Chart image with data only in Excel ?
If anybody knows please let me know ?. It is highly appreciable.
Thanks in Advance
Rajesh Singh
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Export Image into Excel while there is no MS-Office on server in ASP.Net
Jan 27, 2013 12:19 AM|LINK
Hi,
It would be better if you can install Office program.
If you don't wanna install Office, you have to use javascript——document.print to print the whole WebPage.
Reguards！
hans_v
All-Star
35986 Points
6550 Posts
Re: Export Image into Excel while there is no MS-Office on server in ASP.Net
Jan 27, 2013 06:39 PM|LINK
No, it is NOT, because you shouldn't use Office Interop on a web server:
"Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment."
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2
Rajesh Kumar...
0 Points
9 Posts
Re: Export Image into Excel while there is no MS-Office on server in ASP.Net
Feb 13, 2013 10:42 AM|LINK
Hi ,
Thanks for your suggetion .we are not much more interested in Printing the page or Garph.
we are more interested in exporting the image with a Table ( this table are alraedy exporting) ,so that client can change the values and redraw the another Chart and compares this generated chart with old one of Exported MS-Chart.
Thanks
Rajesh Kumar...
0 Points
9 Posts
Re: Export Image into Excel while there is no MS-Office on server in ASP.Net
Feb 13, 2013 10:43 AM|LINK
Hi ,
Thanks for replying. So what will be the solution ?