Architecting, installing and maintaining your SAS environment

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

Accepted Solution Solved
Reply
Contributor
Posts: 47
Accepted Solution

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

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


Accepted Solutions
Solution
‎05-02-2013 02:01 PM
Contributor
Posts: 47

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

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.


View solution in original post


All Replies
Super User
Posts: 3,252

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

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.

Solution
‎05-02-2013 02:01 PM
Contributor
Posts: 47

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

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.


🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 334 views
  • 0 likes
  • 2 in conversation