The Spreadsheet View

The Spreadsheet View is used when the document loaded into the window is an Excel document.

The Spreadsheet View shown below is split into several sub views: the Address Bar, the Sheets View and the Cell Range View.

The Spreadsheet View

The Address Bar in the Spreadsheet View is the same as the one on the HTML Page View and its functionality is identical to this.

The Sheets View shows the content of the spreadsheet in the usual manner. It contains one tab for each individual sheet in the spreadsheet document as well as an extra tab showing the document properties of this document (shown in Excel under File > Info). This document properties tab is the first tab in the Sheets View and is identified by the icon. Document properties include details such as title, author name, subject, last modified data, etc. The view on the document properties tab is organized just as a regular sheet from the document and its content can be extracted and looped over in exactly the same manner as these sheets.

Elements of the Sheets View may be selected in various different ways. You can select a single cell of the spreadsheet by clicking with the mouse on the cell in the Sheets View. If you hold down the left mouse button and drag the mouse you can select more than one cell. Once you have a current selection you may use the keyboard to move the selection around, e.g. by using either the arrow keys, or one of the keys: Home, End, Page Up or Page Down.

If you click on a column or row header then the entire column or row will be selected and if you click on top left corner of the Sheets View then the entire sheet will be selected. When ever an entire column, row or sheet is selected then this is an open ended selection in the sense that if the column, row or sheet changes in size then the selection still selects the the entire column, row or sheet and not just a column, row or sheet of the specific size it had when you selected it. For example, if you are writing a robot to extract all the rows of a sheet (using a loop step) and the sheet on the day that you create your robot has 42 rows it will not fail the next day when the sheet has more or less rows than 42 rows. If you instead had used a selection like Sheet1!A1:I42 for the table then the robot would always try to extract 42 rows (and 9 columns) regardless of how many rows (and columns) the sheet actually contained.

If you hold down the Shift key while selecting either with the mouse or the keyboard the current selection will be extended. This extension works by selecting the range that contains the current lead selection and the new added cell. The current lead selection is the first cell that you selected when you created the current selection, e.g. if you start dragging with the mouse from cell C5 to E7 in Sheet1 you will get a selection "Sheet1!C5:E7" and your lead selection cell will be C5, if you on the other hand were dragging from E7 to C5 then your lead selection cell will be E7.

The Cell Range View show the current selection as a Excel cell range, e.g. Sheet1!C5:E7. If you enter a new cell range in the view and press Enter, then this becomes the new current selection. The syntax of cell ranges is described in the reference documentation on Cell Ranges.

The Sheets View also shows the cell or cells found by the Range Finders of the current step. These cells are called found cells and will be shown with an orange box in the Sheets View. If you edit the Range Finders, you can click the icon to show the new cells found. You can also configure the Range Finders to use only the currently selected cell or cells by clicking the icon, to use the currently selected cell or cells as well as any other cells found by clicking the icon, to not use the currently selected cell or cells by clicking the icon, or to not use any cells at all by clicking the icon.

Just as for the HTML Page View you can also search specific content within the Spreadsheet View by clicking the icon and the cell found by your search will be the new current selection. You can also copy the content of the current selection to the Clipboard using the icon. If you copy a range that contains more than one cell the content of the Clipboard may be pasted directly into Excel and the values of each cell will be placed in the separate cells in Excel.

The View Mode Selector is a combo box situated in the lower right corner of the Spreadsheet View. This determines what is shown in the cells of the Sheets View. The possible options are:

Formatted Values:

The cells contains what you see in Excel, e.g. dates are shown formatted and numbers may be shown with less decimals than the actual values of the cells.

Plain Values:

The cells contains the actual values that Excel would show if the values of the cells were not formatted, e.g. without rounding of decimals.

Formulas:

If a cell contains a formula then this is shown and otherwise the same value as for the Plain Values mode is shown.