ExcelXML

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.


Download Latest Release of ExcelXML