This is a migrated thread and some comments may be shown as answers.

[Solved] ExportToExcelML : Could not find neighbour element!

4 Answers 166 Views

GridView

This is a migrated thread and some comments may be shown as answers.

Llorens Mathieu asked on 13 Nov 2009, 09:30 AM

Hello,

I just have installed the new Q3 2009 package and I still have an error when I try to export my radgriView into an Excel file.

Before upgrading I had an index out of range error.

After upgrading I have : Could not find neighbour element!

I'am using this very simple piece of code :

                    Dim documentTop As AnalyseForm = CType(MainDock.DocumentManager.ActiveDocument.Controls(0), AnalyseForm)         
            Dim exporter As New ExportToExcelML(documentTop.DataGrid)         
            exporter.SheetMaxRows = ExcelMaxRows._65536         
            exporter.ExportVisualSettings = True         
            Dim fileName As String = "c:\ExportedData.xls"         
            exporter.RunExport(fileName)         

Thanks for your help

4 Answers, 1 is accepted

answered on 18 Nov 2009, 01:32 PM

Hello Llorens Mathieu,

Thank you for writing.

I confirm that we have introduced an issue with the export to excel functionality and it throws the described exception if there are a lot of hidden columns. We are going to address this in the upcoming Service Pack. Unfortunately, the only workaround for the time being is to unhide the columns. Please accept our apologies for the inconvenience.

Do not hesitate to contact me again if you have other questions.

Greetings,
Martin Vasilev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.