Migrant range for reading a value

[Travis Chambers]

Hi,

The documentation shows how to sufficiently set values on many rows using migrant range, but I also need to read a cell (to see if a comma exists or not) but I cannot find anywhere where it says how to get an existing cell value. Any help is appreciated.

Thanks.

[Shamini Kiruba Sobers]

Hi Travis, 

Greetings from Syncfusion support. 

You can read the cell content in a similar way with the same properties (Text or Value) which are used to get and set the values in a cell or range. Kindly refer the following UG links. 

https://help.syncfusion.com/file-formats/xlsio/worksheet-cells-manipulation#accessing-a-cell-or-range-using-imigrantrange 

https://help.syncfusion.com/file-formats/xlsio/improving-performance#range-access 

Kindly look into the following code snippet to achieve your requirement and let us know if it helps. 

Code snippet: 

IMigrantRange migrantRange = sheet.MigrantRange; 

for (int row = 1; row <= migrantRange.LastRow; row++) 

{ 

    for (int column = 1; column <= migrantRange.LastColumn; column++) 

    { 

        //Read the cell text and check if it contains comma 

        migrantRange.ResetRowColumn(row, column); 

        var cellText = migrantRange.Text; 

        bool containsComma = cellText.Contains(","); 

    } 

} 

Regards, 

Shamini 

[Travis Chambers]

Thank you for your response! This does work, but doesnt seem to speed up my process any. After discovering whether or not a comma exists in each value of a row, I then set formulas in 15 different columns.

Using MigrantRange I am simply using a row loop that looks something like this:

for(int i = 2; i <= lastrow; i++)

{

migrantRange.ResetRowColumn(row, 2);

migrantRange.Formula = "'Sheet1'!AE"+row+"";

}

Previously I was using IRange to set each row in the range to the formula like this:

 application.EnableIncrementalFormula = true;

sheet.Range["B2:B"+lastrow+"].Formula = "'Sheet1'!AE2";

These two methods seem to be equally slow.

Thanks.

[Shamini Kiruba Sobers]

Hi Travis, 

Thanks for the update. 

While setting formulas, the performance will be similar in both cases. We need to know the type of formulas used along with the total number of rows and columns for further analysis. Kindly share us the issue reproducing sample or the input file used at your end, so that we can investigate further and provide prompt solution at the earliest. 

Regards, 

Shamini