Hi,
I am emailiing mainframe PS file as attachment in excel file format.
the excel file name is more than 31 chars for ex ."Test format pro marketing - All - time test data for verification".
when i opened the file using excel the work book name is proper,however sheet is truncated at 31 char for ex "Test format pro marketing - All - t"
How to set the excel sheet name different from theexcel work book while sending email attachemnt from mainframes.
Please suggest.
The maximum length of a worksheet name in Excel is 31 characters, period. No way around that.
Hi,
Thanks for quick response..
is it possible to set workbook name and sheet name different..
for a given Mainframe file name - test.sample
for ex. work book name as sample.xlsx
worksheet name as sheettest
Thanks
Mallik
I have no idea if libname xlsx works on a mainframe; if it does (SAS/ACCESS to PC Files must be installed and licensed), you can treat the workbook like a SAS library, and each "dataset" written to it will be a sheet.
How you address a Excel file on the mainframe is a different beast, though. See "z/OS file catalog".
FWIW, I never ever export to Excel directly, I always use csv as transfer format. Textuality rules. Let the recipients cobble the data together in Excel, if they want.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.