Method for logical organization of worksheets

• US 9,483,457 B2
• Filed: 04/28/2014
• Issued: 11/01/2016
• Est. Priority Date: 04/28/2014
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Presler-Marshall, Martin J. C., Presnall, Hunter K.
• Primary Examiner(s): Baderman, Scott
• Assistant Examiner(s): Mrabi, Hassan
• Application Number:
  US14/263,292
• Publication Number:
  US 20150309967A1
• Time in Patent Office: 918 Days
• Field of Search: 715/205, 715/255, 715/211, 715/21, 715/202
• US Class Current: 1/1
• CPC Class Codes: G06F 40/117 Tagging; Marking up details of markup languages G06F40/143; Designating a block; Setting of attributes style sheets, e.g. eXtensible Stylesheet Language Transformation [XSLT], G06F40/154
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

According to one embodiment of the present invention, methods, systems and computer-readable media of accessing data within a spreadsheet are provided. A set of attributes is assigned to each worksheet of a plurality of worksheets within the spreadsheet. One or more worksheets may be identified by comparing the set of attributes for each worksheet to one or more attributes specified within a request for data, and the identified worksheets may be displayed.

Claims

1. A system comprising:

a memory; and

a processor configured to;

access data within a spreadsheet including a plurality of worksheets by assigning a set of a plurality of attributes to each worksheet within the spreadsheet, wherein the set of attributes for a corresponding worksheet describes a type of data in that worksheet;

process a request for data within the spreadsheet to identify one or more worksheets containing the data from among the plurality of worksheets by comparing the set of attributes for each worksheet to one or more attributes specified within the request, wherein the set of attributes for each identified worksheet satisfies the comparison; and

display on a display screen a portion of the spreadsheet including only the identified worksheets.

2. The system of claim 1, wherein the processor is configured to display on a display screen the identified worksheets by displaying the identified worksheets in accordance with a user-specified arrangement.

3. The system of claim 2, wherein the user-specified arrangement includes one of a single window, plural tiled windows, and plural stacked windows.

4. The system of claim 1, wherein the processor is further configured to order the identified worksheets in accordance with a specified set of conditions.

5. The system of claim 1, wherein the processor is further configured to:

access data within multiple spreadsheets by assigning a set of attributes to each worksheet of a plurality of spreadsheets;

identify one or more worksheets of the plurality of spreadsheets by comparing the set of attributes for each worksheet to one or more attributes specified within a request for data; and

display on a display screen the identified worksheets.

6. The system of claim 1, wherein the set of attributes includes a tag.

7. The system of claim 1, wherein the set of attributes includes a key-value pair.

8. A computer program product for providing information to a user, comprising a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code, when executed by a processor, causes the processor to:

access data within a spreadsheet including a plurality of worksheets by assigning a set of a plurality of attributes to each worksheet within the spreadsheet, wherein the set of attributes for a corresponding worksheet describes a type of data in that worksheet;

process a request for data within the spreadsheet to identify one or more worksheets containing the data from among the plurality of worksheets by comparing the set of attributes for each worksheet to one or more attributes specified within the request, wherein the set of attributes for each identified worksheet satisfies the comparison; and

display on a display screen a portion of the spreadsheet including only the identified worksheets.

9. The computer program product of claim 8, wherein the computer readable program code is further configured to cause the processor to display on a display screen the identified worksheets by displaying the identified worksheets in accordance with a user-specified arrangement.

10. The computer program product of claim 9, wherein the user-specified arrangement includes one of a single window, plural tiled windows, and plural stacked windows.

11. The computer program product of claim 8, wherein the computer readable program code is further configured to cause the processor to order the identified worksheets in accordance with a specified set of conditions.

12. The computer program product of claim 8, wherein the computer readable program code is further configured to cause the processor to:

access data within multiple spreadsheets by assigning a set of attributes to each worksheet of a plurality of spreadsheets;

identify one or more worksheets of the plurality of spreadsheets by comparing the set of attributes for each worksheet to one or more attributes specified within a request for data; and

display on a display screen the identified worksheets.

13. The computer program product of claim 8, wherein the set of attributes includes a tag.

14. The computer program product of claim 8, wherein the set of attributes includes a key-value pair.