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

RadGrid Export to Excel

1 Answer 32 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Rob Venable
Top achievements
Rank 1
Rob Venable asked on 05 Jun 2010, 03:39 AM
Hi,
I have a RadGrid that I use to Export to Excel. I was surprised at how easy it was to do it. I just added the code below and it worked fine.
My question is...Does this rely on Excel being installed on the server or is this going to happen on the client side because it works on my machine but I want to know if it will work if I upload to my web hosting company and I know that most web hosting companies do not allow Microsoft Office on the web server for security reasons.

Thanks
Rob

Private

 

Sub btnExport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExport.Click

 

 

ConfigureExport()

radMonthlyCommissions.MasterTableView.ExportToExcel()

 

 

End Sub

 

 

 

Public Sub ConfigureExport()

radMonthlyCommissions.ExportSettings.ExportOnlyData =

True

 

 

 

radMonthlyCommissions.ExportSettings.IgnorePaging =

True

 

 

radMonthlyCommissions.ExportSettings.OpenInNewWindow =

True

 

End Sub

 

 

1 Answer, 1 is accepted

Sort by
0
Kevin Wood
Top achievements
Rank 1
answered on 06 Jun 2010, 04:07 AM
You don't need Excel installed on the web-server for this to work.
Tags
Grid
Asked by
Rob Venable
Top achievements
Rank 1
Answers by
Kevin Wood
Top achievements
Rank 1
Share this question
or