This is a migrated thread and some comments may be shown as answers.

Faster filling data

1 Answer 85 Views
SpreadProcessing
This is a migrated thread and some comments may be shown as answers.
konrad
Top achievements
Rank 1
konrad asked on 02 Oct 2015, 11:12 AM

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? 

 

 

1 Answer, 1 is accepted

Sort by
0
Svetoslav
Telerik team
answered on 06 Oct 2015, 01:37 PM
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, 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
Tags
SpreadProcessing
Asked by
konrad
Top achievements
Rank 1
Answers by
Svetoslav
Telerik team
Share this question
or