CSV Exporting

[Me Mo]

Hello,
We are having a problem with RadGrid export to CSV format,
we have a grid with a template column containing textbox bound to a string field,
When exporting to excel or to word or to pdf, it works fine,
but exporting to CSV doesn't export template columns
Below is the template column.

<telerik:GridTemplateColumn DataField="Field1" SortExpression="Field1"

                                  UniqueName="Field1
" HeaderText="<%$ Resources:Distributor_resource, Field1%>"

                                  AllowFiltering="true" 

                                  <ItemTemplate>

                                      <asp:TextBox ID="txtField1
" runat="server" Text='<%#Bind("Field1")%>'></asp:TextBox>

                                  </ItemTemplate>

                              </telerik:GridTemplateColumn>

Thanks in advance

[Lenny_shp]

Does this work?

<MasterTableView UseAllDataFields="true" ..

[Daniel]

Hello,

@Lenny_shp - This makes sense only when exporting to ExcelML format. It is needed when binding to custom obejcts, LinqDataSource, etc

@Me Mo - Please try the "Exporting unsupported controls" approach shown in the CSV export topic

Regards,
Daniel
the Telerik team

[Me Mo]

Thanks alot
It worked when i added the following code at the button click, but I had to give a value to the column  UniqueName property.

foreach (GridDataItem item in grid.MasterTableView.Items)
                {
                    TextBox txtBoxCode = item["Field1"].FindControl("txtbox") as TextBox;
                    item["Field1"].Text = txtBoxCode.Text;
                }
                grid.MasterTableView.ExportToCSV();

[Chuck Lane]

Is there a comparable way to do this when exporting to excelML?

I've got template columns that have literal controls in them and I loop through the grid master items find the literals and
I'm assigning them to the item[UniqueName].Text as described in the documentation but I'm still just seeing blank columns in my excel export or no columns at all.

If I export the exact same setup to HTML it exports the template columns correctly but It breaks the columns up into too many rows.
Those columns that have a literal in them with more than one line get broken into several rows and there is no border between the individual rows.

Any help with this would be greatly appreciated

Chuck

[Daniel]

Hello Chuck,

ExcelML allows that you change the structure of the worksheet so that you can add the missing content manually. I attached a simple demo to this post.

Best regards,
Daniel
the Telerik team

[Stanislav Dudnyk]

How I can export to CSV format grid with template column containing LinkButton but not use external buttons?
I want use standart grid button for CVS export