Read Excel sheet by using C# code with few condition.
If a column in the Excel sheet has a value, I must read it, read the values in all the other columns, and put the values in a data table.
For example.
| Resorce | Column 1 |
|---|---|
| 111111 | aaaaaa |
| 444443 | gggggg |
Read the data in the following column if the Resorce column has a value in the row; if not, move on to the next row and repeat the procedure.
Read the data in the following column if the Resorce column has a value in the row; if not, move on to the next row and repeat the procedure and store the values in data table.
New contributor
Arulmurugan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1