Re^2: Automation for pulling huge data from greenplum database in perl.

Hi roboticus thanks for your reply

i agree with your point that shell script is bit tough but its the best current option for us.

you also mentioned about Excel::Write::XLSX module actually i haven't done R&D on this module.the ExcelWrite module can generate excel file for office 2003 i guess as per my knowledge it can accommodate less then 3 lacks records .lets see how its work.

Comment on Re^2: Automation for pulling huge data from greenplum database in perl.

Replies are listed 'Best First'.
Re^3: Automation for pulling huge data from greenplum database in perl. by roboticus (Chancellor) on Sep 23, 2012 at 00:38 UTC
sarf13: Excel::Write::XLSX is written by the same John McNamara (he's here frequently) responsible for Spreadsheet::WriteExcel, and both modules are quite handy. If you need Office 2003 compatibility, then you're probably better off with Spreadsheet::WriteExcel. But you'll have to keep the row limits in mind (not really all that big a deal, you can just start a new worksheet once you hit a certain row number). ...roboticus When your only tool is a hammer, all problems look like your thumb.	[reply]

Replies are listed 'Best First'.

Re^3: Automation for pulling huge data from greenplum database in perl.
by roboticus (Chancellor) on Sep 23, 2012 at 00:38 UTC

sarf13:

Excel::Write::XLSX is written by the same John McNamara (he's here frequently) responsible for Spreadsheet::WriteExcel, and both modules are quite handy. If you need Office 2003 compatibility, then you're probably better off with Spreadsheet::WriteExcel. But you'll have to keep the row limits in mind (not really all *that* big a deal, you can just start a new worksheet once you hit a certain row number).

...roboticus

When your only tool is a hammer, all problems look like your thumb.

[reply]