Convert a Table or a Grid control into a Microsoft Excel XML Spreadsheet file.
Project Manager:
Rodrigo Bruscain
The ExcelXML project is designed to bring to the Visual FoxPro the possibility to generate a Excel file converting 99% of all visual caracteristics from a Grid. However, there is the possibility to generate a file without a Grid.
GOALS
- Excel files with over 65,535 rows.
- No limit size. (it depents on the Operational System)
- Convert a Grid Control into a Excel XML file considering 99% of the visual characteristics.
- It is possible to use Grid Dynamics properties.
- Based in all Grid visual properties.
- It is possible to convert a table without a Grid Control as well.
- Easy to implement and it is not necessary to change your code.
- Compatible with Microsoft Excel 2003 or higher.
- The files can be opened by OpenOffice reducing conversion errors.
- Open the file by Excel and save in other formats to reduce the size without loose the information.
- It is not necessary to have the Microsoft Excel installed.
Release version 1.06
FIX - SET COLLATE TO controled at run-time to avoid the error "Invalid Key Length"
Release version 1.05
FIX - Column data type Date and DateTime when converted has wrong format.
FIX - Column data type DateTime is not considered the time in current value field.
Release version 1.04
FIX - Sheet name cannot exceed 31 characters
FIX - Sheet name cannot contain any of the following characteres: : \ / ? * [ ]
FIX - Sheet name cannot be blank. If is blank, will be changed to "Sheet1"
Release version 1.03
FIX - Field Date/Datetime with NULL or EMPTY value builds a Excel file incorrectly.
FIX - Index error when the index tag is too big.