Issue exporting report to excel

Stimulsoft Reports.JAVA discussion
Post Reply
oogarlo
Posts: 4
Joined: Tue Sep 19, 2017 10:28 am

Issue exporting report to excel

Post by oogarlo »

Hi all,
we're experiencing some problems with excel export of a report containing a simple table with a huge amount of columns (55).
The exported file contains some columns with merged cells also if the content doesn't really requires it.

Reading the forum we've already had a try setting the DivideBigCells to false or disabling the table autowidth property with no results.

We've already read the How to Create Report for Export? section too, but being a simple table with no particular formats or cell placements we've found no suggestions about it.

We're using 2017.1.4 java/JS release. Can you help us?

Thanks in advance.

Here it is in attach a sample of our report with datasource data sample.
Attachments
Report_data.xml
report data
(4.2 KiB) Downloaded 282 times
Report_example.mrt
report structure
(45.95 KiB) Downloaded 267 times
oogarlo
Posts: 4
Joined: Tue Sep 19, 2017 10:28 am

Re: Issue exporting report to excel

Post by oogarlo »

here it is what we have exporting to excel:
Image
several collapsed columns having width like 0.1 (highlighted by arrows).
Once you expand one of these collapsed columns, you'll find merged cells

in attach the exported excel file
Attachments
Report_example.xlsx
(5.5 KiB) Downloaded 257 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Issue exporting report to excel

Post by Alex K. »

Hello,

There are some gaps between cells in the Table component. For correct exporting, please try to use the DataBand component instead Table.

Thank you.
oogarlo
Posts: 4
Joined: Tue Sep 19, 2017 10:28 am

Re: Issue exporting report to excel

Post by oogarlo »

thanks for the hint Aleksey, we'll try with DataBand ;)
oogarlo
Posts: 4
Joined: Tue Sep 19, 2017 10:28 am

Re: Issue exporting report to excel

Post by oogarlo »

DataBand works fine!

Thanks!
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Issue exporting report to excel

Post by Alex K. »

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.
Post Reply