OWC11 DataSource binding

B

Bhargav

Hi,

I have a requirement to embed an excel sheet into a winform application. My
application needs to get data from SQL and show in excel sheet and then
update the database with the modified data. I have written the code to
populate AxSpreadSheet component by looping thru source DataTable and
updating cells in excel. This process is very time consuming.

Is there a way to bind AxSpreadSheet to DataTable and get values from
spreadsheet into DataTable. How can I improve the performance of writing and
reading data from AxSpreadSheet.

Any help regarding this matter is highly appreciated.

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting data into axSpreadsheet 1
Want to select specific worksheet in my spreadsheet component 7
Doughnut Chart linked with the slicer in the pivot table 0
Axspreadsheet datasource 0
Class Not Registered Error In Vis Studio IDE 1
Binding a DataSet to a ListObject 5
OWC11 with Vb.Net 10
OWC11 Column formatting 3

Top