https://communities.sas.com/t5/SAS-Programming/What-will-happen-when-we-export-to-excel-with-the-same-sheet/m-p/565256#M158681 Hi:<BR /> The answer depends on what your "script" or program uses to do the "export" -- are you doing PROC EXPORT? Are you using the LIBNAME engine for EXCEL or XLSX? Are you using ODS EXCEL? How you are creating CARDATA.XLSX or writing to it makes a difference.<BR /><BR />Cynthia Tue, 11 Jun 2019 14:20:38 GMT Cynthia_sas 2019-06-11T14:20:38Z https://communities.sas.com/t5/SAS-Programming/What-will-happen-when-we-export-to-excel-with-the-same-sheet/m-p/565248#M158675 <P>Hi everyone. I am out of office now and cant do any testing with SAS. I have a question in my mind right now.</P><P>&nbsp;</P><P>If i have a script that will write dataset into excel file that already exist in a folder.</P><P>For example:</P><P>My script will write dataset "CAR" to excel called cardata.xlsx with the sheetname "All Car"</P><P>&nbsp;</P><P>&nbsp;</P><P>What if cardata.xlsx already exist? Will the script prompt error saying sheetname "All Car" already exist and prompt error? or it will overwrite the entire xlsx fire?</P> Tue, 11 Jun 2019 14:05:06 GMT https://communities.sas.com/t5/SAS-Programming/What-will-happen-when-we-export-to-excel-with-the-same-sheet/m-p/565248#M158675 imdickson 2019-06-11T14:05:06Z https://communities.sas.com/t5/SAS-Programming/What-will-happen-when-we-export-to-excel-with-the-same-sheet/m-p/565256#M158681 Hi:<BR /> The answer depends on what your "script" or program uses to do the "export" -- are you doing PROC EXPORT? Are you using the LIBNAME engine for EXCEL or XLSX? Are you using ODS EXCEL? How you are creating CARDATA.XLSX or writing to it makes a difference.<BR /><BR />Cynthia Tue, 11 Jun 2019 14:20:38 GMT https://communities.sas.com/t5/SAS-Programming/What-will-happen-when-we-export-to-excel-with-the-same-sheet/m-p/565256#M158681 Cynthia_sas 2019-06-11T14:20:38Z