Rohan Gupta

Rohan Gupta

  • 2k
  • 6
  • 1.8k

Import excel data to a data table

Sep 10 2014 5:24 AM
Hi I have one excel with a some row and column, and I have set some cell background color, like some performance metric.
Now I want to export this data to a data table with the color code value of the cell.
Please let me suggest any suitable way.
 
I am already able to import data from excel to data table with the oleDbConnection, but how can I get the bgcolor of the cell with the data.
 
Regards
Rohan