METHOD FOR LOGICAL ORGANIZATION OF WORKSHEETS

• US 20150309979A1
• Filed: 03/10/2015
• Published: 10/29/2015
• Est. Priority Date: 04/28/2014
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Presler-Marshall, Martin J. C., Presnall, Hunter K.
• Granted Patent: US 9,483,458 B2
• Time in Patent Office: Days
• 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 computer-implemented method of accessing data within a spreadsheet including a plurality of worksheets comprising:

assigning a set of attributes to each worksheet within the spreadsheet;

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

displaying the identified worksheets.

2. The computer-implemented method of claim 1, wherein displaying the identified worksheets further comprises:

displaying the identified worksheets in accordance with a user-specified arrangement.

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

4. The computer-implemented method of claim 1, further comprising:

ordering the identified worksheets in accordance with a specified set of conditions.

5. The computer-implemented method of claim 1, further comprising accessing data within multiple spreadsheets, and comprising:

assigning a set of attributes to each worksheet of a plurality of spreadsheets;

identifying 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

displaying the identified worksheets.

6. The computer-implemented method of claim 1, wherein the attribute is a tag.

7. The computer-implemented method of claim 1, wherein the attribute is a key-value pair.