PivotExportModel Example

8 posts, 1 answers
  1. Richard
    Richard avatar
    72 posts
    Member since:
    Feb 2009

    Posted 08 Apr 2013 Link to this post

    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
  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 08 Apr 2013 Link to this post

    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.

  3. DevCraft banner
  4. Richard
    Richard avatar
    72 posts
    Member since:
    Feb 2009

    Posted 08 Apr 2013 Link to this post

    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
  5. Richard
    Richard avatar
    72 posts
    Member since:
    Feb 2009

    Posted 08 Apr 2013 Link to this post

    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

  6. Answer
    Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 09 Apr 2013 Link to this post

    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.

  7. Richard
    Richard avatar
    72 posts
    Member since:
    Feb 2009

    Posted 09 Apr 2013 Link to this post

    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
  8. Jeremy
    Jeremy avatar
    11 posts
    Member since:
    Jul 2011

    Posted 30 Jul 2013 Link to this post

    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
  9. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 31 Jul 2013 Link to this post

    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 >>
Back to Top
DevCraft banner