The %%$CELL option can be used in DO SET statements of the decollation mission definition to extract values from the Excel cells to variables.
You can use this option to generate the following types of CSV reports:
A full CSV report is decollated as a one-page report. The LINECT=9999 should be specified in the PRINT/CDAM parameter statement. For a full CSV report, Excel cells from A1 to IU255 are available.
A separated CSV report is decollated with each page containing one row. The LINECT=1 should be specified in the PRINT/CDAM parameter statement. For a separated CSV report, Excel columns from A to IU are available.
The following examples demonstrate ways to extract values from Excel cells to variables. You can find these examples in the DEMOCSV member of the CTD REPORTS library.
For a full CSV report, the following decollation mission statement extracts the value from Excel column B2 to variable %%B2:
DO SET %%B2=%%$CELL(B2)
For a separated CSV report, the following decollation mission statement extracts the value from Excel cell A to variable %%A: