e.Spreadsheet Can Produce Excel workbooks that contain VBA and Excel Macros. This presentation explains the basics.
In Actuate 8SP1 and later, e.Spreadsheet can generate Excel workbooks that contain Visual Basic (VBA) code and Excel macros.With Visual Basic, report developers can create e.Spreadsheet reports with the following characteristics:
Custom toolbars and menus With Visual Basic, report developers can add custom toolbars, drop-down menus, and pop-up menus to their spreadsheets. These menus can be used to support advanced functionality, such as drill-down to a choice of detail sub-reports from a particular spreadsheet cell.
Add forms objects With Visual Basic macros, e.Spreadsheet report developers can place Excel forms objects, such as buttons and drop-down list boxes within e.Spreadsheet reports.
Work-around limitations e.Spreadsheet already has 98% overlap with the features of Microsoft Excel, but now, with Visual Basic, customers can now work-around the remaining 2% by recording appropriate macros within Excel and incorporating them into the e.Spreadsheet executable.
Write-back to a database Enables applications where 1)users enter values in cells of an e.Spreadsheet-produced Excel file, 2) users press a "submit" button embedded in the spreadsheet, and 3) the new cell values are written back to a database. This is done by embedding Visual Basic logic to collect the data values from the appropriate cells and sending them to a server.
There are many more productive uses of Visual Basic within an e.Spreadsheet report more than we can guess since Visual Basic is a very full-featured programming language. Developers will find that it affords them extraordinary power in creating very sophisticated and interactive spreadsheet applications.
Download (220.65 KB)
By downloading this item, you are agreeing to the Terms of Use for the site.
DevShare
(0 reviews, 6510 views)
iServer Express
