Error when loading an excel2000 file

Topics: Developer Forum, User Forum
Jan 12, 2010 at 7:20 PM

Hello,

I am new with PHPExcel. I have just installed your latest stable release on a IIS7 (w2k8) with php 5.2.1
Exemples are working fine, but when i try loading my own file from your example reader file i get the following error:
[12-Jan-2010 21:15:30] PHP Fatal error:  Call to undefined function mb_substr() in D:\www\IntranetV3\PHPExcel\Classes\PHPExcel\Reader\Excel5.php on line 2903

this is my php.ini extension.

[PHP_MBSTRING]
extension=php_mbstring.dll
[PHP_GD2]
extension=php_gd2.dll
[PHP_LDAP]
extension=php_ldap.dll
[PHP_MYSQL]
extension=php_mysql.dll
[PHP_ZIP]
extension=php_zip.dll
[PHP_CHD]
extension=phpchartdir520nts.dll

I can not see what's wrong as all your examples are working fine...

Hope someone can help,

Brgds,
VooDoo

Developer
Jan 14, 2010 at 1:51 AM

Not sure why it can't find mb_substr() in your particular case. Anyway, I created this work item because we should not rely on mbstring extension being available:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=11485

Try with latest source code tomorrow, I think it will work for you.

http://phpexcel.codeplex.com/SourceControl/list/changesets

Jan 15, 2010 at 7:59 AM

Koyama,
Thanks for your reply.
I have tested the code today again and had the same error.
I have run many test in the meantime, and realize that the problem was due to vb macro that was in the xls file.
The xl file containts a lot of textboxes that hide and display different areas of the xl file on tick/untick.
Actually I just need to open that file, fill in 5 cells, and save it.
Can phpExcel do this and keep all this textboxes??
----- Original Message -----
From: [email removed]
To: [email removed]
Sent: Thursday, January 14, 2010 3:51 AM
Subject: Re: Error when loading an excel2000 file [PHPExcel:80604]

From: koyama

Not sure why it can't find mb_substr() in your particular case. Anyway, I created this work item because we should not rely on mbstring extension being available:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=11485

Try with latest source code tomorrow, I think it will work for you.

http://phpexcel.codeplex.com/SourceControl/list/changesets

Coordinator
Jan 15, 2010 at 8:30 AM
voodoonet wrote:

I have run many test in the meantime, and realize that the problem was due to vb macro that was in the xls file.
The xl file containts a lot of textboxes that hide and display different areas of the xl file on tick/untick.
Actually I just need to open that file, fill in 5 cells, and save it.
Can phpExcel do this and keep all this textboxes??

 PHPExcel doesn't yet support VBA Macros or Excel forms.

I have been looking at support for VBA within PHPExcel, allowing VBA scripts to run within a PHP sandbox, principally to allow the use of user-defined functions within the calculation engine, and am at the first stage of a solution for this; but macros for working with forms could not be supported within PHPExcel until forms themselves are supported.

At present, VBA and forms are ignored by the PHPExcel readers, so they cannot be written back to the file when it is saved.