Creating Excel Worksheets in APL+Win Eric Baelen Abstract This session will discuss how to work with Active Objects from APL+Win version 4.0, and in particular, how to control Microsoft Excel from an APL+Win session. It will show how to use the object hierarchy of Excel, and how to create a detailed spreadsheet, with formatting. Our Example Workbook We will use the following example Excel workbook in this session. It is a profit & loss report for a hypothetical company. It includes multiple worksheets, and a variety of data and formula cells, with specific formatting. Our examples will demonstrate how to create this spreadsheet from APL+Win. Characteristics of this Workbook are: 1. Oversized Heading on the first row of each page 2. Title line of Q1 to Yr Total Centered 3. Oversized first column 4. Data from a 3 dimensional APL array in B3:F4 on each page 5. Title of each plane on worksheet tabs 6. Formatted numbers. 7. Empty Row 5 8. Titles in Column A Bold 9. Formulas for Profits line 10. Border around Profits line 11. Total Page Only 12. Multi worksheet formulas 13. Timestamp in Italics 14. Background Color for Heading 15. The Workbook
End of preview. The entire article is 17 pages. To view the full-text, please rent this article to continue.
/lp/association-for-computing-machinery/creating-excel-worksheets-in-apl-win-NyRIZlOsvj
Welcome to DeepDyve! Rent Premier Research Articles and Save Up to 90%
Creating Excel worksheets in APL+Win
Baelen, Eric
Follow ACM SIGAPL APL Quote Quad
, Volume 32 (3)
Association for Computing Machinery – Mar 1, 2002
More Info
More Like This Article
View All dataSource[]=actageo&dataSource[]=aspet&dataSource[]=aaos&dataSource[]=aacc&dataSource[]=aacr&dataSource[]=aea&dataSource[]=aip&dataSource[]=ajnr&dataSource[]=ams&dataSource[]=aps_physical&dataSource[]=appi_book&dataSource[]=appi_journal&dataSource[]=apha&dataSource[]=asip&dataSource[]=asm&dataSource[]=asn&dataSource[]=aspb&dataSource[]=avs&dataSource[]=annual_reviews&dataSource[]=arxiv&dataSource[]=acm&dataSource[]=berghahn&dataSource[]=cabi&dataSource[]=clinical_trials&dataSource[]=dailymed&dataSource[]=degruyter&dataSource[]=du_press&dataSource[]=esa&dataSource[]=eu_press&dataSource[]=elsevier&dataSource[]=emerald&dataSource[]=ejtr&dataSource[]=emea&dataSource[]=epo&dataSource[]=faseb&dataSource[]=gsa&dataSource[]=health_affairs&dataSource[]=hindawi&dataSource[]=imanager&dataSource[]=imedpub&dataSource[]=informa_healthcare&dataSource[]=informs&dataSource[]=iop&dataSource[]=iucr&dataSource[]=iospress&dataSource[]=jbjs&dataSource[]=leftcoast&dataSource[]=lu_press&dataSource[]=mesharpe&dataSource[]=mary_ann_liebert&dataSource[]=medline&dataSource[]=mit_press&dataSource[]=nature&dataSource[]=oxford&dataSource[]=pier_professional&dataSource[]=pnas&dataSource[]=portlandpress&dataSource[]=psyc_articles&dataSource[]=psyc_books&dataSource[]=psyc_critiques&dataSource[]=plos_journal&dataSource[]=pubmed_central&dataSource[]=rsna&dataSource[]=rockefeller&dataSource[]=rcn&dataSource[]=ria&dataSource[]=rsc&dataSource[]=sage&dataSource[]=spie&dataSource[]=springer_journal&dataSource[]=springer&dataSource[]=taylor_francis&dataSource[]=aps&dataSource[]=the_scientist&dataSource[]=uc_press&dataSource[]=uspto_abstract&dataSource[]=wiley&dataSource[]=pct
© 2012 DeepDyve, Inc. All rights reserved.
Terms of Service | Privacy Policy
