Spread 本身没有提供RC到A1的转换功能,需要编码实现。

简单实现如下:

 
private String RCToA1(FarPoint.Win.Spread.Model.CellRange range)

    {

        Int32 startRow = range.Row + 1;

        Int32 endRow = range.Row + range.RowCount;

        String startColumn = IntToChar(range.Column);

        String endColumn = IntToChar(range.Column + range.ColumnCount - 1);



        MessageBox.Show(String.Format("{0}{1}:{2}{3}", startColumn, startRow, endColumn, endRow));

        return String.Format("{0}{1}:{2}{3}", startColumn, startRow, endColumn, endRow);

    }



    private String IntToChar(Int32 num)

    {

        String str = "";



        if (num == 0)

        {

            str = "A";

        }

        else

        {

            for (Int32 i = 0; num != 0; i++)

            {

                if (num == 1)

                {

                    str = "A" + str;

                    break;

                }

                str = (Char.ConvertFromUtf32(65 - (i != 0 ? 1 : 0) + num % 26)).ToString() + str;

                if ((num % 26 == 0) && (num / 26 == 1))

                {

                    str = "A" + str;

                    break;

                }

                num = num / 26;

            }

        }



        return str;

    }

复制代码