Excel Processing

OldManRiver

All,

Looking for help with reading/processing/writing Excel in PHP.

Have post on this at:

http://forums.codewalkers.com/php-coding-7/excel-processing-868196.html#post167558

All help appreciated!

Thanks!

OMR

wilku

I have used a class found on PHPClasses that used excell COM object to read/write/process xls files and it went smoothly. I managed to calculate formulas, change colors, save as other files, etc. . It just needs excel installed on the server (i.e. it has to be windows based server).
Of course you can use [man]com[/man] functions directly with excel.application object.

OldManRiver

All,

Maybe you didn't notice, but this project turned out to be much larger than I thought.

Anyway I finally got all the reading done and now working on writing the second file.

I had to break up the output into two (2) MySql tables as 1.) one table deals with header and footer information, for both input and output EXCEL files and 2.) the second table deals with itemized rows.

In particular this is a problem as you notice the output EXCEL file only has ten (10) rows to write into, and the input EXCEL file has 300 rows of data. Now selection (query) of data from the first input file is on the "QTY" column, which we ignore if blank, so usually less than 10 rows are active. But when more than 10 row result from the query, then new rows have to be inserted into the output EXCEL file, conserving the formatting from the row above and then renumbering column one, for all remaining detail item rows.

I'm uploading the source for where I'm at. I used:

[li]TBS to open/view the source file, [/li]
[li]Excel Reader to read my values[/li]

but now have to find a different class to write with.

If you have a single class that can do it all, it would be helpful and jumping in here to help will be appreciated.

All files at:

http://forums.devshed.com/php-development-5/excel-processing-499904.html#post1975942

Thanks!

OMR

OldManRiver

All,

Hey I got all it working but the write to the new SS.

On the subject of write, when I look at all the docs on the Excel Writer Classes, everyone assumes new file, new workbook, new worksheet.

Nothing could be further from my situation! I have a .XLT template with a specific "NAMED" worksheet that must be written to.

Therefore none of the docs fit my problem and I have not yet figured out how to find my worksheet in the writer. Finding worksheets seems to be a "READER" function not a "WRITER" function, so I seem to be at an impasse right now!

Suggestions on how to approach or solve this portion would help me get around my current road block.

Oh Hey I really did not mean to make anyone think I was leaning toward XML as the base of the code, when in fact I want to stay 100% PHP if possible. I can see, however from some of the code I submitted, where some might make that logical deduction. Therefore I give precedence to the PHP/Excel classes and only consider XML as last resort.

All help greatly appreciated!!!

Thanks!!!

OMR

OldManRiver

All,

Harish at:

http://www.phpclasses.org/browse/package/2037.html

suggested I use the PEAR class, get it working and then extract the class code to my other class libs when it works.

What do you think?

OMR