Importing and exporting markup language data in a spreadsheet application document
    7.
    发明申请
    Importing and exporting markup language data in a spreadsheet application document 失效
    在电子表格应用程序文档中导入和导出标记语言数据

    公开(公告)号:US20060101333A1

    公开(公告)日:2006-05-11

    申请号:US11318688

    申请日:2005-12-27

    IPC分类号: G06F17/21 G06F17/24 G06F7/00

    摘要: 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.

    摘要翻译: 提供了方法和系统,用于将标记语言格式的数据导入到电子表格文档中,并从电子表格文档导出标记语言格式的数据。 XML数据与定义用于将XML数据应用于文档的XML数据类型和数据类型定义的XML模式文件相关联。 准备XML数据映射,将应用于该文档的任何XML数据与相关模式文件中定义的相应XML元素或属性相关联。 将文档导入电子表格应用程序网格时,将解析数据映射,以在导入的XML数据的电子表格文档中查找XPATH,并输入用户的数据。 执行每个XPATH以确定文档中与关联模式文件相关的每个单元格或列表对象的位置,数据类型和用户数据。 单元格和列表填充有XML数据和用户数据,并且根据应用于与XML模式文件相关联的电子表格的XML数据指定的格式,在电子表格中呈现数据。 在导入的文档被编辑之后,或在创建文档以包括与所选XML模式文件相关联的XML数据的应用程序之后,可以导出该文档,使得应用于该文档的XML数据被维护以供随后导入, 使用文件。

    Markup language visual mapping
    10.
    发明授权
    Markup language visual mapping 失效
    标记语言视觉映射

    公开(公告)号:US07096422B2

    公开(公告)日:2006-08-22

    申请号:US10377256

    申请日:2003-02-28

    IPC分类号: G06F15/00

    摘要: Methods and systems are provided for mapping markup language data and schema, such as eXtensible Markup Language (XML) data and XML schema, to selected fields (cells, columns, rows) of a spreadsheet application document. An XML schema file is associated with a spreadsheet application document by providing a mechanism of adding the schema definitions to the spreadsheet application document. Furthermore, XML schema constructs such as elements, attributes, and simple content are associated to regions in the spreadsheet application document by providing a tree view structure of a generalized instance of a given XML schema file. A user may drag and drop markup language nodes representing elements, attributes and simple data content, from the tree view structure of the generalized instance of the XML schema file onto a spreadsheet worksheet grid. Once a cell, column or row in worksheet grid accepts the dropped element or attribute, an association is made between the target location in the worksheet grid, and the definition, data type and rules associated with the dropped element or attribute by setting an XML path language (XPATH) marker to point the target location back to the selected element or attribute in the XML schema file. Having all or partially all desired markup language elements or attributes associated with desired target locations in the spreadsheet grid, a general mapping of marked-up locations in the spreadsheet grid and their associated elements and/or attributes in an associated XML schema file is created.

    摘要翻译: 提供了方法和系统,用于将标记语言数据和模式(如可扩展标记语言(XML)数据和XML模式)映射到电子表格应用程序文档的选定字段(单元格,列,行)。 通过提供将模式定义添加到电子表格应用程序文档的机制,将XML模式文件与电子表格应用程序文档相关联。 此外,XML模式构造(如元素,属性和简单内容)通过提供给定XML模式文件的通用实例的树视图结构与电子表格应用程序文档中的区域相关联。 用户可以将表示元素,属性和简单数据内容的标记语言节点从XML模式文件的广义实例的树状视图结构拖放到电子表格工作表网格上。 一旦工作表网格中的单元格,列或行接受删除的元素或属性,就会通过设置XML路径在工作表网格中的目标位置与与删除的元素或属性相关联的定义,数据类型和规则之间进行关联 语言(XPATH)标记将目标位置指向XML模式文件中所选的元素或属性。 具有与电子表格网格中的期望目标位置相关联的全部或部分所有期望的标记语言元素或属性,创建电子表格网格中的标记位置及其相关联的元素和/或相关联的XML模式文件中的属性的一般映射。