How can i convert an Excel document to a datatable and update cells in the excel sheet

Help
,
1

How can I convert an excel document to a datatable and update cells in the excel sheet? And then save the changes in my excel document

2

I think it can be done using Database activities and connecting to excel file thru ODBC though I did not try it.

here you may find more info: windows - Using Excel as an ODBC database - Stack Overflow

3

Why not use ReadRange, and afterwards modify the datatable resulted and save it back to Excel using WriteRange?

2 Likes