Example #1
0
        internal string ToXmlString(int rowNumber, int columnNumber, string nullValSymbol = "-")
        {
            var cellValue = CellValue;

            if (string.IsNullOrEmpty(cellValue))
            {
                cellValue = nullValSymbol;
            }

            var strVal = ExcelExportHelper.FilterControlChar(cellValue.Replace("]]>", "]]>"));

            if (strVal.Length > 32766)
            {
                strVal = strVal.Substring(0, 32766);
            }

            return
                ($"<c r=\"{ExcelExportHelper.GetExcelColumnName(columnNumber)}{rowNumber}\" t=\"inlineStr\"><is><t><![CDATA[{strVal}]]></t></is></c>");
        }