Question
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.
Thank you for your response,and yes I am aware that we can use a C# code for getting the response
But what I would like to understand, if you are suggesting to use C# code, because there is no out of the box method to extract the range. The reason I am asking, is once you have a range proxy there are several out of the box methods that can be used on the range for formatting and other function. But if we are going to use the C# code, then we will have to do lot of custom coding for all these activities.
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!!