从c＃向XML添加分页符到Excel [英] Add a page break in XML to Excel from c#
本文介绍了从c＃向XML添加分页符到Excel的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一个代码如下。我想在几行之后随机添加一个换行符。我该如何添加它。下面是我已经完成的代码，但不知道如何添加换行符。
I have a code as below. I want to add a line break randomly after few lines.. How can i add that. Below is the code which i have done but don't know how to add a line break.
sbGenerateExcel.Append(" <HTML xmlns:x=\"urn:schemas-microsoft-com:office:excel\"> ");
sbGenerateExcel.Append(" <head> ");
sbGenerateExcel.Append( headerfooter );
sbGenerateExcel.Append(" <!--[if gte mso 9]><xml> ");
sbGenerateExcel.Append(" <x:ExcelWorkbook> ");
sbGenerateExcel.Append(" <x:ExcelWorksheets> ");
sbGenerateExcel.Append(" <x:ExcelWorksheet> ");
sbGenerateExcel.Append(" <x:Name>Sample Workbook</x:Name> ");
sbGenerateExcel.Append(" <x:WorksheetOptions> ");
sbGenerateExcel.Append(" <x:Print> ");
sbGenerateExcel.Append(" <x:FitWidth>1</x:FitWidth> ");
sbGenerateExcel.Append(" </x:Print> ");
sbGenerateExcel.Append(" </x:WorksheetOptions> ");
sbGenerateExcel.Append(" </x:ExcelWorksheet> ");
sbGenerateExcel.Append(" </x:ExcelWorksheets> ");
sbGenerateExcel.Append(" </x:ExcelWorkbook> ");
sbGenerateExcel.Append(" </xml><![endif]--> ");
sbGenerateExcel.Append(" </head> ");
sbGenerateExcel.Append(" <body> ");
sbGenerateExcel.Append( prefix);
sbGenerateExcel.Append( HTML_Text);
sbGenerateExcel.Append(" </body> ");
sbGenerateExcel.Append(" </HTML>");
Below is the code related to style
sb.AppendFormat(@" <Style ss:ID=""sNumber"">{0}", Environment.NewLine);
sb.AppendFormat(@" <Alignment ss:WrapText=""1""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Font ss:FontName=""Calibri"" x:Family=""Swiss"" ss:Size=""11"" ss:Color=""#000000""{0}", Environment.NewLine);
sb.AppendFormat(@" ss:Bold=""1""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <NumberFormat ss:Format="""$"#,##0.00""/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""s62"">{0}", Environment.NewLine);
sb.AppendFormat(@" <Alignment ss:WrapText=""1""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <Font ss:FontName=""Calibri"" x:Family=""Swiss"" ss:Size=""11"" ss:Color=""#000000""{0}", Environment.NewLine);
sb.AppendFormat(@" ss:Bold=""1""/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" <Style ss:ID=""s63"">{0}", Environment.NewLine);
sb.AppendFormat(@" <Alignment ss:WrapText=""1""/>{0}", Environment.NewLine);
sb.AppendFormat(@" <NumberFormat ss:Format=""Short Date""/>{0}", Environment.NewLine);
sb.AppendFormat(@" </Style>{0}", Environment.NewLine);
sb.AppendFormat(@" </Styles>{0}", Environment.NewLine);
推荐答案
＃，## 0.00 /> {0}，环境。新队）;
sb.AppendFormat（ @ < / Style> {0}，环境。新队）;
sb.AppendFormat（ @ < Style ss：ID =s62> {0 }，Environment.NewLine）;
sb.AppendFormat（ @ < Alignment ss：WrapText =1/> { 0}，Environment.NewLine）;
sb.AppendFormat（ @ < Font ss：FontName =Calibrix：Family = Swissss：Size =11ss：Color =＃000000{0}，Environment.NewLine）;
sb.AppendFormat（ @ ss：Bold =1/> {0} ，Environment.NewLine）;
sb.AppendFormat（ @ < / Style> {0}，Environment.NewLine）;
sb.AppendFormat（ @ < Style ss：ID =s63> {0 }，Environment.NewLine）;
sb.AppendFormat（ @ < Alignment ss：WrapText =1/> { 0}，Environment.NewLine）;
sb.AppendFormat（ @ < NumberFormat ss：Format =Short Date/> {0}，Environment.NewLine）;
sb.AppendFormat（ @ < / Style> {0}，Environment.NewLine）;
sb.AppendFormat（ @ < / Styles> {0}，环境。 NewLine）;
"#,##0.00""/>{0}", Environment.NewLine); sb.AppendFormat(@" </Style>{0}", Environment.NewLine); sb.AppendFormat(@" <Style ss:ID=""s62"">{0}", Environment.NewLine); sb.AppendFormat(@" <Alignment ss:WrapText=""1""/>{0}", Environment.NewLine); sb.AppendFormat(@" <Font ss:FontName=""Calibri"" x:Family=""Swiss"" ss:Size=""11"" ss:Color=""#000000""{0}", Environment.NewLine); sb.AppendFormat(@" ss:Bold=""1""/>{0}", Environment.NewLine); sb.AppendFormat(@" </Style>{0}", Environment.NewLine); sb.AppendFormat(@" <Style ss:ID=""s63"">{0}", Environment.NewLine); sb.AppendFormat(@" <Alignment ss:WrapText=""1""/>{0}", Environment.NewLine); sb.AppendFormat(@" <NumberFormat ss:Format=""Short Date""/>{0}", Environment.NewLine); sb.AppendFormat(@" </Style>{0}", Environment.NewLine); sb.AppendFormat(@" </Styles>{0}", Environment.NewLine);
换行符通常由< br />完成。标签，但我不确定你的目的。让我
知道它是否适合你。
Line break generally done by <br/> tag but i am not sure your purpose. Let me
know if it's work for you.
这篇关于从c＃向XML添加分页符到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
