SUGI 28: Generating Custom Excel Spreadsheets Using ODS

Paper 12-28 1 Generating Custom Excel Spreadsheets Using ODSC hevell Parker, SAS Institute, Cary, NCABSTRACTThis paper will demonstrate techniques on how to effectivelygenerate files that can be read with Microsoft Excel Using theOutput Delivery System. This paper will further discuss avariety of methods that will allow customization of the everypart of the Excel file from ODS. Some of the tips provided willwork with Excel 97, 2000 and 2002. However, much of whatis covered especially, the advanced techniques Using XMLand the special Microsoft Office style properties apply toExcel 2000 and partially to As you will see, creating files with the Output DeliverySystem that can be read with Excel is very easy, however,some additional work may be required to customize theoutput as you like. Topics of discussion will include thefollowing: Techniques for creating files with the ODS that canbe read by Excel , General appearance issues and commontask, Advanced techniques Using XML and the ODS Markupdestination to modify the Excel file, and Using Excel Macroswith Excel FILEST here are several methods of Generating files that can beread by Excel Using the Output Delivery System.

Paper 12-28 1 Generating Custom Excel Spreadsheets using ODS Chevell Parker, SAS Institute, Cary, NC ABSTRACT This paper will demonstrate techniques on how to effectively

Tags:

  Using, Excel, Technique, Custom, Spreadsheets, Generating, Generating custom excel spreadsheets using

Information

Related search queries