Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Christian
70
Export (Excel+PDF) MultiColumn Header
posted

 Hi folks,

 my first question would be the following. I am trying to Export  a Webgrid which is design with multi column headers. Each time the export works fine except the mutli cloumn header wich i added in  the webgrid's  UWG_InitializeLayout Method the following way.

 In the Browser it works fine. But after Export it is invisible.

 

Dim ch As New Infragistics.WebUI.UltraWebGrid.ColumnHeader(True)
        ch.Caption = "Employee's Name"

        ' set the origin to be on the top most level of the header
        ch.RowLayoutColumnInfo.OriginY = 0

        ' extend the newly added header over 3 columns
        ch.RowLayoutColumnInfo.SpanX = 20

        ' add the header into the header layout
        e.Layout.Bands(0).HeaderLayout.Add(ch)

Parents
  • 172
    posted

     The current version of the Excel Exporter doesn't support exporting multi-row headers.  Unfortunate, I know.   But you can manually add the headers to the Excel sheet during the export by using the  e.CurrentWorksheet.MergedCellsRegions.Add method in the BeginExport event.

    That also means you'll need to come up with some way of saving the info in the multi-row headers.  Once you add a header row by using the code you posted, you won't be able to look up that same information during the BeginExport event.  You'll have to save that header info in a custom object or some other store and move it to the export event yourself.

    Hope that helps,

    Mike 

Reply Children