Faster filling data

2 posts, 0 answers
  1. Dominik
    Dominik avatar
    59 posts
    Member since:
    Dec 2012

    Posted 02 Oct 2015 Link to this post

    Hi,

    Filling the cells one by one is time-consuming.

    Is there any faster way? Something like CopyFromRecordset method.

    Is there any way to insert data into CellRange using RecordSet/Array etc? 

     

     

  2. Svetoslav
    Admin
    Svetoslav avatar
    55 posts

    Posted 06 Oct 2015 Link to this post

    Hello Dominik,

    Currently, RadSpreadProcessing doesn't support out of the box CopyFromRecordset Method but it can be easily achieved. You'll need to iterate over the rows and cells of a worksheet and set the values from your data to the cells. To learn more about this, you can read the article for Get, Set and Clear Cell Properties or SpreadProcessing - Complete Solution to Create, Modify and Export Spreadsheets.

    I hope this helps. Let me know if you need some further assistance.

    Regards,
    Svetoslav
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top