Copying Entire Collections to a Spreadsheet
You can copy an entire collection of records from the system to a spreadsheet
using the steps below, or you can use the To
Excel menu option.
These steps assume that you have the form open and the collection you
want to copy showing.
To copy an entire collection to a spreadsheet:
- Click the blank box in the upper-left corner of the grid. This
action selects and highlights the entire collection.
- Press CTRL+C or select Edit > Copy. The contents of the
collection are copied to the system clipboard.
- In your spreadsheet application, select the cell you want to be
the first (most upper-left) cell of the collection. Typically, this
is the first cell in the worksheet.
- Press CTRL+V or use whatever command your spreadsheet program uses
to paste in the material.
NOTES:
- Carriage returns and line feeds in a multi-line cell are removed
when you copy a row to the clipboard. So, if you have multi-line
cells, you must copy those cells separately or reconstruct them
in the spreadsheet.
- This procedure can copy only the records that have actually
been retrieved. So, if you want to copy all the records from a
collection, and the cap prevents some records from being displayed,
you must change the cap so that all records are retrieved. For
more information, see Retrieving
Collections and About
Caps.
- By default, the system does not copy and paste the header row
of the collection as part of this procedure. If you want to copy
the header row as well as the records, do one of the following:
- Use the To
Excel menu option.
- Select View>Settings and then select Include
grid column headers when copying to clipboard in the Runtime
- Behavior section.
Related Topics
Copying
Data To/From a Spreadsheet
Copying
Selected Cells to a Spreadsheet
Copying
Selected Columns to a Spreadsheet
Copying
Selected Records to a Spreadsheet
Pasting
Entire Collections into a Grid from a Spreadsheet
Pasting Selected
Records (Rows) from a Spreadsheet
Pasting
the Contents of a Single Cell from a Spreadsheet