How to create a MSEXCEL file using PHP

Question

Good day,

How do i create an msexcel file using php script? I have already prepared my data in a well structured array. I need to be able to format my array into tables in msexcel.

the server where the WAMP server is running has no MS Office installed, would it affect my objective to create the msexcel file. do i need to install on msoffice in the server in case? fyi, i dont actually need to save the excel file in the server but can be an option too.

thanks.

Please find very good answers at [Alternative for PHP_excel](http://stackoverflow.com/questions/3930975/alternative-for-php-excel) — Álvaro González, Oct 25 '11 at 10:52
Consider whether you actually need an Excel file - will a CSV do the job? — DaveRandom, Oct 25 '11 at 10:54

score 0 · Answer 1 · edited May 23 '17 at 12:27

0

This is really a spin on DaveRandoms comment.

Make a CSV and set the mimetype to any of the ones in this SO question.

That way Excel (or any equivalent application) will start and show the file.

edited May 23 '17 at 12:27

Community

1
1

answered Oct 25 '11 at 11:03

idstam

2,848
1
21
30

score 0 · Answer 2 · answered Mar 15 '12 at 18:12

0

The PHPExcel library will let you take your data and write it into a valid Excel file, whether you need old-style XLS or new style XLSX format.

You don't need to have Excel installed on the server to use it.

answered Mar 15 '12 at 18:12

Jason A. Lefkowitz

966
8
13

How to create a MSEXCEL file using PHP

2 Answers2