Error on SAS program that uses Perl tag set to create Excel workbooks.

[zqkal]

I have a SAS program that uses Perl to create Excel workbook. I’m seeing an error massage on UNIX terminal whenever I run the program.

Maximum Spreadsheet::WriteExcel filesize, 7087104 bytes, exceeded. To create files bigger than this limit please refer to the "Spreadsheet::WriteExcel::Big" d

• ocumentation.

I have these at the beginning of the Perl program

use Spreadsheet::WriteExcel;

use Spreadsheet::WriteExcel::Big;

use Spreadsheet::WriteExcel::Utility;

use Spreadsheet::WriteExcel::Worksheet;

Does any one know how to fix this error? I’m new to Perl and don’t know what to do?

Thanks in advance for your help

[SASKiwi]

I suspect you would be better off googling this error or using a Perl forum to progress this problem since SAS is not creating the Excel workbook.

[zqkal · Accepted solution]

SASkiwi, you are right the problem wasn't from SAS.

I had to use Perl function writeexcel::big since the file was more than 7MB.

after adding WriteExcel::Big finction the tagset works.

Thanks

for your help.