| rmah | it's a little perl program |
| jkr | Give it to me ;) |
| rmah | write one yourself |
| whitenoyce | hah what an asshole |
| jkr | I'm lazy |
| rmah | tough |
| whitenoyce | lol |
| jkr | And people keep telling me that reinventing the wheel is stupid :D |
| whitenoyce | unless they're stingy bastids |
| rhizo | perhaps Spreadsheet::TieExcel |
| jkr | rhizo: That needs excel to be running in the background, and I'm using Linux |
| ion_bidon | Jmax-: still need the letter combination script ? |
| jkr | It uses Win32::OLE |
| rindolf | Hi all. |
| rhizo | jkr: http://search.cpan.org/search?query=excel&mode=all explore your options |
| jkr | rhizo: Yes, I actually did search |
| rmah | I don't see the problem here Read the file, modify the resulting data structures, write the data structures back to the file simple as pie |
| ion_bidon | rindolf: hi |
| action | CPAN upload: Games-Bowling-Scorecard-0.101 by RJBS |
| CPAN | upload: Games-Bowling-Scorecard-0.101 by RJBS |
| whitenoyce | arg, i'm getting screwed at my website |
| jkr | rmah: Give me an example for such a data structure as "reading the file" would return |
| whitenoyce | people looking for star wars are finding Sectaurs instead because of soundex |
| rmah | jkr, you could read the docs, but... worksheets, rows, columns, cells, formating, data |
| PY1NB | $a = "\-{15,}"; if ( $line =~ /$a/ ) { last;} ----- should this work, or whould I escape $a in someway? |
| rmah | soundex is pretty crappy :-) |
| jgonzalez_ | hi |
| jkr | The problem is that the sheet I have to modify is rather complex with lots of different cell attributes, embedded graphics and so on :( |
| jgonzalez_ | are there any way to insert c code into a perl program ? |
| rmah | jgonzalez_: Inline::C |
| jorvis | is it a known problem that perl's gzip IO layer doesn't handle file appends correctly? |
| rmah | jorvis: no |
| jkr | rmah: Btw, what documentation? Is there a specification for the excel format somewhere? |
| rmah | and there is no "perl's gzip IO layer", Compress::Zlib is uses the industry-standard zlib library |
| whitenoyce | any clues on my question earlier? |
| ion_bidon | eval: $line="----------------"; $a = "\-{15,}"; if ($line =~ /$a/) { print "yes"; } |
| buubot | ion_bidon: yes 1 |