asked on 12/2/2015

How to export values in a database to an Excel sheet with php

I would like to ask you experts:
What is the best way to populate an Excel worksheet from a database with php?
I have an Excel worksheet containing headers and want to fill in values from the database in cells.
The database is on a web server.

PHP Microsoft Excel Databases

Last Comment

Lennart Ericson

12/4/2015

Excel amusant

12/2/2015

Not sure if I understand your question but if you are looking to import data from a table in web server here is the link which guide step by step.

http://www.howtogeek.com/howto/24285/use-online-data-in-excel-2010-spreadsheets/

Best,

Lennart Ericson

12/2/2015

ASKER

Thanks for the answer. I'll try to explain what I want to achieve.
The database contains more than 40 columns. Out of these I'd like to use 15. I have defined the columns I'd use and disregard the remaining columns.
I attach a Example_sheet.xlsxxlsx file as an example
So, I'd like to take data from the database and fill them in into the excel worksheet och predetermined places.
In the past I used an xml file that I populated with data from the database. What I am after is more of modern approach.
Hope this explains better what I am after.

Excel amusant

12/2/2015

Hi,

First import data from web table into excel sheet and then we can build a macro to automatically remove the unwanted columns.

Please send a sample file with all 40 columns and highlight unwanted columns. I will create a macro for that.

Best,

ASKER CERTIFIED SOLUTION

Ray Paseur

12/3/2015

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Lennart Ericson

12/4/2015

ASKER

Thanks Ray! Just what I meant.