Visual FoxPro class to geneate pure XLS files using the BIFF3 file format.
FoxyXLS is a free class that allows Visual FoxPro 9 users to create pure XLS files without the need of having MS-OFFICE or OPENOFFICE installed. It does not use any kind of automation.
FoxyXLS creates XLS files in the BIFF3 file format directly.
This first version is based on
class, originally created in Visual C#, adapted to VFP. Some few methods and properties have been included to allow setting the default Column Widths and default Row Heights.
For the future, I hope to work with the Excel 97 file format, that provides more options, and allowing adding formulas.
With the current ALPHA version, with FoxyXLS you can do the following:
- Create simple worksheets
- Create cells with strings and values
- Use several formatting available for dates and numbers
- Forecolors and backcolors available
- All fonts and styles available
- Set the default row height and column widths
- Set column widths for specific columns
Limitations - basically, the limitations of the MS-Excel 3.0 format:
Additional information on BIFF format and creating XLS files:
Serhiy Perevoznik C# class to create XLS
Document 'Open Office Excel file format'
Document 'MS Excel 97-2007 binary file format specification'
Special thanks to:
- Only one worksheet page
- Formulas are not available yet
- Only 16 basic Excel colors available
for his great class
Excel is a registered trademark of Microsoft Corporation.