Read excel data and copy them to object
Hello, I have begun with testing our application (written in .NET C#). I have excel with some data about patients(name, surname, sex,...) - every row is a new patients. I used your code for...
Forum Discussion
Have you considered working directly with the spreadsheet via a COM interface? The DDT driver is best for iterating and then done... But if you want to be able to access, at will, various rows, columns, etc, you're best is a direct interface to Excel.
There are two articles posted online that describe how to read and write data to excel. Check out http://smartbear.com/support/viewarticle/24734/ and http://smartbear.com/support/viewarticle/20878/. While they are not exactly what you are looking for, they show how to create an interface to the Excel spreadsheet and how to access specific cells and the data there in.
There are two articles posted online that describe how to read and write data to excel. Check out http://smartbear.com/support/viewarticle/24734/ and http://smartbear.com/support/viewarticle/20878/. While they are not exactly what you are looking for, they show how to create an interface to the Excel spreadsheet and how to access specific cells and the data there in.