Names and Indices

Get Cell Name from Row and Column Indices

It is possible to find a cell’s name given the row and column index. This article explains how. Aspose.Cells provides the CellsHelper_CellIndexToName method, which allows developers to get a cell’s name if they provide the row and column index.

Unlike Microsoft Excel, where row and column indices start from 1, Aspose.Cells starts counting row and column indices from 0.

The following sample code illustrates how to use CellsHelper_CellIndexToName to access a cell’s name given a known row and column index. The code generates the following output.

cell_name, err := CellsHelper_CellIndexToName(3, 5)
if err != nil {
    fmt.Println(err)    
}
else
{
	fmt.Println(cell_name)    
}

Get Row and Column Indices from Cell Name

It is possible to find a row and column index of the cell from its name. This article explains how. Aspose.Cells provides the CellsHelper_CellNameToIndex method, which allows developers to get a row and column index from the cell’s name.

Unlike Microsoft Excel, where row and column indices start from 1, Aspose.Cells starts counting row and column indices from 0.

The following sample code illustrates how to use CellsHelper_CellNameToIndex to get the row and column index from the cell’s name. The code generates the following output.

row, column, err := CellsHelper_CellNameToIndex("C4")
if err != nil {
    fmt.Println(err)    
}
else
{
	fmt.Println(row , column)    
}