project.cs

doc du lieu tu excel

			s += "<Font/>" + System.Environment.NewLine;
			s += "<Interior/>" + System.Environment.NewLine;
			s += "<NumberFormat/>" + System.Environment.NewLine;
			s += "<Protection/>" + System.Environment.NewLine;
			s += "</Style>" + System.Environment.NewLine;
			s += "<Style ss:ID=\"s20\" ss:Name=\"Percent\">" + System.Environment.NewLine;
			s += "<NumberFormat ss:Format=\"0%\"/>" + System.Environment.NewLine;
			s += "</Style>" + System.Environment.NewLine;
			s += "<Style ss:ID=\"s21\">" + System.Environment.NewLine;
			s += "<NumberFormat ss:Format=\"Short Date\"/>" + System.Environment.NewLine;
			s += "</Style>" + System.Environment.NewLine;
			s += "<Style ss:ID=\"s27\">" + System.Environment.NewLine;
			s += "<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Bottom\"/>" + System.Environment.NewLine;
			s += "<Font x:Family=\"Swiss\" ss:Bold=\"1\"/>" + System.Environment.NewLine;
			s += "<Interior ss:Color=\"#C0C0C0\" ss:Pattern=\"Solid\"/>" + System.Environment.NewLine;
			s += "</Style>" + System.Environment.NewLine;
			s += "<Style ss:ID=\"s28\" ss:Parent=\"s20\">" + System.Environment.NewLine;
			s += "<Alignment ss:Horizontal=\"Center\" ss:Vertical=\"Bottom\"/>" + System.Environment.NewLine;
			s += "<Font x:Family=\"Swiss\" ss:Bold=\"1\"/>" + System.Environment.NewLine;
			s += "<Interior ss:Color=\"#C0C0C0\" ss:Pattern=\"Solid\"/>" + System.Environment.NewLine;
			s += "</Style>" + System.Environment.NewLine;
			s += "</Styles>" + System.Environment.NewLine;
			s += "<Worksheet ss:Name=\"Current\">" + System.Environment.NewLine;
			s += "<Names>" + System.Environment.NewLine;
			s += "<NamedRange ss:Name=\"Print_Titles\" ss:RefersTo=\"=Current!R1\"/>" + System.Environment.NewLine;
			s += "</Names>" + System.Environment.NewLine;
			s += "<Table ss:ExpandedColumnCount=\"5\" x:FullColumns=\"1\"" + System.Environment.NewLine;
			s += "x:FullRows=\"1\">" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"96\"/>" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"340.5\"/>" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"66.75\"/>" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"66\"/>" + System.Environment.NewLine;
			s += "<Column ss:StyleID=\"s20\" ss:AutoFitWidth=\"0\" ss:Width=\"59.25\"/>" + System.Environment.NewLine;
			s += "<Row ss:StyleID=\"s27\">" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">WBS</Data><NamedCell ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">Name</Data><NamedCell ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">Start Date</Data><NamedCell ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">Finish Date</Data><NamedCell" + System.Environment.NewLine;
			s += "ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell ss:StyleID=\"s28\"><Data ss:Type=\"String\">% Complete</Data><NamedCell" + System.Environment.NewLine;
			s += "ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "</Row>" + System.Environment.NewLine;
			return s;

		}

		/// <summary>
		/// Returns the second part of the Excel XML file.  All the XML after the
		/// current items up to the late items.
		/// </summary>
		/// <returns>The second part of the Excel XML file.</returns>
		private string XmlPart2() {
			string s = "";
			s += "</Table>" + System.Environment.NewLine;
			s += "<WorksheetOptions xmlns=\"urn:schemas-microsoft-com:office:excel\">" + System.Environment.NewLine;
			s += "<PageSetup>" + System.Environment.NewLine;
			s += "<Layout x:Orientation=\"Landscape\"/>" + System.Environment.NewLine;
			s += "<Header x:Data=\"&amp;A\"/>" + System.Environment.NewLine;
			s += "<Footer x:Data=\"Page &amp;P of &amp;N\"/>" + System.Environment.NewLine;
			s += "</PageSetup>" + System.Environment.NewLine;
			s += "<Print>" + System.Environment.NewLine;
			s += "<ValidPrinterInfo/>" + System.Environment.NewLine;
			s += "<HorizontalResolution>1200</HorizontalResolution>" + System.Environment.NewLine;
			s += "<VerticalResolution>1200</VerticalResolution>" + System.Environment.NewLine;
			s += "</Print>" + System.Environment.NewLine;
			s += "<Selected/>" + System.Environment.NewLine;
			s += "<Panes>" + System.Environment.NewLine;
			s += "<Pane>" + System.Environment.NewLine;
			s += "<Number>3</Number>" + System.Environment.NewLine;
			s += "<ActiveRow>1</ActiveRow>" + System.Environment.NewLine;
			s += "</Pane>" + System.Environment.NewLine;
			s += "</Panes>" + System.Environment.NewLine;
			s += "<ProtectObjects>False</ProtectObjects>" + System.Environment.NewLine;
			s += "<ProtectScenarios>False</ProtectScenarios>" + System.Environment.NewLine;
			s += "</WorksheetOptions>" + System.Environment.NewLine;
			s += "</Worksheet>" + System.Environment.NewLine;
			s += "<Worksheet ss:Name=\"Late\">" + System.Environment.NewLine;
			s += "<Names>" + System.Environment.NewLine;
			s += "<NamedRange ss:Name=\"Print_Titles\" ss:RefersTo=\"=Late!R1\"/>" + System.Environment.NewLine;
			s += "</Names>" + System.Environment.NewLine;
			s += "<Table ss:ExpandedColumnCount=\"5\" x:FullColumns=\"1\"" + System.Environment.NewLine;
			s += "x:FullRows=\"1\">" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"96\"/>" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"340.5\"/>" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"66.75\"/>" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"66\"/>" + System.Environment.NewLine;
			s += "<Column ss:StyleID=\"s20\" ss:AutoFitWidth=\"0\" ss:Width=\"59.25\"/>" + System.Environment.NewLine;
			s += "<Row ss:StyleID=\"s27\">" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">WBS</Data><NamedCell ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">Name</Data><NamedCell ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">Start Date</Data><NamedCell ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">Finish Date</Data><NamedCell" + System.Environment.NewLine;
			s += "ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell ss:StyleID=\"s28\"><Data ss:Type=\"String\">% Complete</Data><NamedCell" + System.Environment.NewLine;
			s += "ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "</Row>" + System.Environment.NewLine;
			return s;
		}

		/// <summary>
		/// Returns the third part of the Excel XML file.  All the XML after the
		/// late items up to the future items.
		/// </summary>
		/// <returns>The third part of the Excel XML file.</returns>
		private string XmlPart3() {
			string s = "";
			s += "</Table>" + System.Environment.NewLine;
			s += "<WorksheetOptions xmlns=\"urn:schemas-microsoft-com:office:excel\">" + System.Environment.NewLine;
			s += "<PageSetup>" + System.Environment.NewLine;
			s += "<Layout x:Orientation=\"Landscape\"/>" + System.Environment.NewLine;
			s += "<Header x:Data=\"&amp;A\"/>" + System.Environment.NewLine;
			s += "<Footer x:Data=\"Page &amp;P of &amp;N\"/>" + System.Environment.NewLine;
			s += "</PageSetup>" + System.Environment.NewLine;
			s += "<Print>" + System.Environment.NewLine;
			s += "<ValidPrinterInfo/>" + System.Environment.NewLine;
			s += "<HorizontalResolution>1200</HorizontalResolution>" + System.Environment.NewLine;
			s += "<VerticalResolution>1200</VerticalResolution>" + System.Environment.NewLine;
			s += "</Print>" + System.Environment.NewLine;
			s += "<Panes>" + System.Environment.NewLine;
			s += "<Pane>" + System.Environment.NewLine;
			s += "<Number>3</Number>" + System.Environment.NewLine;
			s += "<ActiveRow>1</ActiveRow>" + System.Environment.NewLine;
			s += "<ActiveCol>1</ActiveCol>" + System.Environment.NewLine;
			s += "</Pane>" + System.Environment.NewLine;
			s += "</Panes>" + System.Environment.NewLine;
			s += "<ProtectObjects>False</ProtectObjects>" + System.Environment.NewLine;
			s += "<ProtectScenarios>False</ProtectScenarios>" + System.Environment.NewLine;
			s += "</WorksheetOptions>" + System.Environment.NewLine;
			s += "</Worksheet>" + System.Environment.NewLine;
			s += "<Worksheet ss:Name=\"Future\">" + System.Environment.NewLine;
			s += "<Names>" + System.Environment.NewLine;
			s += "<NamedRange ss:Name=\"Print_Titles\" ss:RefersTo=\"=Future!R1\"/>" + System.Environment.NewLine;
			s += "</Names>" + System.Environment.NewLine;
			s += "<Table ss:ExpandedColumnCount=\"5\" x:FullColumns=\"1\"" + System.Environment.NewLine;
			s += "x:FullRows=\"1\">" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"96\"/>" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"340.5\"/>" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"66.75\"/>" + System.Environment.NewLine;
			s += "<Column ss:AutoFitWidth=\"0\" ss:Width=\"66\"/>" + System.Environment.NewLine;
			s += "<Column ss:StyleID=\"s20\" ss:AutoFitWidth=\"0\" ss:Width=\"59.25\"/>" + System.Environment.NewLine;
			s += "<Row ss:StyleID=\"s27\">" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">WBS</Data><NamedCell ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">Name</Data><NamedCell ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">Start Date</Data><NamedCell ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell><Data ss:Type=\"String\">Finish Date</Data><NamedCell" + System.Environment.NewLine;
			s += "ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "<Cell ss:StyleID=\"s28\"><Data ss:Type=\"String\">% Complete</Data><NamedCell" + System.Environment.NewLine;
			s += "ss:Name=\"Print_Titles\"/></Cell>" + System.Environment.NewLine;
			s += "</Row>" + System.Environment.NewLine;
			return s;
		}

		/// <summary>
		/// Returns the fourth part of the Excel XML file.  All the XML after the
		/// future items to the end of the file.
		/// </summary>
		/// <returns>The second part of the Excel XML file.</returns>
		 public string XmlPart4() {
			string s = "";
			s += "</Table>" + System.Environment.NewLine;
			s += "<WorksheetOptions xmlns=\"urn:schemas-microsoft-com:office:excel\">" + System.Environment.NewLine;
			s += "<PageSetup>" + System.Environment.NewLine;
			s += "<Layout x:Orientation=\"Landscape\"/>" + System.Environment.NewLine;
			s += "<Header x:Data=\"&amp;A\"/>" + System.Environment.NewLine;
			s += "<Footer x:Data=\"Page &amp;P of &amp;N\"/>" + System.Environment.NewLine;
			s += "</PageSetup>" + System.Environment.NewLine;
			s += "<Print>" + System.Environment.NewLine;
			s += "<ValidPrinterInfo/>" + System.Environment.NewLine;
			s += "<HorizontalResolution>1200</HorizontalResolution>" + System.Environment.NewLine;
			s += "<VerticalResolution>1200</VerticalResolution>" + System.Environment.NewLine;
			s += "</Print>" + System.Environment.NewLine;
			s += "<Panes>" + System.Environment.NewLine;
			s += "<Pane>" + System.Environment.NewLine;
			s += "<Number>3</Number>" + System.Environment.NewLine;
			s += "<ActiveRow>1</ActiveRow>" + System.Environment.NewLine;
			s += "<ActiveCol>1</ActiveCol>" + System.Environment.NewLine;
			s += "</Pane>" + System.Environment.NewLine;
			s += "</Panes>" + System.Environment.NewLine;
			s += "<ProtectObjects>False</ProtectObjects>" + System.Environment.NewLine;
			s += "<ProtectScenarios>False</ProtectScenarios>" + System.Environment.NewLine;
			s += "</WorksheetOptions>" + System.Environment.NewLine;
			s += "</Worksheet>" + System.Environment.NewLine;
			s += "</Workbook>" + System.Environment.NewLine;
			return s;
		}
		#endregion XML
	}
}