PHP Classes

update simplexlsx

Recommend this page to a friend!

      Simple XLSX  >  All threads  >  update simplexlsx  >  (Un) Subscribe thread alerts  
Subject:update simplexlsx
Summary:fixed problems with xlsx (libreOffice)
Author:Andrzej Halejcio
Date:2013-02-10 23:44:15
Update:2013-02-11 09:13:51

  1. update simplexlsx   Reply   Report abuse  
Andrzej Halejcio - 2013-02-10 23:44:15

pls check my version,
i had problems with xlsx files from libreOffice, class doesnt work properly.
so....i made little changes.

(oreginal file)line: 298 main problem was somewhere here, with unpacking,
but your code was too smart for me :)
so i replaced it using simpler method with zip_open,etc. now it works fine for me. but im not sure is that ok for every case, so pls take a look on it.

(oreginal file)line: 477 libreoffice sheets starts counting from 2,
change: i cut off number from sheet name (sheet1.xml=>1), and use it as id in table, in libreOffice, first rId is file: style.xml, not sheet.

if u dont understand my english just check class with xlsx from libreOffice :)

  2. Re: update simplexlsx   Reply   Report abuse  
Sergey Shuchkin - 2013-02-11 00:18:38 - In reply to message 1 from Andrzej Halejcio
Thank u Andrzej, I'll see your code later

* zip_open - don't enabled on virtual hosting sometimes
* First sheet may be 1,2 or 4 - not fixed value

  3. Re: update simplexlsx   Reply   Report abuse  
Andrzej Halejcio - 2013-02-11 09:13:51 - In reply to message 2 from Sergey Shuchkin
ad.1 i feel that isnt so complicated without reason :D but maybe it was problem few years ago, who knows ;)

ad.2 ok, but what give me that i have 2,3,4, or 4,5,6 ?
isnt better 1,2,3 :) ? i check on files where sheets in software looks 1,2,3 but after parsing was 2,3,4.

Anyway, always u can add option/switch how to count sheets and we all be happy.