Header column with new Biff Excel output?

[Mark]

I am glad that we finally got Biff for radgrid but I have a issue  and there is a lack of documentations so maybe you can help.
with ExcelML i was able to do the following in my code behind

Protected Sub ExportGrid_ExcelMLExportRowCreated(sender As Object, e As GridExportExcelMLRowCreatedArgs) Handles ExportGrid.ExcelMLExportRowCreated
        If e.RowType = GridExportExcelMLRowType.HeaderRow Then

            For Each col As GridColumn In ExportGrid.MasterTableView.Columns
                Dim xlCell As CellElement = e.Row.Cells.GetCellByName(col.UniqueName)
                xlCell.StyleValue = "myStyle"
                'xlCell.Attributes.Add("ss:Width", col.HeaderText.Length.ToString())
            Next
        End If
    End Sub

and then

Protected Sub ExportGrid_ExcelMLExportStylesCreated(sender As Object, e As GridExportExcelMLStyleCreatedArgs) Handles ExportGrid.ExcelMLExportStylesCreated
    Dim style = New StyleElement("myStyle")
    style.AlignmentElement.Attributes.Add("ss:WrapText", "1")
    e.Styles.Add(style)
End Sub

is there any way to do this with the RadGrid.BiffExporting Event?

Thanks In Advance

[Andrey]

Hello,

I noticed that my colleague Daniel have answered your query in the support thread you have opened.

In the Biff export you could use the BiffExporting event of RadGrid to achieve your goal:

protected void RadGrid1_BiffExporting(object sender, GridBiffExportingEventArgs e)
{
    xls.Table tbl = e.ExportStructure.Tables[0];
    tbl.Rows[1].Height = 30;
    tbl.Columns[1].Width = 15;
}

Regards,
Andrey
the Telerik team

[Mark]

just so everyone knows when he is referencing XLS it is this

using xls = Telerik.Web.UI.ExportInfrastructure;

[Andrey]

Hi,

Thank you for posting directions in this thread and helping the community.

Kind regards,
Andrey
the Telerik team

[Michael]

Andrey,

You did not answer the question how to add the 'WrapText' attribute using BiffExport.

Thanks,

Michael

[Andrey]

Hi,

Currently I do not see a way how this could be achieved, however, I will consult our Dev for a work-around or for implementation.

Excuse us for any inconvenience caused.

All the best,
Andrey
the Telerik team

[Deepa]

Is there a solution for this problem? I used ExportInfrastructure to export grid contents to excel. I see only few properties that can be set as shown below. Is Wrap text supported? Is there any workaround?

ExportInfrastructure expCell;
expCell.Rowspan = rowSpan;
expCell.Style.Font.Size = fontSize;
expCell.Style.Font.Bold = fontBold;
expCell.Style.Font.Name = fontName;
expCell.Table.Rows[expCell.RowIndex].Height = rowHeight;
expCell.Style.HorizontalAlign = hAlign;
expCell.Style.VerticalAlign = VerticalAlign.Middle;

[Kostadin]

Hello Deepa,

I am afraid that Biff export does not support wrapping and there isn't a workaround for it. You could consider using another export format as HTML format if you want such feature.

Regards,
Kostadin
Telerik

[Avi]

Hi Kostadin,
Is this something on the product roadmap, for BIFF Export to one day support wrapping?  Any idea if there is a fix in an upcoming release?  We like the way BIFF doesn't give a warning when opening the file in Excel, so we prefer this format, but we really would like to control word wrapping.
Thanks,
Adam

[Kostadin]

Hi Adam,

The text wrapping is not implemented in the export engine which we are using and I am not sure whether this feature will be available. Nevertheless I will forward the request to our developers for further investigation on this matter.

Regards,
Kostadin
Telerik

[Andrew]

BIFF export is really powerful and we have used it extensively for generating business reports, but there are a few limitations in regards to formatting which I'd really like to see addressed, such as wrapping and better cell formatting support in general.

Thanks guys!

[Kostadin]

Hello Andrew,

We are aware of those limitation and our developers will investigate them further. Nevertheless I am unable to provide you with information whether those features will be available or not.

Regards,
Kostadin
Telerik

 

 

[Mehmet]

Is there any update on adding the wrap function? It's the biggest feature missing in BIFF exporting.

[Kostadin]

Hello Mehmet,

Note that since Q3 2014 SP1 we introduced a manual text wrapping by using the ExportInfrastructure. More information can be found at the end of the following help article.

Regards,
Kostadin
Telerik