Report 📚📚📚

Question

How to make the web programm integrated with report?
When I make a web program with MySQL database, I want to get a report based on the database but print it automaticaly on Ms. Excell..
do you have an advice?

Answer 1

thanks @Frederic
thats really help..
I need for my program, I will try it because I use PHP and jQuery for my program and use SQL for the database

Answer 2

is it dont need another software for it?
or just use a code?

Answer 3

You're welcome. :)

Answer 4

Personally, I think the simple answer would be to export as CSV and load to excel; unless your program executes on the server side to do the excel spreadsheet then download the XLS on the client side.

Answer 5

it really depends on your server side application language. I know Python supports Excel, but other languages, such as PHP will also allow CSV creation with just code.

as an example: http://www.the-art-of-web.com/php/dataexport/

(please note that I would not personally download the CSV file as XLS but rather .CVS which excel will recognize and open by itself). Of course, if you have access to MS Excel on the server side, or other software to do the conversion (there are probably similar APIs or other librairies that will enable you to convert the data into a formatted spreadsheet)which you can then simply reference with code to download. :)

At my previous job, I was in charge of the reporting automation and I had built Excel scorecelards for multiple reports which I was automatically creating on my secondary system (I had turned a secondary machine into a server) and was working my coding into turning the reports into daily web downloads (finally moved on to a different job before I finished the web server aspect; but it was coming along) and part of my automation was opening Excel and loading the data in the spreadsheet; then saving the output as PDF as well as excel exports (depending on the reports). I would have had simply to have setup a web script to start the report creation and fetch the new report to pull the download. (I also had an outlook automation that was taking a screenshot, adding it to Outlook and sending an email with the report to distribution lists.

Answer 6

very cool