Search code examples
automationsap-gui

Extending a Spreadsheet with SAP Netweaver Recording and Playback

My question is regarding the "SAP GUI Script Recording and Playback" in SAP NetWeaver. The screenshot shows the three options for saving a file with the "SAP Script Recording and Playback".

enter image description here

One of the options is to "Extend", but when I test it, the spreadsheet is replaced with the new data every time. Can anyone explain why this is happening?

Is there a way that I can have SAP add more data on to the end of a spreadsheet with the "SAP GUI Script Recording and Playback"?

EDIT: List of File Formats

The screenshot below shows the list of available File Formats. enter image description here

Solution

  • Try to use not Export to spreadsheet function but Local file instead. Exporting to spreadsheet has a number of limitations, e.g. number of rows and columns (note 700206), filesize (note 1854956) and many many others.

    Choose unconverted format or spreadsheet format (was renamed to text with tabs after EHP7). Spreadsheet is tab-delimited text in fact, but it is consumed by Excel like a charm, so you can convert it to spreadsheet easily yourself.