A common feature request that application developers are often asked to incorporate in their business software is the ability to import or export data to or from Microsoft Excel files. Fortunately, DataFlex makes this easy to do by using the powerful DataFlex Library for LibXL!
With this library developers can easily expand their Windows, web and mobile apps to read and write Excel files without requiring the use of Microsoft Excel and the .NET framework to:
The DataFlex Library for LibXL makes it fast & easy to use LibXL with your DataFlex applications for much less cost than licensing Microsoft Excel. To see LibXL working in a simple DataFlex app, check out the LibXL Demo.
More reasons to use the DataFlex Library for LibXL
The DataFlex Library for LibXL consists of:
The software is for use with LibXL v22.214.171.124 and is not supported for any older or newer version. By default, LibXL uses a demo license, which is fine for experimentation. It will write a banner in the first row of each spreadsheet and it will be able to read only 300 cells (first row is unavailable).
The DataFlex Library for LibXL is sold by Data Access Europe, and includes a LibXL license. A commercial license is required to remove the banner and reading limitation.
In the past, DataFlex developers would usually use COM to provide this same functionality, but this has some drawbacks, especially for web applications.
DataFlex developer and business analyst Frank van den Beemt for the Dutch firm VolkerWessels Infra ICT gives an overview of his experience using both DataFlex COM proxy classes generated from Excel, and the DataFlex Library for LibXL with his firms applications ...
For many years Ive used an Excel COM class (generated with DataFlex) for creating and reading Excel documents. Once you have generated the class, you must build your own Procedures and Functions in several Excel objects within your program (or build your own .pkg) in order to use it.
Advantages with COM:
Disadvantages with COM:
Using the DataFlex Library for LibXL
For a web application, I could not use the COM class because of Excel licensing issues, so I purchased the DataFlex Library for LibXL. This library is immediately ready for use and comes with example source code to help get you started.
Advantages with LibXL:
Disadvantages with LibXL:
With the DataFlex Library for LibXL I easily created an Excel spreadsheet in which I used a limited variety of cell formatting as shown below. While formatting was a bit more difficult than I was used to doing within the COM class, overall using the Library is faster and easier, and the results are excellent!
Figure 1: Excel spreadsheet created with the DataFlex Library for LibXL
When viewing the LibXL demo, please note: