topic Re: ods excelXP - output to specific cells in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excelXP-output-to-specific-cells/m-p/109356#M10006 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P>&nbsp; If you are you using TAGSETS.EXCELXP or other ODS destinations and Base SAS, then the way that ODS works is to completely rewrite or recreate the file specified in the FILE= option or the BODY= option. The only way to write to a particular cell or range of cells is to use named ranges and PROC EXPORT and/or the LIBNAME engine -- using SAS methods -- but these are NOT ODS methods.</P><P></P><P>&nbsp; Using Microsoft technology, you might, with DDE, or ODBC or OLE-DB be able to write to existing sheets/workbooks to a particular cell. </P><P></P><P>cynthia</P></BODY></HTML> Tue, 17 Jul 2012 15:01:22 GMT Cynthia_sas 2012-07-17T15:01:22Z ods excelXP - output to specific cells https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excelXP-output-to-specific-cells/m-p/109355#M10005 <HTML><HEAD></HEAD><BODY><P>Is is possible to output data to a specific cell in a spreadsheet?</P><P></P><P>Thanks,</P><P></P><P>DanD</P></BODY></HTML> Tue, 17 Jul 2012 14:51:54 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excelXP-output-to-specific-cells/m-p/109355#M10005 dan999 2012-07-17T14:51:54Z Re: ods excelXP - output to specific cells https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excelXP-output-to-specific-cells/m-p/109356#M10006 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P>&nbsp; If you are you using TAGSETS.EXCELXP or other ODS destinations and Base SAS, then the way that ODS works is to completely rewrite or recreate the file specified in the FILE= option or the BODY= option. The only way to write to a particular cell or range of cells is to use named ranges and PROC EXPORT and/or the LIBNAME engine -- using SAS methods -- but these are NOT ODS methods.</P><P></P><P>&nbsp; Using Microsoft technology, you might, with DDE, or ODBC or OLE-DB be able to write to existing sheets/workbooks to a particular cell. </P><P></P><P>cynthia</P></BODY></HTML> Tue, 17 Jul 2012 15:01:22 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excelXP-output-to-specific-cells/m-p/109356#M10006 Cynthia_sas 2012-07-17T15:01:22Z