Jason Bennett's Developer Corner

At the suggestion of  a user (Paul Jensen … thanks for the sample code as well), I have updated the ExcelDocTypeUtils package making the COL_COUNT attribute of the T_WORKSHEET_DATA type optional.  This will allow users to introduce queries with varying numbers of columns dynamically, or use queries such as SELECT * FROM some_table.  In the previous version, the COL_COUNT attribute was mandatory.  I’ve also added a new function called getColHeaderString that will generate a delimited column name list for use with the COL_HEADER_LIST attribute of the T_WORKSHEET_DATA.  This could be used with a ‘SELECT * FROM …’ type query string.

Example:

v_worksheet_rec.col_header_list       := ExcelDocTypeUtils.getColHeaderString(v_worksheet_rec.query,v_worksheet_rec.worksheet_list_delimiter)

(Download the code here:Code)