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);
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)