2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
XlsIO has the following API''s to locate the cells that contain the formula, links,strings and Number.
C# for (int i = 0; i < sheet.UsedRange.Rows.Length; i++) { for (int j = 0; j < sheet.UsedRange.Columns.Length; j++) { IRange cell = sheet.Range[i + 1, j + 1]; if (cell.HasFormula == true) { MessageBox.Show(cell.AddressLocal + "" + cell.Formula.ToString()); } } }
VB For i As Integer = 0 To sheet.UsedRange.Rows.Length - 1 For j As Integer = 0 To sheet.UsedRange.Columns.Length - 1 Dim cell As IRange = sheet.Range(i + 1, j + 1) If cell.HasFormula = True Then MessageBox.Show(cell.AddressLocal + cell.Formula.ToString()) End If Next j Next i
Here is the sample for your reference:
|
2X faster development
The ultimate WinForms UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.