A NEW TODAY IS DAWNING!

TB0027 - The Excel Demo Application

Number: TB0027

Availability: As of BuildPro 7.09.00, all users.


Detail

Across the industry, developers are using XML data to store and transfer data. As of Office XP, Microsoft has added XML support in Excel.

The xldemo application demonstrates how BuildPro developers can read and write true Excel spreadsheets. Examples of use are:

  1. Publish reports directly into Excel with full color and font support.
     
  2. Pass data from the business application to Excel for further analysis and calculation. When the user is done, read information back into BuildPro.
     
  3. Upload budget information from named ranges directly into the BuildPro application for further processing.
     
  4. Reports that are generated in XML can be viewed in a browser or Excel using simple XML Transformation command (see the XML *TRANSFRM command).

Download the xldemo application including source here.

Note. For demonstration purposes the xldemo application generates XML data as required from hard-coded data. Ideally the required XML data should be transformed from common XML source data.