Using PeopleCode APIs for Excel
Following are the operations that a user can perform via PeopleCode :
PeopleCode API |
Description |
---|---|
Open |
Opens existing workbook or creates new workbook. |
SaveAs |
Saves existing template file to new workbook. |
Save |
Saves generated excel file to output location. |
GetFileContent |
Retrieves generated excel file data from output directory. |
SetCellNumber |
Sets number data into the cell within the workbook. |
SetCellString |
Sets string data into the cell within the workbook. |
SetCellFormula |
Sets formula data into the cell within the workbook. |
SetCellDate |
Sets Date data into the cell within the workbook. |
SetColumnWidth |
Sets the width of the column within the workbook. |
SetCellHyperlink |
Sets hyperlink data in the cell. |
SetCellHeaderStyle |
Sets cell header style. |
SetSheetActivate |
Sets the active sheet in the workbook. |
SetActiveSheetName |
Updates the name of the existing sheet within the workbook. |
CreateSheet |
Creates new sheet within the workbook. |
RangeRowOutline |
Enables or disables outline on the range of rows. |
RangeColOutline |
Enables or disables outline on the range of columns. |
RangeApplyStyle |
Sets style of the range of cells. |
InsertRows |
Inserts rows in the active sheet. |
InsertColumns |
Inserts columns in the active sheet. |
SetRowSetData |
Sets scroll rowset data into the sheet. |