示例#1
0
 /// <summary>TBD</summary>
 /// <param name="stationName">TBD</param>
 /// <returns>TBD</returns>
 public ExcelXml.Worksheet CreateStationWorksheet(string stationName)
 {
     ExcelXml.Worksheet stationWorksheet = new ExcelXml.Worksheet(stationName);
     stationWorksheet.Table.Columns = this.ReportColumns;
     ExcelXml.PageSetup stationPageSetup = new ExcelXml.PageSetup();
     stationPageSetup.Header.Margin           = 0.3;
     stationPageSetup.Footer.Margin           = 0.3;
     stationPageSetup.PageMargins.Bottom      = 0.25;
     stationPageSetup.PageMargins.Left        = 0.25;
     stationPageSetup.PageMargins.Right       = 0.25;
     stationPageSetup.PageMargins.Top         = 0.25;
     stationPageSetup.Layout.Orientation      = ExcelXml.Orientation.Landscape;
     stationPageSetup.Layout.CenterHorizontal = true;
     stationPageSetup.Layout.CenterVertical   = true;
     stationWorksheet.WorksheetOptions        = new ExcelXml.WorksheetOptions(stationPageSetup, new ExcelXml.Print(null, null, null, null, null, true), false, 75, null, false
                                                                              , 4, 1, new ExcelXml.Pane(3), new ExcelXml.Pane(1), new ExcelXml.Pane(2), new ExcelXml.Pane(0, 2, 7));
     return(stationWorksheet);
 }
示例#2
0
 /// <summary>TBD</summary>
 /// <param name="stationName">TBD</param>
 /// <returns>TBD</returns>
 public ExcelXml.Worksheet CreateStationWorksheet(string stationName)
 {
     ExcelXml.Worksheet stationWorksheet = new ExcelXml.Worksheet(stationName);
     stationWorksheet.Table.Columns = this.ReportColumns;
     ExcelXml.PageSetup stationPageSetup = new ExcelXml.PageSetup();
     stationPageSetup.Header.Margin = 0.3;
     stationPageSetup.Footer.Margin = 0.3;
     stationPageSetup.PageMargins.Bottom = 0.25;
     stationPageSetup.PageMargins.Left = 0.25;
     stationPageSetup.PageMargins.Right = 0.25;
     stationPageSetup.PageMargins.Top = 0.25;
     stationPageSetup.Layout.Orientation = ExcelXml.Orientation.Landscape;
     stationPageSetup.Layout.CenterHorizontal = true;
     stationPageSetup.Layout.CenterVertical = true;
     stationWorksheet.WorksheetOptions = new ExcelXml.WorksheetOptions(stationPageSetup, new ExcelXml.Print(null, null, null, null, null, true), false, 75, null, false
         , 4, 1, new ExcelXml.Pane(3), new ExcelXml.Pane(1), new ExcelXml.Pane(2), new ExcelXml.Pane(0, 2, 7));
     return stationWorksheet;
 }
示例#3
0
 /// <summary>TBD</summary>
 /// <param name="year">TBD</param>
 /// <returns>TBD</returns>
 private ExcelXml.Worksheet GenerateYearWorksheet(int year)
 {
     ExcelXml.Worksheet yearWorksheet = new ExcelXml.Worksheet(Convert.ToString(year));
     yearWorksheet.Table.Columns = this.ReportColumns;
     ExcelXml.PageSetup pageSetup = new ExcelXml.PageSetup();
     pageSetup.Header.Margin = 0.3;
     pageSetup.Footer.Margin = 0.3;
     pageSetup.PageMargins.Bottom = 0.25;
     pageSetup.PageMargins.Left = 0.25;
     pageSetup.PageMargins.Right = 0.25;
     pageSetup.PageMargins.Top = 0.25;
     pageSetup.Layout.Orientation = ExcelXml.Orientation.Landscape;
     pageSetup.Layout.CenterHorizontal = true;
     pageSetup.Layout.CenterVertical = true;
     yearWorksheet.WorksheetOptions = new ExcelXml.WorksheetOptions(pageSetup, new ExcelXml.Print(null, null, null, null, null, true), false, 75, null, false
     , 1, 1, new ExcelXml.Pane(3), new ExcelXml.Pane(1), new ExcelXml.Pane(2), new ExcelXml.Pane(0, 2, 7));
     return yearWorksheet;
 }