1 / 10

Creating highly customized, binary Excel files using XML… 99.3% of the time

Creating highly customized, binary Excel files using XML… 99.3% of the time. “42.7 percent of all statistics are made up on the spot.” – Steven Wright. Alan Churchill, Savian, LLC Don Henderson, HCSBI. alan.churchill@savian.net don.henderson@hcsbi.com. Scenario.

xanthus-chandler
Download Presentation

Creating highly customized, binary Excel files using XML… 99.3% of the time

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Creating highly customized, binary Excel files using XML… 99.3% of the time “42.7 percent of all statistics are made up on the spot.” – Steven Wright

  2. Alan Churchill, Savian, LLCDon Henderson, HCSBI alan.churchill@savian.netdon.henderson@hcsbi.com

  3. Scenario Replicate these every day using my data from SAS… I need this done fast • Client would like a lot of Excel reports created by SAS and they are highly customized (formats, graphs, printing options, etc.) • Customer

  4. Example Report

  5. What are the SAS options for doing this? • DDE, proc export, libname engine • Old and can be difficult to work with (DDE) • May not support newer Excel features and versions • May require a separate license to create binary files • ODS using proc report and the ExcelXP tagset • Complicated • Close in many cases…but not close enough • Very labor intensive • Does not generate binary workbooks • Does not handle Excel graphs

  6. SaviCellsPro (SCP) • SCP is Windows-based. • Supports native Excel binaries in 2003 & 2007 format • Uses a template for the Excel layout which is then fed into the SCP engine • Supports Excel graphics • SAS can be used on any platform to modify the template and insert data • Companion tool generates template from existing workbook

  7. SCP Process for Solving Problem One time processes Tune code

  8. DEMO TIME

  9. SCP Negatives • Windows-centric • Does not handle proc output. SCP’s intent is to create ‘customized’ workbooks • Has to be executed from a command prompt or via the X command in SAS

  10. http://www.sascommunity.org/wiki/SaviCellsPro_-_SGF_2010 Alan Churchill, Savian, LLCDon Henderson, HCSBI alan.churchill@savian.netdon.henderson@hcsbi.com

More Related