Question
2
Replies
2990
Views
Posted: October 25, 2017
Last activity: October 26, 2017
Closed
Getting an excel range in Openspan
We are having an excel file, and need to get a desired range by passing the starting and ending cell. With this range we then have to perform other operations such as formatting,etc. Please let us know how we can get the desired range
I have gone through Jeff's post on how to get the used range, but it is not clear how to get a desired range.
Hi Devi,
Best way to do that is use script component and write C# code for that.
In below line of code, rowCountOut variable will get the no. of rows in B column of excel.
int rowCountOut = xlWorkSheetOut.UsedRange.Columns["B:B", Type.Missing].Rows.Count;
I hope it will help!!