/// <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);
}
/// <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;
}
/// <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;
}