I would like to ask you something about formatting cells in excel file (report) throw calling api_datasource.printtoexcel procedure. When I declare columns by v_excelCols_t api_datasource.tt_excelColumns, and when I specify a column, such as (for example): v_excelCols_t(1).datasourceColumnName_tx := 'HIRE_DATE'; v_excelCols_t(1).label_tx := 'HIRE DATE'; v_excelCols_t(1).format_tx :='DD/MM/YYYY'; I want to specify a column by some other attributes, for example, I would like to align column (in fact a cell). How can I do it? And what else can I specify for a column (or cell)? |
Hi Ivan, Unfortunately, it's not possible to align the generated Excel cell. Currently, the API is only able to set the date/number format of the cell and the header label of the column. You can find the example script below:
Best Regards, |