Writing headers

New features in TRANSACTION version 10.6/10.7 > Running scripts > Writing headers

Back to

Writing headers

If an Excel file does not work properly with a script, you may need to write headers to the sheet. You can write headers from the desktop client and also from the add-in for Excel. In the desktop client, the Write Headers button appears on the Run pane.

Write headers in cell-based mapping

In cell-based mapping, headers are written to the cell immediately to the left of the mapped cell. If the prospective header cell contains data, the data is not overwritten.

If a field is mapped to C4, the header is written to B4.
If a header appears in column A, you can choose to continue to map the data but not to write the header, or cancel the entire mapping.
If an ID-based loop is mapped to column C and data appears in C1, you can choose to continue to map the data but not to write the header, or cancel the entire mapping.
If a range-based loop starts in column C4, the header appears in column C3. If the prospective header cell contains data, you can continue to map the data without the header or you can cancel the entire mapping. To write the header, the range must be specified.
For Automap and Read from SAP, the header is written only if the header cell is empty.
For a multiple-cell selection that is dragged to the mapper to map uploads, the header is written only if the header cell is empty.

Approval processes and writing headers

No data review: For a sheet that does not require a data review, you are prompted to save the file locally. The header is written to the local copy.

One- or two-step: The following circumstances apply:

If review is required, and if the file has a production status, the file is downloaded, the header is written to it, and the file is uploaded again.
If review is required, and if the file has a non-production status, you are asked to save the file locally. The header is written to the local copy.

Also in this section

Running multiple or linked files

Scheduling runs

Run options, troubleshooting errors, and Launch GUI

Advanced run settings

Publishing macros in an Excel workbook

Uploading long text

Uploading characters in Japanese to SAP

Windows scripting