+ 19

Report 📚📚📚

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?

29th Dec 2017, 2:52 PM
Sintsand
Sintsand - avatar
5 Answers
+ 16
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
30th Dec 2017, 5:44 AM
Sintsand
Sintsand - avatar
+ 14
is it dont need another software for it? or just use a code?
30th Dec 2017, 3:35 AM
Sintsand
Sintsand - avatar
+ 1
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.
30th Dec 2017, 1:40 AM
Frédéric Charette
Frédéric Charette - avatar
+ 1
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.
30th Dec 2017, 5:12 AM
Frédéric Charette
Frédéric Charette - avatar
+ 1
You're welcome. :)
30th Dec 2017, 5:45 AM
Frédéric Charette
Frédéric Charette - avatar