Hello,
I am using the Spreadsheet::WriteExcel perl module to create reports from a database that can be emailed to people who need them in windows excel format. Everything is going well (this is a great module) but one of the users has complained about how it prints off. The report is over 1000 rows and 7 columns across. But the print setup cuts it off at the third column, which looks absolutely stupid! There are some page set-up methods that I have been trying and some of them work, but I can't seem to force it to fit all the way across. I tried using:
$worksheet->set_landscape();
$worksheet->repeat_rows(3);
$worksheet->set_v_pagebreaks(7);
The repeat rows works fine to print out my titles on every page, but the set_v_pagebreaks() does not seem to work? Any help? This is a dynamic report run monthly so I don't know how many rows it will be, but it will always be 7 columns.
Later
I am using the Spreadsheet::WriteExcel perl module to create reports from a database that can be emailed to people who need them in windows excel format. Everything is going well (this is a great module) but one of the users has complained about how it prints off. The report is over 1000 rows and 7 columns across. But the print setup cuts it off at the third column, which looks absolutely stupid! There are some page set-up methods that I have been trying and some of them work, but I can't seem to force it to fit all the way across. I tried using:
$worksheet->set_landscape();
$worksheet->repeat_rows(3);
$worksheet->set_v_pagebreaks(7);
The repeat rows works fine to print out my titles on every page, but the set_v_pagebreaks() does not seem to work? Any help? This is a dynamic report run monthly so I don't know how many rows it will be, but it will always be 7 columns.
Later