专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US07007033B1 Management of markup language data mappings available to a spreadsheet application workbook 失效
标题翻译：管理可用于电子表格应用程序工作簿的标记语言数据映射
公开(公告)号：US07007033B1
公开(公告)日：2006-02-28
申请号：US10425189
申请日：2003-04-28
申请人： Chad Rothschiller , Kelly J. Lynch , Ramakrishnan Natarajan , Juha Niemisto , Marise Chan , Thibaut Vial
发明人： Chad Rothschiller , Kelly J. Lynch , Ramakrishnan Natarajan , Juha Niemisto , Marise Chan , Thibaut Vial
IPC分类号： G06F7/00
CPC分类号： G06F17/272 , G06F17/2247 , G06F17/246 , G06F17/2725 , Y10S707/99931 , Y10S707/99933 , Y10S707/99942 , Y10S707/99945
摘要： Methods and systems are provided for managing the application of one or more XML data mappings or one or more XML schema files to a spreadsheet application workbook. One or more XML schema files for associating to the spreadsheet workbook are obtained. Each schema file is iterated to determine if one or more additional schema files are identified in each of the obtained schema files. Each obtained schema is parsed to determine data definitions, elements, attributes, structure, and simple data content required by each schema file for valid XML data. All obtained schema files are combined to create a unified schema definition. A single root element is selected to serve as a root element for the generalized instance structure. A generalized instance structure of the unified schema definition is built representing all available elements, attributes or simple data content of the unified schema definition that may be applied to the spreadsheet application workbook. A tree view of the generalized instance structure is displayed for providing a visual representation of the instance structure of the unified schema definition representing elements, attributes, structure, and simple data content of the XML defined by the unified schema definition that may be validly applied to the spreadsheet workbook according to the generalized instance structure. Writing pointers to the XML map object expresses a relationship between workbook locations and XML elements.
摘要翻译：提供了用于管理一个或多个XML数据映射或一个或多个XML模式文件到电子表格应用程序工作簿的应用的方法和系统。获得用于关联到电子表格工作簿的一个或多个XML模式文件。迭代每个模式文件以确定在每个获取的模式文件中是否识别到一个或多个附加模式文件。解析每个获取的模式以确定每个模式文件为有效的XML数据所需的数据定义，元素，属性，结构和简单数据内容。所有获取的模式文件都被组合以创建统一的模式定义。选择单个根元素作为广义实例结构的根元素。构建统一模式定义的通用实例结构，代表可应用于电子表格应用程序工作簿的统一模式定义的所有可用元素，属性或简单数据内容。显示广义实例结构的树视图，用于提供表示由统一模式定义定义的XML的元素，属性，结构和简单数据内容的统一模式定义的实例结构的可视化表示，可以有效地应用于电子表格工作簿根据广义实例结构。写入XML映射对象的指针表示工作簿位置和XML元素之间的关系。

2. 发明授权

US07337182B2 Management of markup language data mappings available to a spreadsheet application workbook 有权
标题翻译：管理可用于电子表格应用程序工作簿的标记语言数据映射
公开(公告)号：US07337182B2
公开(公告)日：2008-02-26
申请号：US11214222
申请日：2005-08-29
申请人： Chad Rothschiller , Kelly J. Lynch , Ramakrishnan Natarajan , Juha Niemisto , Marise Chan , Thibaut Vial
发明人： Chad Rothschiller , Kelly J. Lynch , Ramakrishnan Natarajan , Juha Niemisto , Marise Chan , Thibaut Vial
IPC分类号： G06F17/30
CPC分类号： G06F17/272 , G06F17/2247 , G06F17/246 , G06F17/2725 , Y10S707/99931 , Y10S707/99933 , Y10S707/99942 , Y10S707/99945
摘要： Methods and systems are provided for managing the application of one or more XML data mappings or one or more XML schema files to a spreadsheet application workbook. One or more XML schema files for associating to the spreadsheet workbook are obtained. Each schema file is iterated to determine if one or more additional schema files are identified in each of the obtained schema files. Each obtained schema is parsed to determine data definitions, elements, attributes, structure, and simple data content required by each schema file for valid XML data. All obtained schema files are combined to create a unified schema definition. A single root element is selected to serve as a root element for the generalized instance structure. A generalized instance structure of the unified schema definition is built representing all available elements, attributes or simple data content of the unified schema definition that may be applied to the spreadsheet application workbook. A tree view of the generalized instance structure is displayed for providing a visual representation of the instance structure of the unified schema definition representing elements, attributes, structure, and simple data content of the XML defined by the unified schema definition that may be validly applied to the spreadsheet workbook according to the generalized instance structure. Writing pointers to the XML map object expresses a relationship between workbook locations and XML elements.
摘要翻译：提供了用于管理一个或多个XML数据映射或一个或多个XML模式文件到电子表格应用程序工作簿的应用的方法和系统。获得用于关联到电子表格工作簿的一个或多个XML模式文件。迭代每个模式文件以确定在每个获取的模式文件中是否识别到一个或多个附加模式文件。解析每个获取的模式以确定每个模式文件为有效的XML数据所需的数据定义，元素，属性，结构和简单数据内容。所有获取的模式文件都被组合以创建统一的模式定义。选择单个根元素作为广义实例结构的根元素。构建统一模式定义的通用实例结构，代表可应用于电子表格应用程序工作簿的统一模式定义的所有可用元素，属性或简单数据内容。显示广义实例结构的树视图，用于提供表示由统一模式定义定义的XML的元素，属性，结构和简单数据内容的统一模式定义的实例结构的可视化表示，可以有效地应用于电子表格工作簿根据广义实例结构。写入XML映射对象的指针表示工作簿位置和XML元素之间的关系。

