Would like to open up a excel file and read contents...

[spewn]

Hey...I have excel files with various rows and columns...is it possible to use perl to access the file and manipulate the contents, including writing to the spreadsheet?

Also, how many rows can excel handle, versus using mysql?

Thanks.

- g

 

[1DMF]

here are a few examples of modules you can use..

http://lena.franken.de/perl_hier/excel.html

http://www.adp-gmbh.ch/perl/excel.html

http://homepage.tinet.ie/~jmcnamara/perl/PerlExcelFaq.html

as for rows, I'm not sure if there is a physical limit, but memory/disk space obviously plays a factor and the more rows you have the more resource hungry your app will become.

i've seen people tout 10,000 as a guide line, but i'm not certain on this.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you.

 

[MillerH]

Spreadsheet::WriteExcel and Spreadsheet:arseExcel are my personal favorites:

http://search.cpan.org/search?query=Spreadsheet::WriteExcel

As for the size limit, there is a 7MB boundary that simply requires that you use a special module extension. I've also heard that there is a 150MB limit for the actual Excel application, but that has been fixed with the recent Vista release.

- Miller

 

[rharsh]

I can't speak to the physical disk size limit of 150MB that MillerH posted, but there is a limit of 65,535 rows and 255 columns (A through IV) on a single worksheet.

I haven't used office 2007 yet so those values could have changed, but they should be accurate through office 2003.

If you are getting anywhere near either of those limits, you should definitely consider using some form of database solution - MS Access, MySQL, something other than an Excel spreadsheet or flat text file.

 

[spewn]

here's what i have on my server, available to me:

Spreadsheet:arseExcel::Workbook
Spreadsheet:arseExcel::Utility
Spreadsheet:arseExcel:ump
Spreadsheet:arseExcel::FmtJapan
Spreadsheet:arseExcel::SaveParcel::Workbook
Spreadsheet:arseExcel::FmtDefault
Spreadsheet:arseExcel::FmtUnicode

which one would be the best for what i want?

- g

 

[MillerH]

These are all part of the greater ParseExcel package, and ParseExcel is only used for the parsing of excel files. It does not have the ability to write to them.

Hence, based of what you described in your requirements, none of them is best.

- M