topic Re: Creating an .xlsx file in EG and have np but when I run the program in UNIX I get a corrupt fil in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776563#M39797 PROC EXPORT<BR /> Tue, 26 Oct 2021 18:07:45 GMT AndrewL1 2021-10-26T18:07:45Z Creating an .xlsx file in EG and have np but when I run the program in UNIX I get a corrupt file https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776561#M39795 <P>Hi I am able to produce a 4 sheet report with 3 columns when running from SAS EG but when I run the same report but run the SAS program using UNIX it is returning a corrupt file with all 3 headers missing but only the first two columns blank. I open it and it tells me.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AndrewL1_0-1635271136010.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/65060iC713C375FED0451E/image-size/medium?v=v2&amp;px=400" role="button" title="AndrewL1_0-1635271136010.png" alt="AndrewL1_0-1635271136010.png" /></span></P><P>I saw that if I change the XLSX file ext to .zip I can then few the /xl/sharedString.xml but was having a hard time trying to figure out where column 13912 is because it opens in Wordpad.&nbsp;</P><P>&nbsp;</P><P>Thank you</P> Tue, 26 Oct 2021 18:00:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776561#M39795 AndrewL1 2021-10-26T18:00:34Z Re: Creating an .xlsx file in EG and have np but when I run the program in UNIX I get a corrupt fil https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776562#M39796 How are you creating the XLSX file? Tue, 26 Oct 2021 18:04:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776562#M39796 Reeza 2021-10-26T18:04:44Z Re: Creating an .xlsx file in EG and have np but when I run the program in UNIX I get a corrupt fil https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776563#M39797 PROC EXPORT<BR /> Tue, 26 Oct 2021 18:07:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776563#M39797 AndrewL1 2021-10-26T18:07:45Z Re: Creating an .xlsx file in EG and have np but when I run the program in UNIX I get a corrupt fil https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776566#M39798 And transferred to Windows with a binary setting? Tue, 26 Oct 2021 18:10:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776566#M39798 Reeza 2021-10-26T18:10:31Z Re: Creating an .xlsx file in EG and have np but when I run the program in UNIX I get a corrupt fil https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776568#M39799 How do I set that? It just creates the file in a folder. Tue, 26 Oct 2021 18:12:48 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Creating-an-xlsx-file-in-EG-and-have-np-but-when-I-run-the/m-p/776568#M39799 AndrewL1 2021-10-26T18:12:48Z