Testing PeopleCode APIs
To test the PeopleCode APIs, a PIA sample test page called ‘SpreadSheet API Sample Page’ is available to the users. This section tells you how to use this page to test the PeopleCode APIs.
Output Path should always be specified with the full path and name of file to be created or updated.
Output Directory should always exist. Otherwise, there will be an error displaying “Directory cannot be created.”
To access the SpreadSheet API Sample Page, select.
Field or Control
Input path of existing template file.
Output path where generated excel file is to be saved.
This field has two modes — enable and disable rowset.
When the Enable Rowset checkbox is checked, the entire rowset data is saved as is to the output excel file in a single operation.
When the Enable Rowset checkbox is unchecked, only the cell data field within the rowset is saved to the output excel file in a single operation.
Cell row number within the excel file.
Cell column number within excel file.
Type of cell data (number, string, formula, date).
Following are the defined values of this field:
Cell data to be saved into the excel file.
Invokes Spreadsheet APIs to generate and save the field data into the output excel file.