Flexible multiple spreadsheet data consolidation system
    1.
    发明授权
    Flexible multiple spreadsheet data consolidation system 有权
    灵活的多个电子表格数据整合系统

    公开(公告)号:US07617443B2

    公开(公告)日:2009-11-10

    申请号:US10604608

    申请日:2003-08-04

    IPC分类号: G06F17/21 G06F17/24

    CPC分类号: G06F17/246

    摘要: A method of consolidating data from multiple spreadsheets includes selecting multiple spreadsheets (52). Portions of data from files corresponding to each of the spreadsheets (52) are also selected. Automated consolidation of said portions of data is executed. The consolidation includes retrieval of the portions of data, generation of a final report spreadsheet (124), and appendage of the portions of data to the final report spreadsheet (124).

    摘要翻译: 整合来自多个电子表格的数据的方法包括选择多个电子表格(52)。 还选择了与每个电子表格(52)相对应的文件的数据的部分。 执行所述数据部分的自动合并。 合并包括检索数据的部分,生成最终报告电子表格(124)以及将数据部分附加到最终报告电子表格(124)。

    Flexible Multiple Spreadsheet Data Consolidation System
    2.
    发明申请
    Flexible Multiple Spreadsheet Data Consolidation System 审中-公开
    灵活的多个电子表格数据整合系统

    公开(公告)号:US20100017698A1

    公开(公告)日:2010-01-21

    申请号:US12570820

    申请日:2009-09-30

    IPC分类号: G06F17/00

    CPC分类号: G06F17/246

    摘要: Methods and systems are disclosed that include consolidating data from multiple spreadsheets. Consolidating data from multiple spreadsheets includes receiving a selection of a plurality of spreadsheets via a graphical control panel that includes a spreadsheet selection area. The spreadsheet selection area includes a workbook selection area to select workbooks that are not open for inclusion in the selection of the plurality of spreadsheets. Consolidating data from multiple spreadsheets further includes receiving a selection of portions of data from the plurality of spreadsheets and executing automated consolidation of the portions of data by retrieving the portions of data and generating a final report spreadsheet. Consolidating data from multiple spreadsheets further includes appending the portions of data to the final report spreadsheet.

    摘要翻译: 公开了包括合并来自多个电子表格的数据的方法和系统。 整合来自多个电子表格的数据包括经由包括电子表格选择区域的图形控制面板接收多个电子表格的选择。 电子表格选择区域包括工作簿选择区域,用于选择不打开以包括在多个电子表格的选择中的工作簿。 合并来自多个电子表格的数据还包括从多个电子表格接收数据的一部分选择,并通过检索数据部分并生成最终报告电子表格来执行数据部分的自动合并。 合并多个电子表格中的数据还包括将数据部分附加到最终报告电子表格。