公开(公告)号：US20100017698A1

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

申请号：US12570820

申请日：2009-09-30

申请人： Scott H. Hills ,  Kurt M. Joseph ,  Melissa L. Oldenburg ,  Mark A. Nixon

发明人： Scott H. Hills ,  Kurt M. Joseph ,  Melissa L. Oldenburg ,  Mark A. Nixon

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.

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