topic Re: Excel Gridlines in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-Gridlines/m-p/173216#M12401 <HTML><HEAD></HEAD><BODY><P>Thank you Cynthia.</P></BODY></HTML> Wed, 09 Jul 2014 17:45:52 GMT Smitty 2014-07-09T17:45:52Z Excel Gridlines https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-Gridlines/m-p/173214#M12399 <HTML><HEAD></HEAD><BODY><P>Greetings:</P><P></P><P>I am pushing data to Excel using ExcelXP Tagset and proc report.&nbsp; Is it possible to preserve the native gridlines that are outside the report data?&nbsp; I have tried background=transparent without success.</P><P></P><P>Cheers,</P><P>Smitty</P></BODY></HTML> Wed, 09 Jul 2014 17:20:11 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-Gridlines/m-p/173214#M12399 Smitty 2014-07-09T17:20:11Z Re: Excel Gridlines https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-Gridlines/m-p/173215#M12400 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P>&nbsp; This would be a question for Tech Support. When you create output with TAGSETS.EXCELXP, you are not creating a "native" or "true binary" Excel file. You are creating an XML file that Excel knows how to open and render. The report created by your procedure (in this case, PROC REPORT) has a fixed number of rows and columns, that is the "area" of the report. Inside this area, you are able to impact colors and fonts and other aspects of the SAS-generated output. But SAS is not in control of the sheet outside the report area. There -might- be a style template way to impact the rest of the sheet, outside the report area, but if there is, I am not aware of it -- other than to switch to ODS CSV. That's why I recommend that you open a track with Tech Support for the definitive answer.</P><P></P><P>cynthia</P></BODY></HTML> Wed, 09 Jul 2014 17:42:29 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-Gridlines/m-p/173215#M12400 Cynthia_sas 2014-07-09T17:42:29Z Re: Excel Gridlines https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-Gridlines/m-p/173216#M12401 <HTML><HEAD></HEAD><BODY><P>Thank you Cynthia.</P></BODY></HTML> Wed, 09 Jul 2014 17:45:52 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Excel-Gridlines/m-p/173216#M12401 Smitty 2014-07-09T17:45:52Z