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.