Automatisk lodret udvidelse af rækker i output fra `excel`-pakken

There is currently an option to automatically horizontally expand rows in the output of the excel PSQL package of Invantive.

However, sometimes the default vertical size also is wrong. For instance, when filling Excel cells with multi-line text like:

a
b
c

In that case only a is visible when opening the spreadsheet.

It would be handy to be able to automatically vertically expand the rows before export to Excel.

Workaround is to select all cells in Excel and then double click on the row separator to have Excel to expand them automatically, but that tends to be forgotten and requires each time a manual action.

Den nuværende workaround er manuelt at opdele den lange tekst i separate rækker ved hjælp af en forespørgsel med csvtable:

select line_with_text
from   csvtable
       ( passing 'line 1' || chr(13) || 'line 2' || chr(13) || 'line 3'
         row delimiter chr(13)
         column delimiter '###shouldneveroccur###'
         columns line_with_text varchar2 position next
       )

hvilket genererer output:

som bør kunne overføres lettere til et brugbart Excel-ark. For mere information om csvtable, se Invantive UniversalSQL - Invantive.