[Solved] ExcelML and Q2 2010

[Tim]

I am in the process of upgrading my project to use the Q2 2010 Telerik WinControls (specifically the 2010.2.10.806 version).  After updating I cannot see the ExcelML namespace under Telerik.WinControls.UI.Export.  Am I doing something wrong or is this a known issue?

An example piece of code is as follows:

using Telerik.WinControls.UI.Export;
...
private void btnExport_Click(object sender, EventArgs e)
        {
            //Create a new Temporary File
            ExportToExcelML exporter = new ExportToExcelML(this.mainGrid);
            string fileName = Path.GetTempPath() + "ExportData.xls";

            //Export the grid to the file
            bool exportThemeColors = true;
            exporter.HiddenColumnOption = HiddenOption.DoNotExport;
            exporter.SheetMaxRows = ExcelMaxRows._65536;
            exporter.ExportVisualSettings = exportThemeColors;
            exporter.RunExport(fileName);

            //Open it in Excel
            Process process = new Process();
            process.StartInfo.FileName = fileName;
            process.Start();
        }

My error states that the type or namespace cannot be found.  I even tried opening up the namespace in the object explorer and cannot see the class.  Any help is greatly appreciated!

Thanks,

-Bill

[Tim]

Update:

After going to the menu bar in Visual Studio selecting Telerik - > RadControls for WinForms -> Configure Project  I Checked the TelerikData checkbox and pressed finish, and this seems to have resolved the issue.

I even had the reference to this DLL in my project added before I did this, so I'm not 100% sure what going through this process does differently, but hey it's working so I guess all is fine.

-Bill

[Martin Vasilev]

Hello Bill,

Thank you for writing.

In Q2 2010 we have moved all export method in TelerikData.dll assembly. If you want to use export you simply have to add reference to this assembly in the new project. This was included as breaking change in our  Q2 2010 Release Notes document.

Let me know if you have any additional questions.

Kind regards,
Martin Vasilev
the Telerik team

[Tim]

Martin,
I saw that in the documentation, and went ahead and added a reference to the TelerikData assembly.  However, having that reference, and the correct using statements for some reason still didn't resolve the issue.  I'm still not 100% sure as to what the Telerik menu toolbar in VS 2010 does differently then manually adding the TelerikData.dll, but for some reason using the menu toolbar in VS2010 with the little wizard that is provided, resolved the issue.

Thank you for following up with this reply.

-Bill

[Martin Vasilev]

Hi Bill,

Thank you for getting back to me.

Actually it should not matter if you add references through the Telerik menu or through default Visual Studio UI. I am not sure why this works differently on your side. Anyway, I am glad that you have managed to find how to use export objects in your project. Do not hesitate to contact us again if you have any other questions.

Kind regards,
Martin Vasilev
the Telerik team