Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Re: automatic thank you!

by csuhockey3 (Curate)
on Aug 28, 2003 at 06:19 UTC ( [id://287260]=note: print w/replies, xml ) Need Help??


in reply to Re: automatic thank you!
in thread automatic thank you!

The spreadsheet is not Excel, but in Star Office. I was going to extract to a flat file, like I have done once before (read in the spreadsheet, tab delimited). DBIx::HTML looks cool though, I will look into playing with that a little. I used Star Office because I run a Linux box and my buddy has a Mac G4. Do you think I could 'print to file' from SO to an Excel spreadsheet and read it that way with Spreadsheet::ParseExcel? I have Never tried that before.
Great input, thanks!

csuhockey3

Replies are listed 'Best First'.
Re: Re: Re: automatic thank you!
by CountZero (Bishop) on Aug 28, 2003 at 17:56 UTC

    Well I've never used Star Office and I don't know if it has an Excel compatible output format.

    But as it has the possibility to output a flat tab-delimited file, you can use DBD::CSV to read that.

    CountZero

    "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law

      Yes, indeed! It has 'specially' Excel output format.

      Besides, I would suggest a special font that might look exactly like a handwritten text (quite big and in italics). It is visually evident that it is not handwritten, but when you asociate the heartly content of the letter with that font you end thinking in the human handwritting.

      You could also help that impression if you choose a normal paper context (that is, no dark background with a clear foreground).

      Choose photographs with big faces in it and little background.

      Use wooden combination of colours that are more more home suggesting themes. At least, colours from the nature!

      A nice frame for the photograph also suggest some craftmade thing!

      You could even scan the signature!

      Enjoy your ilusion!

Re: Re: Re: automatic thank you!
by gsiems (Deacon) on Aug 29, 2003 at 02:59 UTC
    I've been using Spreadsheet::ParseExcel with OpenOffice on my Linux box with great results. In Open/StarOffice, save the spreadsheet as Excel, then fire up Spreadsheet::ParseExcel and have fun. The version of Excel that you save as doesn't seem to matter, be it Excel5, 95, or 97/2000/xp unless you have cells that have > ~ 254 characters of text, in which case saving it as Excel5 will truncate the contents of those cells.

    When I started doing this I was rather amused to be writing Excel spreadsheets on a Linux box using perl to be read/edited using OpenOffice with the results being read using perl-- the only thing Microsoft was the format. That said, it would be nice to have a Spreadsheet::ParseOpenOffice and Spreadsheet::WriteOpenOffice module...

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://287260]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (8)
As of 2024-04-18 11:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found