PivotExportModel Example

[Richard]

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

[Rosen Vladimirov]

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

[Richard]

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

[Richard]

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

[Rosen Vladimirov]

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

[Richard]

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

[Jeremy]

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

[Rosen Vladimirov]

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