Does Aspose excel have a method that will convert a column number to a letter and a letter to a column number. I am using going to use in a vb.net project. If it does not then any sample code would be helpfull. The code needs to be able to pass vb.net Option Strict On Option Compare Text Option Explicit On Thanks, Bob
Acutally we have the method to convert a column number to a letter. Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Cells.ColumnIndexToName.html.
However, a letter to a column number is not available yet. We will add it in the next hotfix.
@bobm,
Aspose.Excel is discontinued and no more active development is done for it. It is replaced by Aspose.Cells which is much better in terms of performance and variety of features which are supported. This product contains both the options i.e. ’ Get Cell Name from Row and Column Indices’ and ’ Get Row and Column Indices from Cell Name’ as demonstrated in the following sample codes:
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
int row = 3;
int column = 5;
string name = Aspose.Cells.CellsHelper.CellIndexToName(row, column);
Console.WriteLine("Cell name: {0}", name);
Program Output Cell name: F4
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
string name = "C4";
int row;
int column;
Aspose.Cells.CellsHelper.CellNameToIndex(name, out row, out column);
Console.WriteLine("Row: {0}, Column: {1}", row, column);
Program Output Row: 3, Column: 2
Here you can find more information about this feature: Names and Indices