Excel to PHP array, possible and how?

Question

I have a big excel file that looks like this:

enter image description here

I would like to put each row into an array.

Is this possible to access the first row's order id like this?

$result[0][2] // returns 7432

Assuming the actual first row that gives prefix for the columns' name is not present.

How could I do that?

Haim Evgi · Answer 1 · 2020-06-29T04:04:42.457

23

I recommended to use PHPEXCEL library

https://github.com/PHPOffice/PHPExcel

you can see an example

Update: Now the alternative to this library is phpspreadsheet

edited Jun 29 '20 at 04:04

answered Nov 17 '11 at 16:19

Haim Evgi

123,187
45
217
223

looks like PHPExcel - DEAD – Elyor Jun 28 '20 at 15:31

score 19 · Accepted Answer · answered Nov 17 '11 at 16:20

19

Save the spreadsheet as a CSV, then use PHP's built-in CSV functions. See the sample code here:

http://php.net/manual/en/function.fgetcsv.php

answered Nov 17 '11 at 16:20

Dan

537
2
7

2

This does not answer the question. It's asked to read Excel directly, not CSV. – Ömer An May 14 '20 at 19:26
Although it does not answer, in a literal way, the question, it solves the problem, though. – Valentoni Jun 13 '23 at 01:28

score 9 · Answer 3 · answered Apr 17 '15 at 19:34

May be my answer is too simple (for one time work only), but I use the CONCATENATE "Function" in excell. The last cell on each row will have concatenation function, like this:

=CONCATENATE("['";A2;"'=>['data1' => '";B2;"', 'data2' => '";C2;"'],")

where:

column "A" is ID of something;
column "B" is first characteristic;
column "C" is second characteristic;
etc.

Then just copy and paste function results to Your script or config file, and do not forget the first and the last bracket.

CONCATENATE ftw! Thanks! – Yannis Dran Sep 30 '15 at 08:12 — Yannis Dran, Sep 30 '15 at 08:12

score 5 · Answer 4 · edited Jul 10 '15 at 08:29

5

This works for me:

$content = file_get_contents($your_file_path); 
$lines = array_map("rtrim", explode("\n", $content));

edited Jul 10 '15 at 08:29

Lars Ebert

3,487
2
24
46

answered Jul 10 '15 at 06:19

paulalexandru

9,218
7
66
94

Saed Yousef · Answer 5 · 2020-05-17T05:25:01.260

2

Since the PHPExcel library deprecated they've released "PhpSpreadsheet"

This will help PhpSpreadsheet

edited May 17 '20 at 05:25

answered Oct 28 '18 at 10:07

Saed Yousef

118
1
10

@ÖmerAn Try this https://phpspreadsheet.readthedocs.io/en/latest/ – Saed Yousef May 17 '20 at 05:24

Excel to PHP array, possible and how?

5 Answers5

Linked