Testing Excel Document

Excel documents using the Office Open XML format (xlsx) and direct filling (no AddIn):

To test the document, it must be checked in to a corresponding document info record and then when checking out for editing, the filling will be made.

Testing when using the AddIn:

In order to test the master template, the AddIn must be available in the correct directory (acc. Microsoft Microsoft Office Option „File storage“) and the automatic filling file must be copied into the designated directory (Directory defined with variable %TEMP%, file name $_SAPtoWord.dat).
For the testing, the automatic filling file should contain the Program lines as listed below. It is important for the testing, that options „SAVE“, „QUIT“ and „KILL“ are set „N“. All fields which shall be tested, have to be listed in [DATA] with a key (upper case letters, no prefix). For additional information please refer to the ProNovia SAP DMS FrameWork Manual for default keys and values. It is also described how to create such a file with ProNovia Trace.

[INFO]
VERSI=1
UNAME=TEST
DATUM=20000316
UZEIT=122652
SAVE=N
QUIT=N
KILL=N
RESET=Y
PREFIX=SAP

[DATA]
DOKNR=1234567890
...

By closing and opening of the document, the automatic filling will be performed.