PHP Classes

how?

Recommend this page to a friend!

      eiseXLSX  >  All threads  >  how?  >  (Un) Subscribe thread alerts  
Subject:how?
Summary:does it work
Messages:25
Author:synthetron
Date:2014-04-25 13:37:41
Update:2014-05-21 07:42:14
 
  1 - 10   11 - 20   21 - 25  

  1. how?   Reply   Report abuse  
Picture of synthetron synthetron - 2014-04-25 13:37:41
can u give ecxample


how to open xlsx

change cell


write back to xlsx

  2. Re: how?   Reply   Report abuse  
Picture of Ilya Eliseev Ilya Eliseev - 2014-05-15 11:11:06 - In reply to message 1 from synthetron
Hello.

You can find an example here:
code.google.com/p/eisexlsx/

  3. Re: how?   Reply   Report abuse  
Picture of synthetron synthetron - 2014-05-16 16:08:19 - In reply to message 2 from Ilya Eliseev
is not working


gives a criple xlsx file unreadable in excel
and errors in display
Deprecated: Function split() is deprecated in C:\wamp\www\welcome\xlsx\eiseXLSX.php on line 508
Call Stack
# Time Memory Function Location
1 0.0015 671432 {main}( ) ..\examplewrite.php:0
2 0.0086 1285768 eiseXLSX->__construct( ) ..\examplewrite.php:26
3 0.0222 1312936 eiseXLSX->getPathByRelTarget( ) ..\eiseXLSX.php:89


idem for the reader



  4. Re: how?   Reply   Report abuse  
Picture of Jaime Sanchez Jaime Sanchez - 2014-05-16 16:21:56 - In reply to message 3 from synthetron
According to that, this isn't working on PHP 5.3, because split() function is deprecated from this version on. Try it on PHP 5.2 and tell us if it works.

  5. Re: how?   Reply   Report abuse  
Picture of synthetron synthetron - 2014-05-16 16:39:44 - In reply to message 4 from Jaime Sanchez
got only 5.3.4


cant we replace split() ?

  6. Re: how?   Reply   Report abuse  
Picture of synthetron synthetron - 2014-05-16 16:41:36 - In reply to message 5 from synthetron
by explode()

  7. Re: how?   Reply   Report abuse  
Picture of synthetron synthetron - 2014-05-16 16:42:36 - In reply to message 6 from synthetron

  8. Re: how?   Reply   Report abuse  
Picture of synthetron synthetron - 2014-05-16 16:48:56 - In reply to message 7 from synthetron
// get directory path of rel file
$relFileDirectory = preg_replace("/(_rels)$/", "", dirname($relFilePath));
$arrPath = preg_split("//", rtrim($relFileDirectory, "/"));

// calculate path to target file
$arrTargetPath = preg_split("//", ltrim($targetPath, "/"));



gives errors


( ! ) Warning: Invalid argument supplied for foreach() in C:\wamp\www\welcome\xlsx\eiseXLSX.php on line 107
Call Stack
# Time Memory Function Location
1 0.0023 671416 {main}( ) ..\examplewrite.php:0
2 0.0262 1285768 eiseXLSX->__construct( ) ..\examplewrite.php:26
#0 eiseXLSX_Exception->__construct(can't select sheet #1) called at [C:\wamp\www\welcome\xlsx\eiseXLSX.php:374]
#1 eiseXLSX->selectSheet(1) called at [C:\wamp\www\welcome\xlsx\eiseXLSX.php:123]
#2 eiseXLSX->__construct(templates) called at [C:\wamp\www\welcome\xlsx\examplewrite.php:26]

( ! ) Fatal error: Uncaught eiseXLSX error: can't select sheet #1 thrown in C:\wamp\www\welcome\xlsx\eiseXLSX.php on line 374

  9. Re: how?   Reply   Report abuse  
Picture of synthetron synthetron - 2014-05-16 16:58:09 - In reply to message 8 from synthetron
with explode no errors

but still criple unreadable file

  10. Re: how?   Reply   Report abuse  
Picture of synthetron synthetron - 2014-05-16 17:19:20 - In reply to message 9 from synthetron
reader works on normal xlsx files and on file generated xlsx

by


include_once "eiseXLSX.php";

$xlsx = new eiseXLSX("templates");

$xlsx->data('R15C10', 'Hello, world!'); // either A1 or R1C1 are accepted

$xlsx->Output("myfile.xlsx", "F"); // save the file

but this file cannot be read by excel

 
  1 - 10   11 - 20   21 - 25  
For more information send a message to info at phpclasses dot org.