Advertisement
Guest User

Untitled

a guest
Mar 30th, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. for (int r = 2; r <= ws.UsedRange.Rows.Count; r++)
  2. { if (ws.UsedRange.Cells[r, 3].Text == "0")
  3. {
  4. DataRow row = dt.NewRow();
  5.  
  6. for (int c = 1; c < ws.UsedRange.Columns.Count; c++)
  7. {
  8. string cell = ws.Cells[r, c].Text;
  9. row[c - 1] = cell;
  10. }
  11. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement