Using PeopleCode APIs for Excel

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.