Loading...
Please wait, while we are loading the content...
Similar Documents
How to Generate 10,000 Excel Spreadsheets in 10 Minutes (Or Less)
| Content Provider | Semantic Scholar |
|---|---|
| Author | Churchill, Alan |
| Copyright Year | 2007 |
| Abstract | SAS programmers have traditionally used techniques such as proc export, DDE, Access to PC File Formats, excel libname engine, and ODS to generate Excel spreadsheets. Each one of these approaches, though, focuses on „pushing‟ the data (Excel spreadsheets) from SAS. A new .NET „pull‟ technique is presented in this paper. This technique „pulls‟ the data from SAS and creates Excel spreadsheets from a dedicated Excel model. This approach allows for full customization of Excel spreadsheets including formatting, calculations, printing styles, etc. using SAS datasets. In addition, native Excel spreadsheets are generated. This approach, by being a native .NET application, is an amazingly fast way of generating Excel spreadsheet and it overcomes many of the limitations seen in the past. |
| File Format | PDF HTM / HTML |
| Alternate Webpage(s) | http://www2.sas.com/proceedings/forum2007/001-2007.pdf |
| Language | English |
| Access Restriction | Open |
| Content Type | Text |
| Resource Type | Article |
