Free Support Forum - aspose.com

Method to convert column numbers and letters

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



Dear 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

Download the latest trial version of this product to test different features of this product:
Aspose.Cells for .NET (Latest Version)

Here is a complete runnable solution that can be used to test the variety of other features of this new product.