topic Re: Error on SAS program that uses Perl tag set to create Excel workbooks. in Administration and Deployment

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

zqkal — Wed, 17 Apr 2013 16:45:56 GMT

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

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

SASKiwi — Fri, 19 Apr 2013 02:12:56 GMT

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.

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

zqkal — Thu, 02 May 2013 18:01:17 GMT

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.