topic Re: Export to Excel with no formatting in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel-with-no-formatting/m-p/215410#M53024 <HTML><HEAD></HEAD><BODY><P>Ok thanks I will try that</P></BODY></HTML> Fri, 03 Apr 2015 12:04:24 GMT ertweety 2015-04-03T12:04:24Z Export to Excel with no formatting https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel-with-no-formatting/m-p/215408#M53022 <HTML><HEAD></HEAD><BODY><P>I have a sas program that exports data to an a tab in an excel workbook.&nbsp; It is basically a data dump with no formatting.&nbsp; The sas job is set to run daily when it replaces the data in the tab often the cells in the workbook will be randomnly filled in with colours.&nbsp; It's almost like the sheet takes colours from other tabs in the workbook but I don't know why.&nbsp; No formatting required.&nbsp; Here's my export code.</P><P></P><P><SPAN style="font-size: 10pt; font-family: Courier New;">PROC </SPAN><STRONG style=": ; color: #000080; font-size: 10pt; font-family: Courier New;">EXPORT</STRONG><SPAN style="font-size: 10pt; font-family: Courier New;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier New;">DATA</SPAN><SPAN style="font-size: 10pt; font-family: Courier New;">=adl</SPAN></P><P><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier New;">OUTFILE</SPAN><SPAN style="font-size: 10pt; font-family: Courier New;">= </SPAN><SPAN style="color: #800080; font-size: 10pt; font-family: Courier New;">"X:\Customer Service\2015_data.xlsx"</SPAN></P><P><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier New;">DBMS</SPAN><SPAN style="font-size: 10pt; font-family: Courier New;">=EXCEL97 </SPAN><SPAN style="color: #0000ff; font-size: 10pt; font-family: Courier New;">REPLACE</SPAN><SPAN style="font-size: 10pt; font-family: Courier New;">;</SPAN></P><P><SPAN style="color: #800080; font-size: 10pt; font-family: Courier New;">SHEET = "data"</SPAN><SPAN style="font-size: 10pt; font-family: Courier New;">; </SPAN></P><P><SPAN style="font-size: 10pt; font-family: Courier New;">RUN;</SPAN></P></BODY></HTML> Thu, 02 Apr 2015 19:49:21 GMT https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel-with-no-formatting/m-p/215408#M53022 ertweety 2015-04-02T19:49:21Z Re: Export to Excel with no formatting https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel-with-no-formatting/m-p/215409#M53023 <HTML><HEAD></HEAD><BODY><P>Your DBMS should be something like EXCEL, EXCELCS or XLSX but probably not EXCEL97</P></BODY></HTML> Thu, 02 Apr 2015 20:19:28 GMT https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel-with-no-formatting/m-p/215409#M53023 Reeza 2015-04-02T20:19:28Z Re: Export to Excel with no formatting https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel-with-no-formatting/m-p/215410#M53024 <HTML><HEAD></HEAD><BODY><P>Ok thanks I will try that</P></BODY></HTML> Fri, 03 Apr 2015 12:04:24 GMT https://communities.sas.com/t5/SAS-Procedures/Export-to-Excel-with-no-formatting/m-p/215410#M53024 ertweety 2015-04-03T12:04:24Z