Visual Studio 2008
I am unable to find "RadGridViewExcelExporter". There is no RadGridViewExcelExporter under "Telerik.WinControls.Data." I've got "Telerik.WinControls.Data." and "Telerik.WinControls.UI.", but no "Telerik.Data."
In C:\Program Files\Telerik\RadControls for WinForms Q1 2008 SP1\bin
there is a TelerikData.dll.
What am I missing?
Also, how far backward compatible with Microsoft Office/Excel is this feature?
All the way back to Office 97?
Finn
11 Answers, 1 is accepted
Thank you for contacting us.
We have added a new project to our solution called TelerikData. The excel exporter is in this project under Telerik.Data namespace.
Could you please tell me which DLLs you see in C:\Program Files\Telerik\RadControls for WinForms Q2 2008\bin? You should see TelerikData.dll there along with the others.
I'm looking forward to your reply.
Regards,
Boyko Markov
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Rank 1
As I wrote in the original post, I do have TelerikData.dll there.
It's version 6.1.0.0.
My antipathy to VB .NET is growing hour by hour, day by day.
Performance sufffers. You need 10 times the code compared to VB6. There is a limit to the value of "cool" compared to functionality and performance. If it wasn't for the fact that my boss required it be done in .NET and using your "cool" control, I could have had the project completed and being sold weeks ago. I'm sorry for the rambling, but I can't believe I'm the only one feeling this way.
Finn
Thank you for writing.
The RadGridViewExcelExporter class is located in Telerik.Data name space in TelerikData.dll assembly. You have to add reference to assembly file in your project (by default it located in C:\Program Files\Telerik\RadControls for WinForms Q1 2008 SP1\bin folder) and add Imports statement in your class: "Imports Telerik.Data".
If you need additional assistance, do not hesitate to contact me again.
Sincerely yours,
Martin Vasilev
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Rank 1
i export the radgrid to msexcel but it is extremely slow (10 minutes ), to export 2000rows.
please help me.
the code that i use is :
private
void radButton1_Click(object sender, EventArgs e)
{
saveFileDialog.Filter =
"Excel (*.xls)|*.xls";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
if (!saveFileDialog.FileName.Equals(String.Empty))
{
FileInfo file = new FileInfo(saveFileDialog.FileName);
if (file.Extension.Equals(".xls"))
{
Export(saveFileDialog.FileName);
}
else
{
MessageBox.Show("Invalid file type");
}
}
else
{
MessageBox.Show("Please enter a file name.");
}
}
}
private void Export(String filepath)
{
this.exportButton.Enabled = false;
exporter =
new RadGridViewExcelExporter();
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork +=
new DoWorkEventHandler(DoWork);
worker.RunWorkerCompleted +=
new RunWorkerCompletedEventHandler(bg_RunWorkerCompleted);
worker.RunWorkerAsync(filepath);
exporter.Progress +=
new ProgressHandler(exportProgress);
}
private void DoWork(object sender, DoWorkEventArgs e)
{
exporter.Export(
this.radGridView1, (String)e.Argument, "newSheet1");
}
//Update the progress bar with the export progress
private void exportProgress(object sender, ProgressEventArgs e)
{
// Call InvokeRequired to check if thread needs marshalling, to access properly the UI thread.
if (this.InvokeRequired)
{
this.Invoke(new EventHandler(
delegate
{
if (e.ProgressValue <= 100)
{
radProgressBar1.Value1 = e.ProgressValue;
}
else
{
radProgressBar1.Value1 = 100;
}
}));
}
else
{
if (e.ProgressValue <= 100)
{
radProgressBar1.Value1 = e.ProgressValue;
}
else
{
radProgressBar1.Value1 = 100;
}
}
}
// when the worker finishes the export we can do some post processing
private void bg_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
exportButton.Enabled =
true;
this.radProgressBar1.Value1 = 0;
MessageBox.Show("Exporting Finished.");
}
Thank you for writing.
I have to admit that we experience some performance issues in Q3 2008 versions. We are going to release a new version Q1 2009 that contains significant performance improvement. It will be available later today or tomorrow. Please, download it and give it a try.
Do not hesitate to contact me again if you have other questions.
Sincerely yours,
Martin Vasilev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Rank 1
thank you for your imidiate response.
we must improve the performance of the component because it is a very helpful and user friendly
component and it is the only reason not to use it. i want to mention that i use another component
from another company (not need to mention now the name), only because i take the
same results in excel in about 10-20secs.
i look forward to see the new update.
I am glad to inform you that our RadControls for Winforms Q1 2009 is now live and you can download it through your account. Any feedback will be highly appreciated.
I am looking forward to your reply.
Sincerely yours,
Martin Vasilev
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Rank 1
Intellisense does not display telerik.Data namespace
It just has Teleik.WinControls??
Please help
Thnx
Thank you for writing. The reason for the missing namespace could be referencing a non-existing TelerikData.dll file. Please, check your reference if points to a right assembly. Usually you can find TelerikData.dll in Telerik install directory: C:\Program Files\Telerik\RadControls for WinForms Q2 2009 SP1\bin
Kind regards,
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.
Rank 1
Can anyone recommend a better component?
Barry
You can achieve the best performance of exporting to Excel by the ExportToExcelML class. It uses a special XML format, and it has numerous export settings and excellent exporting rate. You can assure yourself of this in our Examples application under the GridView >> Export to Excel >> ExcelML with Events. It demonstrates exporting of 100,000 records. Please, find additional details in the other support tickets that you have created for the exporting functionality.
Kind regards,
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.