Answer the question
In order to leave comments, you need to log in
How to unload a graph from a web form in MS Excel?
Hello!
For many days now I have been struggling with the problem of creating reporting for a business process. I will describe everything in order:
1) there is an Oracle database with a bunch of tables;
2) there is a web application written in asp.net;
3) in the application, through the web service, AJAX loading of data into a table on a web page is implemented.
4) a graph is drawn and displayed on the page as a picture in the "" tag.
Next, you need to implement the unloading of the table data into MS Excel and plotting the graph according to the data.
1) Through the "Active X Elements" it turns out to upload both the data and the graph in the form of a picture in EXCEL, but I don't like how MS EXCEL blinks, blinks, does somersaults with a flip before providing a formatted file for work;
2) Through the XSLT transformation, I create a file on the server and simply offer to download it by clicking the icon on the page. The only negative is that you can't insert graphics in any way.
Actually, the question is, how best to implement the saving of tabular data and graphics from an html page in MS Excel?
Answer the question
In order to leave comments, you need to log in
I dare to suggest an option.
Write a query to the server in Excel using VBA, and use the received data to build a graph using Excel.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question