excel file read rows and columns - php

Question

$arr=array();
$row = -1;
if (($handle = fopen("out.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);

        $row++;
        for ($c = 0; $c < $num; $c++) {
            $arr[$row][$c]= $data[$c];
        }
    }
    fclose($handle);
}

I'm using this code to read excel file data, this code counts elements in a row that are divided by comma (,),

Name, Surname, Num, Tel

Name
Surname
Num
tel

but in one field I have word Orginal, and this code also divides element by that word like this:

Orgina
l

and in that way, I receive wrong elemnts, any help?

Can you show the actual file you are trying to read with the content causing the problem so others can reproduce the issue. — Nigel Ren
– Nigel Ren, Commented Dec 17, 2019 at 7:00
Show the picture of this part of file, perhaps there's a problem inside this row, not in code. — Aksen P
– Aksen P, Commented Dec 17, 2019 at 7:01
BTW - you could replace the entire code in the loop with $arr[] = $data; if you just want to copy all of the array. — Nigel Ren
– Nigel Ren, Commented Dec 17, 2019 at 7:04
@NigelRen i updated description. I insert row how it looks in editor — user11940263
– user11940263, Commented Dec 17, 2019 at 9:34

Nigel Ren · Accepted Answer · 2019-12-17 09:38:57Z

1

In the line

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {

the 1000 is the maximum length of data to read, as your data (in the example posted) has more than that, it will split the data.

To allow it to read the data properly you can just leave the second and third parameters as defaults ( null for length - in other words any length and the default delimiter is a comma anyway...

while (($data = fgetcsv($handle)) !== FALSE) {

answered Dec 17, 2019 at 9:38

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

excel file read rows and columns - php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related