3. 发明申请

US20060004844A1 Management of markup language data mappings available to a spreadsheet application workbook 有权
公开(公告)号：US20060004844A1
公开(公告)日：2006-01-05
申请号：US11214222
申请日：2005-08-29
申请人： Chad Rothschiller , Kelly Lynch , Ramakrishnan Natarajan , Juha Niemisto , Marise Chan , Thibaut Vial
发明人： Chad Rothschiller , Kelly Lynch , Ramakrishnan Natarajan , Juha Niemisto , Marise Chan , Thibaut Vial
IPC分类号： G06F17/00
CPC分类号： G06F17/272 , G06F17/2247 , G06F17/246 , G06F17/2725 , Y10S707/99931 , Y10S707/99933 , Y10S707/99942 , Y10S707/99945
摘要： Methods and systems are provided for managing the application of one or more XML data mappings or one or more XML schema files to a spreadsheet application workbook. One or more XML schema files for associating to the spreadsheet workbook are obtained. Each schema file is iterated to determine if one or more additional schema files are identified in each of the obtained schema files. Each obtained schema is parsed to determine data definitions, elements, attributes, structure, and simple data content required by each schema file for valid XML data. All obtained schema files are combined to create a unified schema definition. A single root element is selected to serve as a root element for the generalized instance structure. A generalized instance structure of the unified schema definition is built representing all available elements, attributes or simple data content of the unified schema definition that may be applied to the spreadsheet application workbook. A tree view of the generalized instance structure is displayed for providing a visual representation of the instance structure of the unified schema definition representing elements, attributes, structure, and simple data content of the XML defined by the unified schema definition that may be validly applied to the spreadsheet workbook according to the generalized instance structure. Writing pointers to the XML map object expresses a relationship between workbook locations and XML elements.

4. 发明授权

US07954046B2 Importing and exporting markup language data in a spreadsheet application document 有权
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：US07954046B2
公开(公告)日：2011-05-31
申请号：US11297978
申请日：2005-12-09
申请人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
发明人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
IPC分类号： G06F3/00 , G06F17/30
CPC分类号： G06F17/2229 , Y10S707/99931 , Y10S707/99943
摘要： XML data is associated with an XML schema file defining XML data types and data type definitions for applying XML data to the document. An XML data map is prepared that relates that any XML data applied to the document back to corresponding XML 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 in the imported spreadsheet document of XML data and the user entered data. After an imported document has been edited, or after a document is created to include the application of XML data in association with a selected XML schema file, the document may be exported such that the XML data applied to the document is maintained for subsequent import and use of the document.
摘要翻译： XML数据与定义用于将XML数据应用于文档的XML数据类型和数据类型定义的XML模式文件相关联。准备XML数据映射，将应用于该文档的任何XML数据与相关模式文件中定义的相应XML元素或属性相关联。将文档导入电子表格应用程序网格时，将解析数据映射，以在导入的XML数据的电子表格文档中查找XPATH，并输入用户的数据。在导入的文档被编辑之后，或在创建文档以包括与所选XML模式文件相关联的XML数据的应用程序之后，可以导出该文档，使得应用于该文档的XML数据被维护以供随后导入，使用文件。

