private void WriteWorkSheet_HeaderFooter_oddHeader(string tag, HeaderFooterText headerFooter, XElement headerFooterNode) { XElement oddHeaderNode = new XElement(XName.Get(tag, ExcelCommon.Schema_WorkBook_Main.NamespaceName)); StringBuilder strRet = new StringBuilder(); if (string.IsNullOrEmpty(headerFooter.LeftAlignedText) == false) { strRet.Append("&L"); strRet.Append(headerFooter.LeftAlignedText); } if (string.IsNullOrEmpty(headerFooter.CenteredText) == false) { strRet.Append("&C"); strRet.Append(headerFooter.CenteredText); } if (string.IsNullOrEmpty(headerFooter.RightAlignedText) == false) { strRet.Append("&R"); strRet.Append(headerFooter.RightAlignedText); } oddHeaderNode.Value = strRet.ToString(); headerFooterNode.Add(oddHeaderNode); }
private void WriteWorkSheet_HeaderFooter_AddPictures(WorkSheet sheet, HeaderFooterText headerText) { if (headerText.LeftImag != null) sheet._HeaderFooter.Pictures.Add(headerText.LeftImag); if (headerText.CenteredImag != null) sheet._HeaderFooter.Pictures.Add(headerText.CenteredImag); if (headerText.RightAlignedImag != null) sheet._HeaderFooter.Pictures.Add(headerText.RightAlignedImag); }
private void ReadWorkSheet_headerFooter_FooterText(ref HeaderFooterText headerText, string text) { //string text = childNode.Value; string code = text.Substring(0, 2); int startPos = 2; for (int pos = startPos; pos < text.Length - 2; pos++) { string newCode = text.Substring(pos, 2); if (newCode == "&C" || newCode == "&R") { SetText(ref headerText, code, text.Substring(startPos, pos - startPos)); startPos = pos + 2; pos = startPos; code = newCode; } } SetText(ref headerText, code, text.Substring(startPos, text.Length - startPos)); }
private void SetText(ref HeaderFooterText headerText, string code, string text) { switch (code) { case "&L": headerText.LeftAlignedText = text; break; case "&C": headerText.CenteredText = text; break; default: headerText.RightAlignedText = text; break; } }
private void ReadWorkSheet_headerFooter_Image(HeaderFooter headerFooter, ref HeaderFooterText headerFooterText, string tag) { if (headerFooter._Pictures != null) { //偶数页眉 <evenHeader> // 右 "RHEVEN" 中间 “CHEVEN", 左 "LHEVEN" //首页页眉 <firstHeader> // 右 ”RHFIRST“ 中间 "CHFIRST" 左 "LHFIRST" //奇数页眉 <oddHeader> // 右 “RH” 中 "CH" 左 "LH" //奇数页脚 <oddFooter> //F //偶数页脚 <evenFooter> //CFEVEN //首页页脚 <firstFooter> FFIRST string key = string.Format("{0}{1}", "R", tag); if (headerFooter._Pictures.ContainsKey(key)) { headerFooterText.RightAlignedImag = headerFooter._Pictures[key]; headerFooter._Pictures.Remove(key); } key = string.Format("{0}{1}", "C", tag); if (headerFooter._Pictures.ContainsKey(key)) { headerFooterText.CenteredImag = headerFooter._Pictures[key]; headerFooter._Pictures.Remove(key); } key = string.Format("{0}{1}", "L", tag); if (headerFooter._Pictures.ContainsKey(key)) { headerFooterText.LeftImag = headerFooter._Pictures[key]; headerFooter._Pictures.Remove(key); } } }