C# (CSharp) ClosedXML.Excel XLAddress.ToStringFixed示例

示例#1

文件： XLRangeAddress.cs 项目： Exort/ExcelTest

        public String ToStringFixed(XLReferenceStyle referenceStyle, Boolean includeSheet)
        {
            if (includeSheet)
            {
                return(String.Format("'{0}'!{1}:{2}",
                                     Worksheet.Name,
                                     _firstAddress.ToStringFixed(referenceStyle),
                                     _lastAddress.ToStringFixed(referenceStyle)));
            }

            return(_firstAddress.ToStringFixed(referenceStyle) + ":" + _lastAddress.ToStringFixed(referenceStyle));
        }

示例#2

文件： XLRangeAddress.cs 项目： zxcvas/ClosedXML

        public String ToStringFixed(XLReferenceStyle referenceStyle, Boolean includeSheet)
        {
            if (includeSheet)
            {
                return(String.Format("{0}!{1}:{2}",
                                     Worksheet.Name.WrapSheetNameInQuotesIfRequired(),
                                     _firstAddress.ToStringFixed(referenceStyle),
                                     _lastAddress.ToStringFixed(referenceStyle)));
            }

            return(_firstAddress.ToStringFixed(referenceStyle) + ":" + _lastAddress.ToStringFixed(referenceStyle));
        }