Posted by: lovejoy on 8 September 2017, 1:14 pm EST

  • Posted 8 September 2017, 1:14 pm EST


    Well, I have a database with 36000 rows, so I'd like to separate this datasoure in some sheets.

    For example, 100 rows per sheet.

    How can I do that?

    Thank you.


  • Replied 8 September 2017, 1:14 pm EST

    Unfortunately this is not possible.  Each sheet has it's own DataSource property so if your database is contained in a DataSet then it will display in one sheet.  You could, however, add the data programatically to each sheet by looping through the data in the rows but that would be alot of overhead and updating the records would be difficult.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels