none
Lightswitch: Excel Export not exporting all the datagrid rows RRS feed

  • Question

  • The built-in Excel Export function doesn't export all the rows of the datagrid.  Is there a way to make sure all the rows are retrieved and exported?
    Tuesday, October 29, 2013 9:27 PM

All replies

  • Export to Excel only exports the entities that are currently loaded into the data grid. If you want to have it export all records across all pages, then you need to disable paging before exporting.


    Justin Anderson, LightSwitch Development Team

    Wednesday, October 30, 2013 8:01 AM
    Moderator
  • How does a user disable the option for paging on a desktop application once deployed?  Do you mean the programmer will need to redeploy with different options each time you need to Export to Excel  vs. Paging?
    Wednesday, October 30, 2013 9:18 PM
  • If you want to allow the user to disable paging, you can create a button that toggles the page size of the collection between 0 and whatever page size you want.

    You can also do it all programmatically on the user's behavior through your own export button and use the Office Integration Pack extension to export through code.

    In either case, please look at Is there a way to enable/disable paging programmatically? to see how to toggle paging on/off.


    Justin Anderson, LightSwitch Development Team

    Wednesday, October 30, 2013 9:48 PM
    Moderator
  • Any soultion ;(
    Tuesday, August 19, 2014 11:59 AM