Writing Headers

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

Back to

Writing Headers

If a Google spreadsheet or Excel file is not available with a script or does not work properly with the attached 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

It is possible to write headers for cell-based mapping in Excel and Google sheets.

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 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 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 multiple cells selection that is dragged to the mapper to map uploads, the header is written only if the header cell is empty.

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