5. 发明授权

US07703007B2 Importing and exporting markup language data in a spreadsheet application document 失效
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：US07703007B2
公开(公告)日：2010-04-20
申请号：US11318688
申请日：2005-12-27
申请人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
发明人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
IPC分类号： G06F17/00 , G06F17/30
CPC分类号： G06F17/2229 , Y10S707/99931 , Y10S707/99943
摘要： Data presented in a hierarchical format is rendered in a form allowing the data to be imported into a spreadsheet document where the data can be modified and new data can be added. A data file containing the hierarchically formatted data is selected for importing. A mapping relating a plurality of elements within the hierarchical data to a plurality of respective locations in the spreadsheet document is accessed. The hierarchical data is rendered in the spreadsheet document according to the mapping. Input is received to modify the hierarchical data rendered in the spreadsheet document. The mapping is updated to include the modifications to the hierarchical data. The modifications to the hierarchical data and the updated mapping are exported for subsequent rendering in a second spreadsheet document according to the updated mapping.
摘要翻译：以分层格式呈现的数据以允许将数据导入到可以修改数据并可以添加新数据的电子表格文档的形式呈现。选择包含分层格式化数据的数据文件进行导入。访问将分层数据中的多个元素与电子表格文档中的多个相应位置相关联的映射。分层数据根据映射在电子表格文档中呈现。接收到输入以修改电子表格文档中呈现的分层数据。更新映射以包括对分层数据的修改。根据更新的映射，导出对分层数据和更新的映射的修改以在第二电子表格文档中进行后续呈现。

6. 发明授权

US07249316B2 Importing and exporting markup language data in a spreadsheet application document 失效
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：US07249316B2
公开(公告)日：2007-07-24
申请号：US11328042
申请日：2006-01-09
申请人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
发明人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
IPC分类号： G06F15/00 , G06F17/21 , G06F17/24
CPC分类号： G06F17/2229 , Y10S707/99931 , Y10S707/99943
摘要： Methods and systems are provided for importing markup language formatted data into a spreadsheet document and for exporting markup language formatted data from a spreadsheet document. XML data is associated with an XML schema file defining XML data types and data type definitions for applying the XML data to the document. An XML data map is prepared that relates any XML data applied to the document back to corresponding XML 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 in the imported spreadsheet document of XML data and the user entered data. After an imported document has been edited, the document may be exported such that the XML data applied to the document is maintained for subsequent import and use of the document.
摘要翻译：提供了方法和系统，用于将标记语言格式的数据导入到电子表格文档中，并从电子表格文档导出标记语言格式的数据。 XML数据与定义用于将XML数据应用于文档的XML数据类型和数据类型定义的XML模式文件相关联。准备XML数据映射，将应用于文档的任何XML数据与相关模式文件中定义的相应XML元素或属性相关联。将文档导入电子表格应用程序网格时，将解析数据映射，以在导入的XML数据的电子表格文档中查找XPATH，并输入用户的数据。在导入的文档被编辑之后，可以导出文档，使得应用于文档的XML数据被维护以便随后导入和使用该文档。

7. 发明授权

US07640493B2 Importing and exporting markup language data in a spreadsheet application document 失效
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：US07640493B2
公开(公告)日：2009-12-29
申请号：US11337942
申请日：2006-01-23
申请人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
发明人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
IPC分类号： G06F15/00 , G06F17/21 , G06F17/24
CPC分类号： G06F17/2229 , Y10S707/99931 , Y10S707/99943
摘要： 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.
摘要翻译：可扩展标记语言（例如XML）中的可扩展标记语言数据与用于定义用于将数据应用于文档的数据类型和数据类型定义的模式文件相关联。准备了将应用于文档的任何可扩展标记数据返回到相关模式文件中定义的相应元素或属性的映射。当文档导入到电子表格应用程序网格中时，将解析数据映射以查找XPATH，以确定与模式文件相关的文档中每个单元格或列表对象的位置，数据类型和用户数据。单元格和列表填充有可扩展标记数据和用户数据，并根据应用于文档的可扩展标记数据指定的格式呈现。可以导出文档，以便维护可扩展标记数据以供以后导入和使用。

8. 发明授权

