biswanath_c:

I routinely generate large (a dozen sheets, 10,000+ lines per sheet) spreadsheets with DBI and Spreadsheet::WriteExcel, and haven't found any problems with the modules. I've had the symptoms you describe when something else in the program causes the program to die, though.

It hasn't happened in a while, but ISTR that adding an explicit close() to the workbook will work around the problem until I discover what the problem actually *is*.

Update: I forgot to answer one of your questions: I don't know of any limit on rows from DBI, but I've successfully pulled down over 100,000 before. (I've probably done a million, but I'm not certain.)

...roboticus