The isEncircled function is established to judge whether a point is encircled by a shape or not. Only XSSF(xlsx,xlsm).
var excel = new Excel("test.xlsx");
var tf1 = excel.isEncircled("Sheet1", "A1");
var tf2 = excel.isEncircled("Sheet1", "B2", 0.25, 0.5);
| Calling | Returning |
|---|
| Excel . isEncircled ( sheetName , position ) | Boolean |
| Excel . isEncircled ( sheetName , position , checkpointXRate ,checkpointYRate ) | Boolean |
| Parameters | Type | Description |
|---|
| sheetName | String | The sheet name. |
| position | String | The absolute reference of the cell. |
| checkpointXRate | Number | The The rate of the x coordinate of the shape center point to the cell width.
The default is 0.5 . |
| checkpointYRate | Number | The The rate of the y coordinate of the shape center point to the cell height.
The default is 0.5 . |