c# vsto 查找Excel使用的范围地址【对应某块区域】

/// <summary>
        /// 查找Excel使用的范围地址【对应某块区域】
        /// </summary>
        /// <param name="sheet"></param>
        /// <returns>如：A1:Z8</returns>
        public static string GetMinimalUsedRangeAddress(Worksheet sheet)
        {
//最简洁获取实际使用范围
            var sheetRange = sheet.UsedRange.Address.Replace("$", "");

            string address = string.Empty;
            try
            {
                int rowMax = 0;
                int colMax = 0;

                Excel.Range usedRange = sheet.UsedRange;
                Excel.Range lastCell = usedRange.SpecialCells(Excel.XlCellType.xlCellTypeLastCell, Type.Missing);
                int lastRow = lastCell.Row;
                int lastCol = lastCell.Column;
                int rowMin = lastRow + 1;
                int colMin = lastCol + 1;

                int rr = usedRange.Rows.Count;
                int cc = usedRange.Columns.Count;
                for (int r = 1; r <= rr; r++)
                {
                    for (int c = 1; c <= cc; c++)
                    {
                        Excel.Range cell = usedRange.Cells[r, c] as Excel.Range;
                        if (cell != null && cell.Value != null && !String.IsNullOrEmpty(cell.Value.ToString()))
                        {
                            if (cell.Row > rowMax)
                                rowMax = cell.Row;
                            if (cell.Column > colMax)
                                colMax = cell.Column;
                            if (cell.Row < rowMin)
                                rowMin = cell.Row;
                            if (cell.Column < colMin)
                                colMin = cell.Column;
                        }
                        MRCO(cell);
                    }
                }

                if (!(rowMax == 0 || colMax == 0 || rowMin == lastRow + 1 || colMin == lastCol + 1))
                    address = Cells2Address(rowMin, colMin, rowMax, colMax);

                MRCO(lastCell);
                MRCO(usedRange);
            }
            catch (Exception ex)
            {
            }
            return address; 
        }


        public static string Cells2Address(int row1, int col1, int row2, int col2)
        {
            return ColNum2Letter(col1) + row1.ToString() + ":" + ColNum2Letter(col2) + row2.ToString();
        }


        public static string ColNum2Letter(int colNum)
        {
            if (colNum <= 26)
                return ((char)(colNum + 64)).ToString();

            colNum--; 
            return ColNum2Letter(colNum / 26) + ColNum2Letter((colNum % 26) + 1);
        }


        public static void MRCO(object obj)
        {
            if (obj == null) { return; }
            try
            {
                Marshal.ReleaseComObject(obj);
            }
            catch
            {
            }
            finally
            {
                obj = null;
            }
        }