If i have text which has 1000 lines and i want to use only 6 columns. So how can i know that for this particular text how many rows it will take i.e i want to calculate the number of rows for this particular Text which has only 6 columns.
Hi,
Well, I am not sure about your need. Please elaborate it and explain it more, if possible you may give us your template file (manually created in ms excel) or screen_shot to make us understand.
By the way, if you need to get the last row which has data in it, you may use Cells.MaxDataRow attribute to get the last row index.
Similarly, you may get the farthest column by using Cells.MaxDataColumn property.
Thank you.