Last post Nov 13, 2013 07:27 AM by hemant.yadav
Nov 13, 2013 06:59 AM|hemant.yadav|LINK
Dear All Team Member,
I am reading a excel file which contain visible and hidden rows which need to be imported into system by c#. When i importing and reading its showing all the rows of excel either it has hidden or Visible.
So i want to read and load into the sytem only rows which are visible.
Say I have 20 rows of excel in which i have marked From 15-20 Rows hidden so when i load data it should only show from 1-15 rows data...
Please help me how can i achieve it.
Thanks In Advance.
Nov 13, 2013 07:14 AM|sridhar_rs|LINK
You can loop thru the excel columns and check the hidden property "column.Hidden= true". Also, to improve the performance just come out of the loop if the first column is hidden.
Nov 13, 2013 07:27 AM|hemant.yadav|LINK
Where to check it can you send me sample example?