BIRT Export content to xlsx - auto fit columns width

suresh@anumolu
edited February 11, 2022 in Analytics #1
<p>Hi, </p>
<p> </p>
<p>The report looks fine in the interactive BIRT viewer, and the layout option is set to Auto(Not Fixed). But when we try to export the report to xlsx/xls the exported columns doesnt preserve the width. the header lables are wrapped, is there anyway can we auto fit the width of the columns once it is exported to xlsx/xls?</p>
<p> </p>
<p>Please let me know if there any setting to apply?</p>
<p> </p>
<p>Thanks for looking into this.</p>
<p> </p>
<p>Thanks</p>
<p>Suresh </p>

Comments

  • Hello,

    I would have the same problem. While seeking for solutions I found this question asked and would like to restart solution findings. Could an emitter help in here and is there a suitable one existing for iHub 16.0.1 ?

    Thank you
    Uwe

  • Hi Uwe,

    You could try a different emitter like this one:

    https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/downloads/

    If that emitter doesn't help with the issue or if you prefer to use the standard emitter, can you provide an example report. Even just a static data source with a couple rows of data should be enough to illustrate the issue. Along with the report, please describe the desired output (i.e. prevent text wrapping in cells B3 and B4). Also, please let me know if the data in the cells to be modified is static or dynamic.

    Warning No formatter is installed for the format ipb