Login   Register  
PHP Classes
elePHPant
Icontem

documentation and example

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

      Basic Excel  >  All threads  >  documentation and example  >  (Un) Subscribe thread alerts  
Subject:documentation and example
Summary:more documentation and full example
Messages:6
Author:V P
Date:2013-08-07 07:51:56
Update:2014-01-21 18:57:51
 

  1. documentation and example   Reply  
Picture of V P
V P
2013-08-07 07:51:56
Hello,
I am looking for more information about this class.

Link http://www.omnihost.co.nz/ returns no documentation.
Do you provide a complete documentation?
Can you put an example with all the page in php? (with includes, Requires)
And folder structure of your site.

I created a folder BasicExcel by putting all the files in the archive.
I took the example of creating an xsl file in the include file xsl.php and AbstractWriter.php.
But he said he does not know the Xsl class.
"Fatal error: Class 'BasicExcel\Writer\Xsl' not found"

Here is my code:

require_once("BasicExcel/AbstractWriter.php");
require_once("BasicExcel/Writer/Xls.php");

$data = array(
array('Nr.', 'Name', 'E-Mail'),
array(1, 'Jane Smith', 'jane.smith@fakemail.com'),
array(2, 'John Smith', 'john.smith@fakemail.com'));

try {
$csvwriter = new \BasicExcel\Writer\Xsl();
$csvwriter->fromArray($data);
$csvwriter->download('myfilename.csv');
}catch(Exception $e){
echo $e->getMessage();
exit;
}

Thank you

  2. Re: documentation and example   Reply  
Picture of V P
V P
2013-08-07 08:48:43 - In reply to message 1 from V P
It's ok.
I have my xls file to create.

I made ​​changes because I could not handle spaces "namespace".

Thank you for this class.

  3. Re: documentation and example   Reply  
Picture of Jaime Sanchez
Jaime Sanchez
2013-08-07 15:54:07 - In reply to message 2 from V P
did it worked for you??
I tried that i got the workbook with this line:
"Filename mimetype must be .xml or .xls"

  4. Re: documentation and example   Reply  
Picture of V P
V P
2013-08-07 21:01:00 - In reply to message 3 from Jaime Sanchez
Yes it works for me.
But after a few changes in the code.
I'm just used me for export now.

I remove all the "namespaces" files.
I used the traditional classes.

it's my code:
AbstractWriter.php
<?php
Class AbstractWriter {

protected $handle;

public function writeFile($filename) {
$this->handle = @fopen($this->filename($filename
…..


Writer / Xls.php
<?php
class Xls extends AbstractWriter {
/**
* MicrosoftXML Header for Excel
* @var string
*/

const sHeader = "<?xml version=\"1.0\" encoding=\"%s\"?\>\n<Workbook xmlns=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:x=\"urn:schemas-microsoft-com:office:excel\" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\" xmlns:html=\"http://www.w3.org/TR/REC-html40\">";

/**
* MicrosoftXML Footer for Excel
* @var string
*/
…..


main.php

<?php
Require_once(“AbstractWriter.php”);
Require_once(“Writer/Xls.php”);

$data = array(
array(
array('first', 'second', 'third'),
array(‘first test, 'second test', 'third test'),
array(123, 456, 789)
)
);

try {
$writer = new Xls();
$writer->fromArray($data);
$writer->download($MyFilename);
}catch(Exception $e){
echo $e->getMessage();
exit;
}


With this code I can generate my xls file without problems.

  5. Re: documentation and example   Reply  
Picture of Craig Smith
Craig Smith
2013-08-20 21:20:17 - In reply to message 4 from V P
We are working on example files and documentation
the classes are used in a large project we are working on and undergoing fixes / updates as we finalise this section.

  6. Re: documentation and example   Reply  
Picture of Solange
Solange
2014-01-21 18:57:51 - In reply to message 5 from Craig Smith
don't work for export to xlsx :(, Excel say "the file is damage2 :(