This is a migrated thread and some comments may be shown as answers.
PivotExportModel Example
7 Answers 43 Views
This is a migrated thread and some comments may be shown as answers.
Richard
Top achievements
Rank 1
Richard asked on 08 Apr 2013, 09:53 AM
I was very excited to see that exporting functionality has been added to the PivotGrid in the sp1 release, however the documentation is still a little sparse on how to use it. 
Do you have a basic example of generating and excel like report using the Pivot Export Model ?

Thanks,
Richard

7 Answers, 1 is accepted

Sort by
0
Rosen Vladimirov
Telerik team
answered on 08 Apr 2013, 01:26 PM
Hi Richard,

I suggest you to take a look at our online help and online demos. You will find useful examples how to use export to xlsx (Export), docx (Word), pdf and HTML formats. I'm also sending you a project in which we've implemented Export to Excel only. Hopefully you'll find it useful.

Feel free to contact us if you have any suggestions or concerns.

Greetings,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Richard
Top achievements
Rank 1
answered on 08 Apr 2013, 01:33 PM
Hi Rosen,

I can't believe I missed it, I was looking all over the API documentation for code examples and couldn't see anything, my fault.

Thanks for your help
Richard
0
Richard
Top achievements
Rank 1
answered on 08 Apr 2013, 03:02 PM
Hi Rosen,

I have tried your code and the examples online, they are working for the most part but for larger data sets it starts to break down. 

The error I'm getting is SaveFileDialog: "Dialogs must be user-initiated" , it looks like it takes a little bit of time to build the worksheet (about 3 seconds) , and then when it tries to save Silverlight's security blocks it. 

Are you able to recreate the issue and perhaps suggest a work around? 

Cheers,
Richard

0
Accepted
Rosen Vladimirov
Telerik team
answered on 09 Apr 2013, 11:14 AM
Hello Richard,

Thanks for reporting this problem. I've update your Telerik Points as a small sign of our appreciation for your efforts.

We had to modify our code because of this Silverlight limitation. I'm sending you the new version. I'll also update our online help very soon. Could you give it a try and inform us if you have any problems or concerns?

Regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Richard
Top achievements
Rank 1
answered on 09 Apr 2013, 11:27 AM
Hi Rosen,

I have checked it again with your updated code and it works perfectly, the large data sets I was having issues with with yesterday are all exporting now.

Thank you very much for your help.

Richard
0
Jeremy
Top achievements
Rank 1
answered on 30 Jul 2013, 09:03 AM
Hi All

I am also using the updated excel export code, and it works great for a smaller dataset but with a larger set 14K cells it gets stuck.

If I disable the section of code that adds borders it works fine and still produces a good result

 

cellSelection.SetBorders(New CellBorders(leftBorder, topBorder, rightBorder, bottomBorder, insideBorder, insideBorder, Nothing, Nothing))

Not sure why, changing underlying collection and getting stuck in a loop? or if the cumulative effect of this size dataset is too much and it starts to slow?

I'm afraid I'm a little pushed for time to explore this further, but thought it might help if anyone was having the same problem
0
Rosen Vladimirov
Telerik team
answered on 31 Jul 2013, 06:30 AM
Hello Jeremy,

Thank you for sharing your findings. In fact you can just remove setting of left and top border and this will improve the performance (but if you do not need any borders, your workaround will do the job). We are working on these performance issues and hopefully we'll have a solution in the near future.

We are sorry for the caused inconvenience. Feel free to contact us in case you have any other problems or concerns.

Regards,
Rosen Vladimirov
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
Asked by
Richard
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
Richard
Top achievements
Rank 1
Jeremy
Top achievements
Rank 1
Share this question
or