Note: I know the thread is a bit old, but the usefulness of CSV for file transfer has a pretty general applicability. So here goes...
"McMahon, Christopher x66156" wrote: > -----Original Message----- > From: Paul Kraus [mailto:[EMAIL PROTECTED] > Sent: Friday, June 27, 2003 9:56 AM > >To: [EMAIL PROTECTED] > >Subject: Linux, Perl, [open,star]office > > >I have a windows app that reads a bunch of text files and then using > >Win32::OLE it inserts that data into an excel spreadsheet. Is there > >something similar I can do with an open office document in Linux? > > >I am trying to switch my workstation over to all Linux but need to be > >able to generate the same reports that I then send to my boss. Which has > >to be an excel file. Which open office is able to open/write/create. > > >Paul > > A few days ago I wrote a little Perl script that sticks commas into > text files such that Excel can read them as CSV files. It's a really > simple-minded use of the "substr" function, but it gets the job done. > Particularly useful if the text data in question is always in the same > format byte-for-byte. > -Chris I'll second the concept of CSV--although I would hope the OP doesn't need to hand-insert anything in his files. CSV should be avaiable as an export or import function for either spreadsheet or database data. It of course cannot express the metadata very well, but spreadsheet formulae could be sent as a separate CSV file, although it seems a bit primitive. Joseph [OT: Wow, only 237 unread posts remaining in my Beginners-Perl folder! I'm catching up] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
