-
公开(公告)号:US07617443B2
公开(公告)日:2009-11-10
申请号:US10604608
申请日:2003-08-04
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)。
-
公开(公告)号: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.
摘要翻译: 公开了包括合并来自多个电子表格的数据的方法和系统。 整合来自多个电子表格的数据包括经由包括电子表格选择区域的图形控制面板接收多个电子表格的选择。 电子表格选择区域包括工作簿选择区域,用于选择不打开以包括在多个电子表格的选择中的工作簿。 合并来自多个电子表格的数据还包括从多个电子表格接收数据的一部分选择,并通过检索数据部分并生成最终报告电子表格来执行数据部分的自动合并。 合并多个电子表格中的数据还包括将数据部分附加到最终报告电子表格。
-