Login   Register  
PHP Classes
elePHPant
Icontem

xlsx error:

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      Simple XLSX  >  All threads  >  xlsx error:  >  (Un) Subscribe thread alerts  
Subject:xlsx error:
Summary:Entry not found: xl/sharedStrings.xml
Messages:9
Author:Mikhail Partanskiy
Date:2013-04-01 21:49:55
Update:2013-08-09 10:19:41
 

  1. xlsx error:   Reply   Report abuse  
Picture of Mikhail Partanskiy
Mikhail Partanskiy
2013-04-01 21:49:55
Thank you for your parsing. Yesterday I caught something new from it.

$xslx->error(); gives me

xlsx error: Entry not found: xl/sharedStrings.xml

If I open the file in MS office excel and resave it, the parsing works nice.
I would like to attach my original xlsx file here but cannot. I guess this file just wasn't created correct. Anyway would be nice to parse it without resave. What can you advise?

  2. Re: xlsx error:   Reply   Report abuse  
Picture of Sergey Shuchkin
Sergey Shuchkin
2013-04-02 03:03:56 - In reply to message 1 from Mikhail Partanskiy
in simplexlsx.class.php 0.6.5

try uncomment 401 and comment 402

  3. Re: xlsx error:   Reply   Report abuse  
Picture of Mikhail Partanskiy
Mikhail Partanskiy
2013-04-02 09:02:54 - In reply to message 2 from Sergey Shuchkin
Thank you for quick answer, Sergey.

Yes, I tried to use

$aP = unpack('v1VN/v1GPF/v1CM/v1FT/v1FD/V1CRC/V1CS/V1UCS/v1FNL', $vZ);
//$aP = unpack('v1VN/v1GPF/v1CM/v1FT/v1FD/V1CRC/V1CS/V1UCS/v1FNL/v1EFL', $vZ);

The files is parsed with another errors "xlsx error: Entry not found: _rels/.rels"
And old files that was parsed successful before is parsed now with same error "xlsx error: Entry not found: _rels/.rels"

  4. Re: xlsx error:   Reply   Report abuse  
Picture of Sergey Shuchkin
Sergey Shuchkin
2013-04-02 09:50:00 - In reply to message 3 from Mikhail Partanskiy
чем сгенерирован изначальный xlsx? я в аське 241827819 - высылай файл, разберемся

  5. Re: xlsx error:   Reply   Report abuse  
Picture of Sergey Shuchkin
Sergey Shuchkin
2013-04-02 10:12:20 - In reply to message 3 from Mikhail Partanskiy
)))


send me xlsx (my email in class source)

  6. Re: xlsx error: Hello Sergey   Reply   Report abuse  
Picture of Perehod Roman
Perehod Roman
2013-08-08 09:10:42 - In reply to message 5 from Sergey Shuchkin
Sorry for my English, I from Belarus.

Have the same proble, try to parse the xlsx file and script show error: xlsx error: Entry not found: xl/sharedStrings.xml, then resave a file and all okey.

Can you help me with that problem?

  7. Re: xlsx error:   Reply   Report abuse  
Picture of Sergey Shuchkin
Sergey Shuchkin
2013-08-09 04:23:53 - In reply to message 6 from Perehod Roman
poprobui 0.6.6

  8. Re: xlsx error:   Reply   Report abuse  
Picture of Perehod Roman
Perehod Roman
2013-08-09 07:54:20 - In reply to message 7 from Sergey Shuchkin
privet,
oshibki propali, spasibo bolshoe,
no teper kogda parsim danie, on otdaet vse yacheyki pustie krome chislovih.
chto to s failom excel, no posle peresoxranenia vse ok =)

  9. Re: xlsx error:   Reply   Report abuse  
Picture of Sergey Shuchkin
Sergey Shuchkin
2013-08-09 10:19:41 - In reply to message 8 from Perehod Roman
see lines 590-602 to know how sharedStrings reads from xlsx
your xl/_rels/workbook.xml.rels must have link to shared strings

like this

<Relationship Id="rId6" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/sharedStrings" Target="sharedStrings.xml"/>