Patent ID: 7249316
Filing Date: 2007-07-24
Classification: G06F,Y10S

Abstract:
1. A method of importing hierarchical eXtensible Markup Language (XML) data into a spreadsheet document and for exporting hierarchical XML data from a spreadsheet document, comprising: selecting an XML data file containing hierarchical data for importing into the spreadsheet document whereby the XML data file has applied hierarchical data mapped to the spreadsheet document, the hierarchical data and the applied hierarchical data including a plurality of fields; identifying data mapping whereby each of the plurality of fields applied to the XML data file is mapped to an associated schema file for defining data definitions for the plurality of fields applied to the spreadsheet document; parsing the data mapping to obtain pointers associated with the plurality of fields applied to the XML data file pointing to the applied plurality of fields of the associated schema file; executing each pointer to find locations of the plurality of fields applied to the XML data file; executing each pointer to the associated schema file to obtain data definitions applicable to the plurality of fields according to the associated schema file; determining a layout for rendering the XML data file to the spreadsheet document based on the locations of each of the plurality of fields applied to the XML data file; rendering the XML data file in the spreadsheet document whereby the plurality of fields in any user data associated with the plurality of fields are positioned in the spreadsheet document according to the layout; after rendering the XML data file in the spreadsheet document, modifying the XML data file in the spreadsheet document; updating the data mapping to include modifications to any fields applied to the XML data file and to include modifications to any user data applied to the XML data file selecting the modified XML data file for exporting to a memory location; selecting the updated data mapping for relating the hierarchical data in the spreadsheet document with the associated schema file associated with the spreadsheet document; matching the selected updated data mapping to an instance structure of the associated schema file; comparing the instance structure and the updated data mapping to determine what fields in the plurality of fields have been applied to the spreadsheet document from the associated schema file; parsing through each node of the updated data mapping to find the location and content of the plurality of fields applied to the spreadsheet document; populating the instance structure with the plurality of fields applied to the spreadsheet document; extracting the plurality of fields and any associated user data from the instance structure; arranging the extracted plurality of fields and any associated user data into the XML data file according to the instance structure of the associated schema file; and writing the XML data file to memory.