This may be off the mark but I have always found it easier to save the table as a csv file and use Text::CSV to then parse that. I always prefer working with text but that's me.
HTH, Paul Kraus ----------------------- PEL Supply Company Network Administrator > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 27, 2004 7:20 AM > To: [EMAIL PROTECTED] > Subject: Dump Excel File to Database table > > Hi, > I've got my "Spreadsheet::ParseExcel" module and I can > parse it using the "Linux example: parsing" from Teodor > Zlatanov at > http://www-106.ibm.com/developerworks/linux/library/l-pexcel/ > but I'm not sure how it works. > > I need to upload an Excel Sheet to a database table and I'm > having trouble referencing individual cell values in order > to strip away headers, column names etc. > > If anyone has done something like this including a DB upload > and was willing to share some code samples I'd really > appreciate it. > > Mark > -------------------------------------- > This Email Was brought to you by > WebMail > A Netwin Web Based EMail Client > http://netwinsite.com/webmail/tag.htm > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > <http://learn.perl.org/> <http://learn.perl.org/first-response> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
