WebExcelExporter works but Spreadsheet has no column headers?

shawn posted over 14 years ago

Hello,
I'm trying to use the WebExcelExporter to export a WebDataGrid. This works fine, but when the spreadsheet opens it doesn't include the column names. Any ideas to what I may be missing?

Can anyone point me in the right direction?

Thank you.

Parents

24671

Alexander Todorov posted over 14 years ago

Hi,

Can you check the font and background color/images applied to the column header? It could happen that the font color is white, that's why you cannot see it, but it could be stil there. You can copy and try to paste to see if the text is actually there.

Thank you,

Angel
Cancel
Reply

Cancel
400

Lex posted over 13 years ago in reply to Alexander Todorov

I am having the same problem, its not the fontcolor.

This is the definition of my grid:

<ig:WebDataGrid runat="server" ID="PoolGrid" AutoGenerateColumns="false" Width
="100%"

OnInitializeRow
="PoolGrid_InitializeRow"

DataKeyFields="PoolId" style="margin: -2px 0 0 0"
>

<ClientEvents MouseDown="PoolGridMouseDown" DoubleClick="PoolGridDoubleClick" />

<Columns
>

<ig:BoundDataField DataFieldName="Name" Key="Name" Width="130px"
>

<Header Text="Pool Name"
/>

</ig:BoundDataField
>

<ig:BoundDataField DataFieldName="PoolType" Key="PoolType" Width="60px"
>

<Header Text="Pool Type"
/>

</ig:BoundDataField
>

<ig:BoundDataField DataFieldName="DomainAssignment" Key="DomainAssignment" Width="140px"
>

<Header Text="Domain Assignment"
/>

</ig:BoundDataField
>

<ig:BoundDataField DataFieldName="Description" Key="Description" Width="130px"
>

<Header Text="Description"
/>

</ig:BoundDataField
>

<ig:BoundDataField DataFieldName="RolesAsString" Key="RolesAsString" Width="70px"
>

<Header Text="Roles"
/>

</ig:BoundDataField
>

<ig:BoundDataField DataFieldName="AttributesSummary" Key="AttributesSummary"
>

<Header Text="Attributes"
/>

</ig:BoundDataField
>

</Columns
>

<Behaviors
>

<ig:Activation Enabled="true"
/>

<ig:Selection CellClickAction="Row" RowSelectType="Single" Enabled="true"
/>

<ig:EditingCore AutoCRUD
="False">

</ig:EditingCore
>

</Behaviors
>

</ig:WebDataGrid
>

As you can see nothing special.

This is the code to export:

this
.eExporter.DownloadName = fileName;

this.eExporter.DataExportMode = DataExportMode
.AllDataInDataSource;

this.eExporter.WorkbookFormat = Infragistics.Excel.WorkbookFormat
.Excel2007;

this.eExporter.Export(false, this.PoolGrid, this
.SessionsGrid);

Any idear what direction to look for?

Lex
Cancel
Reply

Cancel
3147

[Infragistics] Nikola Genov posted over 13 years ago in reply to Lex

Hi,

I don't see anything wrong with your code. Can you submit a bug for that issue to our Dev support system including a sample web site or project please.
Cancel
Reply

Cancel
400

Lex posted over 13 years ago in reply to [Infragistics] Nikola Genov

I will try a few other things, will submit a bug if I cant fix it.

Lex
Cancel
Reply

Cancel
400

Lex posted over 13 years ago in reply to Lex

I eventual fixed the problem by adding the following code:

void eExporter_RowExported(object sender, ExcelRowExportedEventArgs
e)
{

if
(e.CurrentRowIndex == 0)
{

for(int
i=0;i<5;i++)
e.WorksheetRow.Cells[i].Value = PoolGrid.Columns[i].Header.Text;

}

}

Lex
Cancel
Reply

Cancel
100

Steven posted over 13 years ago in reply to Lex

This fix worked for me as well, thanks.

I made a small modification to account for any number of columns (VB)::

    Protected Sub WebExcelExporter_RowExported(sender As Object, e As Infragistics.Web.UI.GridControls.ExcelRowExportedEventArgs) Handles WebExcelExporter.RowExported
        If e.CurrentRowIndex = 0 Then
            For i As Integer = 0 To (Grid.Rows(0).Items.Count - 1)
                e.WorksheetRow.Cells(i).Value = Grid.Columns(i).Header.Text
            Next
        End If
    End Sub

But this still doesn't get to the root of why this is happening... am I missing something?

I'm using v11.1 btw
Cancel
Reply

Cancel

Reply

33839

[Infragistics] David Young posted over 13 years ago in reply to Steven

Hey everyone,

Is it that you're not getting the column headers to export? But you're still seeing the row? Could you try calling DataBind() before calling Export? And if someone can attach a small sample reproducing this, I'll take a look and see if it is a bug we can fix.

thanks,
David Young
Cancel
Reply

Cancel

Children

100

Steven posted over 13 years ago in reply to [Infragistics] David Young

Thanks David,

You are correct that the header row is there without any header text in it.

Furthermore, I just did your test and did a DataBind before calling export and that does indeed fix the issue!

If that's the correct approach, simply calling DataBind first then I'm fine with that.

If you want to reproduce the scenario it is very straight forward.

I created a test page with a SQDataSource, populated it with a table from my server and fed that to a WebDataGrid.

Next, I added a WebExcelExporter and a button and called Export on the button click.

I'm using v11.1 with VS2010 SP1 on XP SP3.
Cancel
Reply

Cancel