×

Importing and exporting markup language data in a spreadsheet application document

  • US 7,954,046 B2
  • Filed: 12/09/2005
  • Issued: 05/31/2011
  • Est. Priority Date: 02/28/2003
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method of exporting hierarchical data from a spreadsheet application, comprising:

  • selecting a spreadsheet document containing data for exporting, the hierarchical data including a plurality of fields;

    selecting an XML data mapping for relating all of the hierarchical data in the spreadsheet document with an XML schema file associated with the spreadsheet document;

    creating a generalized instance structure corresponding to the selected XML data mapping, the generalized instance structure representing an XML document with elements and attributes defined by an XML schema;

    wherein the generalized instance structure represents a potential hierarchical data structure of the XML document having all potential elements and attributes of the associated XML schema file applied to the XML document;

    wherein the generalized instance structure includes a root element and a non-repeating child element having a single value and a repeating child element that has a plurality of values;

    matching the selected XML data mapping to the generalized instance structure of the associated XML schema file;

    comparing the generalized instance structure and the selected XML data mapping to determine what fields in the plurality of fields have been applied to the spreadsheet document from the associated XML schema file;

    parsing through each of a plurality of nodes of the selected XML data mapping to find the location and content of the plurality of fields applied to the spreadsheet document;

    populating the generalized instance structure with the plurality of fields applied to the spreadsheet document;

    extracting the plurality of fields and any associated user data from the generalized instance structure;

    arranging the extracted plurality of fields and any associated user data into a data file according to the generalized instance structure of the associated XML schema file;

    using the associated XML schema file to determine when a field is optional and when the field is optional and does not include data then omitting the field from the data file; and

    writing the data file to memory for exporting.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×