Importing and exporting markup language data in a spreadsheet application document

• US 7,640,493 B2
• Filed: 01/23/2006
• Issued: 12/29/2009
• Est. Priority Date: 02/28/2003
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: McCormack, Michael J., Lynch, Kelly J., Homann, Ulrich, Dalia, Parul, Burke, Eoin, Natarajan, Ramakrishnan, Niemisto, Juha, Rothschiller, Chad, Chan, Marise, Rivera, James, Chirilov, Joseph, Collie, Robert
• Primary Examiner(s): Ries; Laurie
• Assistant Examiner(s): Nguyen; Maikhanh
• Application Number:
  US11/337,942
• Publication Number:
  US 20060190814A1
• Time in Patent Office: 1,436 Days
• Field of Search: 715/513, 715/503, 715/501.1, 715/504, 715/523, 715/526, 715/201, 715/205, 715/212, 715/215, 715/217, 715/219, 715/220, 715/226, 715/227, 715/229, 715/231, 715/234, 715/243, 715/249, 715/255, 715/273, 707/1, 707/3, 707/4, 707/6, 707/100
• US Class Current: 715/234
• CPC Class Codes: G06F 40/131 Fragmentation of text files, e.g. creating reusable text-blocks; Linking to fragments, e.g. using XInclude; Namespaces
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Extensible markup language data in an extensible markup language (such as XML) is associated with a schema file for defining data types and data type definitions for applying data to the document. A map is prepared that relates that any extensible markup data applied to the document back to corresponding elements or attributes defined in the associated schema file. When the document is imported into a spreadsheet application grid, the data map is parsed to find XPATHs which determine the location, data types and user data for each cell or list object in the document related to the schema file. The cells and lists are populated with the extensible markup data and user data, and rendered according to formatting dictated by the extensible markup data applied to the document. The document may be exported such that the extensible markup data is maintained for subsequent import and use.

Claims

1. A method of utilizing hierarchical data in an extensible Markup Language formatted in a spreadsheet document, comprising:

selecting a data file containing the hierarchical data for importing into a spreadsheet document whereby the data file has applied hierarchical data mapped to the spreadsheet document, wherein the applied hierarchical data includes a plurality of fields;

identifying a hierarchical data mapping whereby each of the plurality of fields of the hierarchical data applied to the 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 hierarchical data mapping to obtain pointers associated with the plurality of fields applied to the data file pointing to the applied plurality of fields of the associated schema file, whereby parsing the data mapping includes;

parsing the hierarchical data mapping to obtain pointers referenced to positions in the data file associated with each field of the plurality of fields applied to the data file for pointing each field of the plurality of fields applied to the data file to a corresponding data definition in the associated schema file; and

parsing the hierarchical data mapping with a parser and obtaining an address for pointing to a particular node in the hierarchical data for each field of the plurality of fields applied to the data file from the associated schema file;

executing each pointer to find locations of the plurality of fields applied to the data file;

executing each pointer to the associated schema file to obtain hierarchical data definitions applicable to the plurality of fields according to the schema file;

populating the locations of each field of the plurality of fields with any associated user data and the corresponding plurality of fields and hierarchical data definitions from the associated schema file;

determining a layout for rendering the data file to the spreadsheet document based on the locations of each field of the plurality of fields applied to the data file; and

rendering the data file in the spreadsheet document by converting the data from a hierarchical structure to a flattered data structure for rendering the data in the spreadsheet document, and by formatting any user data rendered in the spreadsheet document according to the data definitions associated with a field in the plurality of fields applied to the location of the any user data according to the associated schema file, 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.

2. The method of claim 1, whereby the step of rendering the data file in the spreadsheet document includes rendering the data file in the spreadsheet document whereby any user data associated with the plurality of fields are positioned in the spreadsheet document according to the layout.

3. The method of claim 1, whereby identifying a hierarchical data mapping includes matching a root name of a hierarchical language namespace associated with the schema file to the plurality of fields applied to the data file.

4. The method of claim 3, whereby if more than one data mapping is identified for the data file, selecting one mapping from the one or more data mappings.

5. The method of claim 4, whereby selecting one data mapping from the one or more data mappings includes querying a user for a selection of the one data mapping from the one or more data mappings.

6. The method of claim 5, whereby querying a user for a selection of the one mapping includes querying the user via a user interface.

7. The method of claim 1, further comprising passing the each pointer to a hierarchical data markup language processing module.

8. The method of claim 1, whereby the step of executing each pointer to find locations of the plurality of fields applied to the data file includes obtaining the plurality of fields applied to the data file for rendering the data file in the spreadsheet document.

9. The method of claim 8, further comprising obtaining any user data in the data file associated with the plurality of fields applied to the data file for rendering in the spreadsheet document.

10. The method of claim 9, whereby the locations of the plurality of fields applied to the data file correspond to cells of a spreadsheet application grid for rendering the spreadsheet document.

11. The method of claim 9, whereby the locations of the plurality of fields applied to the data file correspond with list ranges for list objects of a spreadsheet application grid for rendering the data file in the spreadsheet document.

12. The method of claim 1, further comprising modifying the plurality of fields applied to the data file including applying additional fields to the spreadsheet document from the associated schema file.

13. The method of claim 12, whereby the step of modifying the plurality of fields applied to the data file includes deleting fields from the spreadsheet document.

14. The method of claim 12, further comprising modifying any user data applied to the spreadsheet document associated with the plurality of fields applied to the spreadsheet document according to the associated schema file.

15. The method of claim 14, further comprising the step of updating the mapping to include modifications to any of the plurality of fields applied to the data file and to include modifications to any user data applied to the data file.

16. A computer readable storage medium having computer executable instructions contained thereon which when executed by a computer perform the following steps for utilizing hierarchical data in an extensible Markup Language formatted in a spreadsheet document:

selecting a data file containing the hierarchical data for importing into a spreadsheet document whereby the data file has applied hierarchical data mapped to the spreadsheet document, wherein the applied hierarchical data includes a plurality of fields;

identifying a hierarchical data mapping whereby each of the plurality of fields of the hierarchical data applied to the 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 hierarchical data mapping to obtain pointers associated with the plurality of fields applied to the data file pointing to the applied plurality of fields of the associated schema file, whereby parsing the data mapping includes;

parsing the hierarchical data mapping to obtain pointers referenced to positions in the data file associated with each field of the plurality of fields applied to the data file for pointing each field of the plurality of fields applied to the data file to a corresponding data definition in the associated schema file; and

parsing the hierarchical data mapping with a parser and obtaining an address for pointing to a particular node in the hierarchical data for each field of the plurality of fields applied to the data file from the associated schema file;

executing each pointer to find locations of the plurality of fields applied to the data file;

executing each pointer to the associated schema file to obtain hierarchical data definitions applicable to the plurality of fields according to the schema file;

populating the locations of each field of the plurality of fields with any associated user data and the corresponding plurality of fields and hierarchical data definitions from the associated schema file;

determining a layout for rendering the data file to the spreadsheet document based on the locations of each field of the plurality of fields applied to the data file; and

rendering the data file in the spreadsheet document by converting the data from a hierarchical structure to a flattered data structure for rendering the data in the spreadsheet document, and by formatting any user data rendered in the spreadsheet document according to the data definitions associated with a field in the plurality of fields applied to the location of the any user data according to the associated schema file, 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.