After export to excel not well formated

[M Kumar]

Hi,
     After export  from report to excel format, each row combined with 2 rows, i means row override with 1 rows,
screenshot : http://prntscr.com/l3vj4p

output excel file : https://www.dropbox.com/s/cpnbhyv06yobbqh/InsatantReport.xls?dl=0

[Ivan Hristov]

Hello,

Usually this is due to mispositioned items in the report detail band or table. When exporting to Excel, the report processing engine tries to maintain the designed positions of the items. If the report contains a table, make sure its cell contents are aligned with the cell bounds. If the report is a band report, make sure the items are aligned with each other and that the top and height are equal for the items on a row.

You can check the Design Considerations for Excel Rendering for more recommendations about report layout when exporting to Excel.

If you are unable to determine the issue, please send us the report definition along with some sample data so we can investigate it on our side.

Regards,
Ivan Hristov
Progress Telerik

[M Kumar]

Hi sir,

           I use the below code to generate the report, After getting the report result we export to xls on that time for each row  we get extra blank row in output xls.

 

  Dim iniLeft As Decimal = 0.02
            Dim iniWidth As Decimal = 1.05

            For Each col As System.Data.DataColumn In datas.Columns


                Dim headerTxt As New Telerik.Reporting.TextBox
                headerTxt.Size = New SizeU(Unit.Inch(1.05), Unit.Inch(0.2))
                headerTxt.Location = New Drawing.PointU(Unit.Inch(iniLeft), Unit.Inch(0.02))
                headerTxt.Style.Font.Bold = True
                headerTxt.Style.Font.Size = New Unit(10)
                headerTxt.Style.VerticalAlign = VerticalAlign.Middle
                headerTxt.Style.TextAlign = HorizontalAlign.Left
                headerTxt.StyleName = "Caption"
                headerTxt.Style.BackgroundColor = Color.FromArgb(121, 167, 227)
                headerTxt.Value = col.ColumnName.ToString
                headerTxt.CanGrow = True
                headerTxt.TextWrap = False
                headerTxt.Multiline = True
                labelsGroupHeader.Items.Add(headerTxt)

                Dim detailsTxt As New Telerik.Reporting.TextBox
                detailsTxt.Size = New SizeU(Unit.Inch(1.05), Unit.Inch(0.2))
                detailsTxt.Location = New Drawing.PointU(Unit.Inch(iniLeft), Unit.Inch(0))
                detailsTxt.Style.Font.Size = New Unit(10)
                detailsTxt.Style.VerticalAlign = VerticalAlign.Middle
                detailsTxt.Style.TextAlign = HorizontalAlign.Left
                detailsTxt.StyleName = "Data"
                detailsTxt.CanGrow = True
                detailsTxt.TextWrap = True
                detailsTxt.Multiline = True

                detailsTxt.Value = "=Fields.[" + col.ColumnName.ToString & "]"
                detail.Items.Add(detailsTxt)


                iniLeft = iniLeft + iniWidth


            Next

Here the output xls file link

https://www.dropbox.com/s/yqko1y2fttkd7cu/InsatantReport.xls?dl=0

 

[Ivan Hristov]

Hello,

From the provided source code it seems the items are correctly positioned, but the generation of additional rows depends on the height of the report sections as well. This code sets the height of the text boxes to 0.2 inch, but if the report section is 0.3 inch high, the difference of 0.1 inch will be represented as a new row in Excel export. The engine generates such row in order to preserve the designed report layout.

I have made a small report based on the provided code with a sample CSV data. You can see since the report detail section is 0.2 inch no additional rows are generated. However, on the group header row there is a very thin generated row (index 3), which is due to the location of the headerTxt textbox. It is positioned at 0.02 inch from the top, which produces the new row. The solution is to adjust the report items so they won't have any gaps between them and their containers (report sections). The produced Excel file is also included in the archive.

I hope you will find the attached example useful.

Regards,
Ivan Hristov
Progress Telerik