US07017112B2 Importing and exporting markup language data in a spreadsheet application document 失效
标题翻译：在电子表格应用程序文档中导入和导出标记语言数据
公开(公告)号：US07017112B2
公开(公告)日：2006-03-21
申请号：US10377145
申请日：2003-02-28
申请人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
发明人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly J. Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael J. McCormack , Parul Dalia , Marise Chan , James Rivera
IPC分类号： G06F15/00
CPC分类号： G06F17/2229 , Y10S707/99931 , Y10S707/99943
摘要： Methods and systems are provided for importing and exporting markup language formatted data into a spreadsheet document. XML data is associated with a schema file defining data types and data type definitions for applying the XML data to the document. A map is prepared that relates any XML data applied to the document back to corresponding elements or attributes defined in the schema file. When the document is imported into a spreadsheet application grid, the 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 XML data and user data and rendered according to formatting dictated by the XML data applied to the document. The document may be exported such that the XML data is maintained for subsequent import and use.
摘要翻译：提供了方法和系统，用于将标记语言格式的数据导入和导出到电子表格文档中。 XML数据与定义用于将XML数据应用于文档的数据类型和数据类型定义的模式文件相关联。准备了将应用于该文档的任何XML数据返回到模式文件中定义的相应元素或属性的映射。将文档导入到电子表格应用程序网格中时，将解析该映射以找到XPATH，以确定与模式文件相关的文档中每个单元格或列表对象的位置，数据类型和用户数据。单元格和列表填充有XML数据和用户数据，并根据应用于文档的XML数据指定的格式进行渲染。可以导出文档，以便维护XML数据以供以后导入和使用。

9. 发明申请

US20060112329A1 Importing and exporting markup language data in a spreadsheet application document 失效
公开(公告)号：US20060112329A1
公开(公告)日：2006-05-25
申请号：US11328042
申请日：2006-01-09
申请人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael McCormack , Parul Dalia , Marise Chan , James Rivera
发明人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael McCormack , Parul Dalia , Marise Chan , James Rivera
IPC分类号： G06F17/21 , G06F17/24
CPC分类号： G06F17/2229 , Y10S707/99931 , Y10S707/99943
摘要： Methods and systems are provided for importing markup language formatted data into a spreadsheet document and for exporting markup language formatted data from a spreadsheet document. XML data is associated with an XML schema file defining XML data types and data type definitions for applying XML data to the document. An XML data map is prepared that relates that any XML data applied to the document back to corresponding XML 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 in the imported spreadsheet document of XML data and the user entered data. Each XPATH is executed to determine the location, data types and user data for each cell or list object in the document that is related back to the associated schema file. The cells and lists are populated with the XML data and user data, and the data is rendered in the spreadsheet according to the formatting dictated by the XML data applied to the spreadsheet in association with the XML schema file. After an imported document has been edited, or after a document is created to include the application of XML data in association with a selected XML schema file, the document may be exported such that the XML data applied to the document is maintained for subsequent import and use of the document.

10. 发明申请

US20060190814A1 Importing and exporting markup language data in a spreadsheet application document 失效
公开(公告)号：US20060190814A1
公开(公告)日：2006-08-24
申请号：US11337942
申请日：2006-01-23
申请人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael McCormack , Parul Dalia , Marise Chan , James Rivera
发明人： Robert Collie , Chad Rothschiller , Ulrich Homann , Joseph Chirilov , Kelly Lynch , Ramakrishnan Natarajan , Eoin Burke , Juha Niemisto , Michael McCormack , Parul Dalia , Marise Chan , James Rivera
IPC分类号： G06F17/21 , G06F17/24
CPC分类号： G06F17/2229 , Y10S707/99931 , Y10S707/99943
摘要： Methods and systems are provided for importing markup language formatted data into a spreadsheet document and for exporting markup language formatted data from a spreadsheet document. XML data is associated with an XML schema file defining XML data types and data type definitions for applying XML data to the document. An XML data map is prepared that relates that any XML data applied to the document back to corresponding XML 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 in the imported spreadsheet document of XML data and the user entered data. Each XPATH is executed to determine the location, data types and user data for each cell or list object in the document that is related back to the associated schema file. The cells and lists are populated with the XML data and user data, and the data is rendered in the spreadsheet according to the formatting dictated by the XML data applied to the spreadsheet in association with the XML schema file. After an imported document has been edited, or after a document is created to include the application of XML data in association with a selected XML schema file, the document may be exported such that the XML data applied to the document is maintained for subsequent import and use of the document.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式