Automatisk vertikal utökning av rader i utdata från `excel`-paketet

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.

Tillfällig lösning just nu är att manuellt dela upp den långa texten i separata rader med hjälp av en fråga 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
       )

vilket genererar följande utdata:

som bör gå lättare att omvandla till ett användbart Excel-ark. För mer information om csvtable, se Invantive UniversalSQL - Invantive.