in reply to Re: Spreadsheet::ParseExcel vs alternative Cell Handler
in thread Spreadsheet::ParseExcel vs alternative Cell Handler
Thanks for the help. What I am trying to do is just use Perl to convert a .xls table to a tab-delimited .txt file. This last one will suffer many inspections and processings - because of that I need the conversion, in order to avoid the weight of the .xls file all along the data analysis. At the end, having appended a last column "1" or "0" to each line of the tsv .txt, according to if itīs data is approved or not, the "1" lines are imported to the mysql database. Then, I use your Spreadsheet writter to give back the user the processed file with the error messages (when you implement the writte_comment theyīll go that way).
Well, thatīs the whole story. For the conversion, using only your cell handler, I would have to identify wich line and wich column is each cell from, in order to record it with a "\t" after or a "\n" if it's the last column of that row. It seems the code I was using before would manage to do that, if I put it inside your cell-handler, wouldnīt it? Or there is another way of doing it? Or is there another simpler way?
Thanks a lot, John.
André
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^3: Spreadsheet::ParseExcel vs alternative Cell Handler
by Andre_br (Pilgrim) on Jan 17, 2005 at 15:37 UTC |