Rinkur's Blog: April 2010

Here’s simple example how can we export some table data to xlsx file using Open XML SDK. It creates xlsx file and inserts table in it.

Steps:

1> Create a New Web applciation project in visual studio 2008

File-> New->Visual C#->Web ->ASP.Net Web application

2> For using open xml sdk , you need to add following refrences:

WindowsBase

DocumentFormat.OpenXml

3> Create a class file called export.cs

4> Add the following code in it.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using DocumentFormat.OpenXml.Packaging;
using Ap = DocumentFormat.OpenXml.ExtendedProperties;
using Vt = DocumentFormat.OpenXml.VariantTypes;
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Spreadsheet;
using Xdr = DocumentFormat.OpenXml.Drawing.Spreadsheet;
using A = DocumentFormat.OpenXml.Drawing;
using C = DocumentFormat.OpenXml.Drawing.Charts;

namespace WebApplication15
{
public class export
{

// Creates a SpreadsheetDocument.
public void CreatePackage(string filePath)
{
using (SpreadsheetDocument package = SpreadsheetDocument.Create(filePath, SpreadsheetDocumentType.Workbook))
{
CreateParts(package);
}
}

// Adds child parts and generates content of the specified part.
private void CreateParts(SpreadsheetDocument document)
{
ExtendedFilePropertiesPart extendedFilePropertiesPart1 = document.AddNewPart("rId3");
GenerateExtendedFilePropertiesPart1Content(extendedFilePropertiesPart1);

WorkbookPart workbookPart1 = document.AddWorkbookPart();
GenerateWorkbookPart1Content(workbookPart1);

WorksheetPart worksheetPart1 = workbookPart1.AddNewPart("rId3");
GenerateWorksheetPart1Content(worksheetPart1);

DrawingsPart drawingsPart1 = worksheetPart1.AddNewPart("rId2");
GenerateDrawingsPart1Content(drawingsPart1);

ChartPart chartPart1 = drawingsPart1.AddNewPart("rId1");
GenerateChartPart1Content(chartPart1);

SpreadsheetPrinterSettingsPart spreadsheetPrinterSettingsPart1 = worksheetPart1.AddNewPart("rId1");
GenerateSpreadsheetPrinterSettingsPart1Content(spreadsheetPrinterSettingsPart1);

WorksheetPart worksheetPart2 = workbookPart1.AddNewPart("rId2");
GenerateWorksheetPart2Content(worksheetPart2);

TableDefinitionPart tableDefinitionPart1 = worksheetPart2.AddNewPart("rId2");
GenerateTableDefinitionPart1Content(tableDefinitionPart1);

SpreadsheetPrinterSettingsPart spreadsheetPrinterSettingsPart2 = worksheetPart2.AddNewPart("rId1");
GenerateSpreadsheetPrinterSettingsPart2Content(spreadsheetPrinterSettingsPart2);

WorksheetPart worksheetPart3 = workbookPart1.AddNewPart("rId1");
GenerateWorksheetPart3Content(worksheetPart3);

SpreadsheetPrinterSettingsPart spreadsheetPrinterSettingsPart3 = worksheetPart3.AddNewPart("rId1");
GenerateSpreadsheetPrinterSettingsPart3Content(spreadsheetPrinterSettingsPart3);

SharedStringTablePart sharedStringTablePart1 = workbookPart1.AddNewPart("rId6");
GenerateSharedStringTablePart1Content(sharedStringTablePart1);

WorkbookStylesPart workbookStylesPart1 = workbookPart1.AddNewPart("rId5");
GenerateWorkbookStylesPart1Content(workbookStylesPart1);

ThemePart themePart1 = workbookPart1.AddNewPart("rId4");
GenerateThemePart1Content(themePart1);

SetPackageProperties(document);
}

// Generates content of extendedFilePropertiesPart1.
private void GenerateExtendedFilePropertiesPart1Content(ExtendedFilePropertiesPart extendedFilePropertiesPart1)
{
Ap.Properties properties1 = new Ap.Properties();
Ap.Application application1 = new Ap.Application();
application1.Text = "Microsoft Excel";
Ap.DocumentSecurity documentSecurity1 = new Ap.DocumentSecurity();
documentSecurity1.Text = "0";
Ap.ScaleCrop scaleCrop1 = new Ap.ScaleCrop();
scaleCrop1.Text = "false";

Ap.HeadingPairs headingPairs1 = new Ap.HeadingPairs();

Vt.VTVector vTVector1 = new Vt.VTVector() { BaseType = Vt.VectorBaseValues.Variant, Size = (UInt32Value)2U };

Vt.Variant variant1 = new Vt.Variant();
Vt.VTLPSTR vTLPSTR1 = new Vt.VTLPSTR();
vTLPSTR1.Text = "Worksheets";

variant1.Append(vTLPSTR1);

Vt.Variant variant2 = new Vt.Variant();
Vt.VTInt32 vTInt321 = new Vt.VTInt32();
vTInt321.Text = "3";

variant2.Append(vTInt321);

vTVector1.Append(variant1);
vTVector1.Append(variant2);

headingPairs1.Append(vTVector1);

Ap.TitlesOfParts titlesOfParts1 = new Ap.TitlesOfParts();

Vt.VTVector vTVector2 = new Vt.VTVector() { BaseType = Vt.VectorBaseValues.Lpstr, Size = (UInt32Value)3U };
Vt.VTLPSTR vTLPSTR2 = new Vt.VTLPSTR();
vTLPSTR2.Text = "Summary";
Vt.VTLPSTR vTLPSTR3 = new Vt.VTLPSTR();
vTLPSTR3.Text = "Asset_Details";
Vt.VTLPSTR vTLPSTR4 = new Vt.VTLPSTR();
vTLPSTR4.Text = "Graphical View";

vTVector2.Append(vTLPSTR2);
vTVector2.Append(vTLPSTR3);
vTVector2.Append(vTLPSTR4);

titlesOfParts1.Append(vTVector2);
Ap.Company company1 = new Ap.Company();
company1.Text = "";
Ap.LinksUpToDate linksUpToDate1 = new Ap.LinksUpToDate();
linksUpToDate1.Text = "false";
Ap.SharedDocument sharedDocument1 = new Ap.SharedDocument();
sharedDocument1.Text = "false";
Ap.HyperlinksChanged hyperlinksChanged1 = new Ap.HyperlinksChanged();
hyperlinksChanged1.Text = "false";
Ap.ApplicationVersion applicationVersion1 = new Ap.ApplicationVersion();
applicationVersion1.Text = "12.0000";

properties1.Append(application1);
properties1.Append(documentSecurity1);
properties1.Append(scaleCrop1);
properties1.Append(headingPairs1);
properties1.Append(titlesOfParts1);
properties1.Append(company1);
properties1.Append(linksUpToDate1);
properties1.Append(sharedDocument1);
properties1.Append(hyperlinksChanged1);
properties1.Append(applicationVersion1);

extendedFilePropertiesPart1.Properties = properties1;
}

// Generates content of workbookPart1.
private void GenerateWorkbookPart1Content(WorkbookPart workbookPart1)
{
Workbook workbook1 = new Workbook();
FileVersion fileVersion1 = new FileVersion() { ApplicationName = "xl", LastEdited = "4", LowestEdited = "4", BuildVersion = "4506" };
WorkbookProperties workbookProperties1 = new WorkbookProperties() { FilterPrivacy = true, DefaultThemeVersion = (UInt32Value)124226U };

BookViews bookViews1 = new BookViews();
WorkbookView workbookView1 = new WorkbookView() { XWindow = -315, YWindow = 75, WindowWidth = (UInt32Value)14805U, WindowHeight = (UInt32Value)8010U, ActiveTab = (UInt32Value)2U };

bookViews1.Append(workbookView1);

Sheets sheets1 = new Sheets();
Sheet sheet1 = new Sheet() { Name = "Summary", SheetId = (UInt32Value)1U, Id = "rId1" };
Sheet sheet2 = new Sheet() { Name = "Asset_Details", SheetId = (UInt32Value)2U, Id = "rId2" };
Sheet sheet3 = new Sheet() { Name = "Graphical View", SheetId = (UInt32Value)3U, Id = "rId3" };

sheets1.Append(sheet1);
sheets1.Append(sheet2);
sheets1.Append(sheet3);
CalculationProperties calculationProperties1 = new CalculationProperties() { CalculationId = (UInt32Value)125725U };

workbook1.Append(fileVersion1);
workbook1.Append(workbookProperties1);
workbook1.Append(bookViews1);
workbook1.Append(sheets1);
workbook1.Append(calculationProperties1);

workbookPart1.Workbook = workbook1;
}

// Generates content of worksheetPart1.
private void GenerateWorksheetPart1Content(WorksheetPart worksheetPart1)
{
Worksheet worksheet1 = new Worksheet();
SheetDimension sheetDimension1 = new SheetDimension() { Reference = "A1:B3" };

SheetViews sheetViews1 = new SheetViews();

SheetView sheetView1 = new SheetView() { TabSelected = true, WorkbookViewId = (UInt32Value)0U };
Selection selection1 = new Selection() { ActiveCell = "C9", SequenceOfReferences = new ListValue() { InnerText = "C9" } };

sheetView1.Append(selection1);

sheetViews1.Append(sheetView1);
SheetFormatProperties sheetFormatProperties1 = new SheetFormatProperties() { DefaultRowHeight = 15D };

SheetData sheetData1 = new SheetData();

Row row1 = new Row() { RowIndex = (UInt32Value)1U, Spans = new ListValue() { InnerText = "1:2" } };

Cell cell1 = new Cell() { CellReference = "A1", StyleIndex = (UInt32Value)11U, DataType = CellValues.SharedString };
CellValue cellValue1 = new CellValue();
cellValue1.Text = "46";

cell1.Append(cellValue1);

//@rinks::graph values in cellValue2.text will be "count(high val in average rating)"

Cell cell2 = new Cell() { CellReference = "B1", StyleIndex = (UInt32Value)11U };
CellValue cellValue2 = new CellValue();
cellValue2.Text = "100";

cell2.Append(cellValue2);

row1.Append(cell1);
row1.Append(cell2);

Row row2 = new Row() { RowIndex = (UInt32Value)2U, Spans = new ListValue() { InnerText = "1:2" } };

Cell cell3 = new Cell() { CellReference = "A2", StyleIndex = (UInt32Value)11U, DataType = CellValues.SharedString };
CellValue cellValue3 = new CellValue();
cellValue3.Text = "47";

cell3.Append(cellValue3);
//@rinks::graph values in cellValue2.text will be "count(medium val in average rating)"

Cell cell4 = new Cell() { CellReference = "B2", StyleIndex = (UInt32Value)11U };
CellValue cellValue4 = new CellValue();
cellValue4.Text = "100";

cell4.Append(cellValue4);

row2.Append(cell3);
row2.Append(cell4);

Row row3 = new Row() { RowIndex = (UInt32Value)3U, Spans = new ListValue() { InnerText = "1:2" } };

Cell cell5 = new Cell() { CellReference = "A3", StyleIndex = (UInt32Value)11U, DataType = CellValues.SharedString };
CellValue cellValue5 = new CellValue();
cellValue5.Text = "48";

cell5.Append(cellValue5);
//@rinks::graph values in cellValue2.text will be "count(low val in average rating)"

Cell cell6 = new Cell() { CellReference = "B3", StyleIndex = (UInt32Value)11U };
CellValue cellValue6 = new CellValue();
cellValue6.Text = "100";

cell6.Append(cellValue6);

row3.Append(cell5);
row3.Append(cell6);

sheetData1.Append(row1);
sheetData1.Append(row2);
sheetData1.Append(row3);
PageMargins pageMargins1 = new PageMargins() { Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
PageSetup pageSetup1 = new PageSetup() { Orientation = OrientationValues.Portrait, Id = "rId1" };
Drawing drawing1 = new Drawing() { Id = "rId2" };

worksheet1.Append(sheetDimension1);
worksheet1.Append(sheetViews1);
worksheet1.Append(sheetFormatProperties1);
worksheet1.Append(sheetData1);
worksheet1.Append(pageMargins1);
worksheet1.Append(pageSetup1);
worksheet1.Append(drawing1);

worksheetPart1.Worksheet = worksheet1;
}

// Generates content of drawingsPart1.
private void GenerateDrawingsPart1Content(DrawingsPart drawingsPart1)
{
Xdr.WorksheetDrawing worksheetDrawing1 = new Xdr.WorksheetDrawing();

Xdr.TwoCellAnchor twoCellAnchor1 = new Xdr.TwoCellAnchor();

Xdr.FromMarker fromMarker1 = new Xdr.FromMarker();
Xdr.ColumnId columnId1 = new Xdr.ColumnId();
columnId1.Text = "4";
Xdr.ColumnOffset columnOffset1 = new Xdr.ColumnOffset();
columnOffset1.Text = "76200";
Xdr.RowId rowId1 = new Xdr.RowId();
rowId1.Text = "6";
Xdr.RowOffset rowOffset1 = new Xdr.RowOffset();
rowOffset1.Text = "9525";

fromMarker1.Append(columnId1);
fromMarker1.Append(columnOffset1);
fromMarker1.Append(rowId1);
fromMarker1.Append(rowOffset1);

Xdr.ToMarker toMarker1 = new Xdr.ToMarker();
Xdr.ColumnId columnId2 = new Xdr.ColumnId();
columnId2.Text = "11";
Xdr.ColumnOffset columnOffset2 = new Xdr.ColumnOffset();
columnOffset2.Text = "381000";
Xdr.RowId rowId2 = new Xdr.RowId();
rowId2.Text = "20";
Xdr.RowOffset rowOffset2 = new Xdr.RowOffset();
rowOffset2.Text = "85725";

toMarker1.Append(columnId2);
toMarker1.Append(columnOffset2);
toMarker1.Append(rowId2);
toMarker1.Append(rowOffset2);

Xdr.GraphicFrame graphicFrame1 = new Xdr.GraphicFrame() { Macro = "" };

Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties1 = new Xdr.NonVisualGraphicFrameProperties();
Xdr.NonVisualDrawingProperties nonVisualDrawingProperties1 = new Xdr.NonVisualDrawingProperties() { Id = (UInt32Value)2U, Name = "Chart 1" };
Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties1 = new Xdr.NonVisualGraphicFrameDrawingProperties();

nonVisualGraphicFrameProperties1.Append(nonVisualDrawingProperties1);
nonVisualGraphicFrameProperties1.Append(nonVisualGraphicFrameDrawingProperties1);

Xdr.Transform transform1 = new Xdr.Transform();
A.Offset offset1 = new A.Offset() { X = 0L, Y = 0L };
A.Extents extents1 = new A.Extents() { Cx = 0L, Cy = 0L };

transform1.Append(offset1);
transform1.Append(extents1);

A.Graphic graphic1 = new A.Graphic();

A.GraphicData graphicData1 = new A.GraphicData() { Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };
C.ChartReference chartReference1 = new C.ChartReference() { Id = "rId1" };

graphicData1.Append(chartReference1);

graphic1.Append(graphicData1);

graphicFrame1.Append(nonVisualGraphicFrameProperties1);
graphicFrame1.Append(transform1);
graphicFrame1.Append(graphic1);
Xdr.ClientData clientData1 = new Xdr.ClientData();

twoCellAnchor1.Append(fromMarker1);
twoCellAnchor1.Append(toMarker1);
twoCellAnchor1.Append(graphicFrame1);
twoCellAnchor1.Append(clientData1);

worksheetDrawing1.Append(twoCellAnchor1);

drawingsPart1.WorksheetDrawing = worksheetDrawing1;
}

// Generates content of chartPart1.
private void GenerateChartPart1Content(ChartPart chartPart1)
{
C.ChartSpace chartSpace1 = new C.ChartSpace();
C.EditingLanguage editingLanguage1 = new C.EditingLanguage() { Val = "en-US" };

C.Chart chart1 = new C.Chart();

C.Title title1 = new C.Title();
C.Layout layout1 = new C.Layout();

title1.Append(layout1);

C.View3D view3D1 = new C.View3D();
C.RightAngleAxes rightAngleAxes1 = new C.RightAngleAxes() { Val = true };

view3D1.Append(rightAngleAxes1);

C.PlotArea plotArea1 = new C.PlotArea();
C.Layout layout2 = new C.Layout();

C.Bar3DChart bar3DChart1 = new C.Bar3DChart();
C.BarDirection barDirection1 = new C.BarDirection() { Val = C.BarDirectionValues.Column };
C.BarGrouping barGrouping1 = new C.BarGrouping() { Val = C.BarGroupingValues.Clustered };

C.BarChartSeries barChartSeries1 = new C.BarChartSeries();
C.Index index1 = new C.Index() { Val = (UInt32Value)0U };
C.Order order1 = new C.Order() { Val = (UInt32Value)0U };

C.SeriesText seriesText1 = new C.SeriesText();
C.NumericValue numericValue1 = new C.NumericValue();
numericValue1.Text = "Risk Rating";

seriesText1.Append(numericValue1);

C.CategoryAxisData categoryAxisData1 = new C.CategoryAxisData();

C.StringReference stringReference1 = new C.StringReference();
C.Formula formula1 = new C.Formula();
formula1.Text = "\'Graphical View\'!$A$1:$A$3";

C.StringCache stringCache1 = new C.StringCache();
C.PointCount pointCount1 = new C.PointCount() { Val = (UInt32Value)3U };

C.StringPoint stringPoint1 = new C.StringPoint() { Index = (UInt32Value)0U };
C.NumericValue numericValue2 = new C.NumericValue();
numericValue2.Text = "HIGH";

stringPoint1.Append(numericValue2);

C.StringPoint stringPoint2 = new C.StringPoint() { Index = (UInt32Value)1U };
C.NumericValue numericValue3 = new C.NumericValue();
numericValue3.Text = "MEDIUM";

stringPoint2.Append(numericValue3);

C.StringPoint stringPoint3 = new C.StringPoint() { Index = (UInt32Value)2U };
C.NumericValue numericValue4 = new C.NumericValue();
numericValue4.Text = "LOW";

stringPoint3.Append(numericValue4);

stringCache1.Append(pointCount1);
stringCache1.Append(stringPoint1);
stringCache1.Append(stringPoint2);
stringCache1.Append(stringPoint3);

stringReference1.Append(formula1);
stringReference1.Append(stringCache1);

categoryAxisData1.Append(stringReference1);

C.Values values1 = new C.Values();

C.NumberReference numberReference1 = new C.NumberReference();
C.Formula formula2 = new C.Formula();
formula2.Text = "\'Graphical View\'!$B$1:$B$3";

C.NumberingCache numberingCache1 = new C.NumberingCache();
C.FormatCode formatCode1 = new C.FormatCode();
formatCode1.Text = "General";
C.PointCount pointCount2 = new C.PointCount() { Val = (UInt32Value)3U };

C.NumericPoint numericPoint1 = new C.NumericPoint() { Index = (UInt32Value)0U };
C.NumericValue numericValue5 = new C.NumericValue();
numericValue5.Text = "100";

numericPoint1.Append(numericValue5);

C.NumericPoint numericPoint2 = new C.NumericPoint() { Index = (UInt32Value)1U };
C.NumericValue numericValue6 = new C.NumericValue();
numericValue6.Text = "100";

numericPoint2.Append(numericValue6);

C.NumericPoint numericPoint3 = new C.NumericPoint() { Index = (UInt32Value)2U };
C.NumericValue numericValue7 = new C.NumericValue();
numericValue7.Text = "100";

numericPoint3.Append(numericValue7);

numberingCache1.Append(formatCode1);
numberingCache1.Append(pointCount2);
numberingCache1.Append(numericPoint1);
numberingCache1.Append(numericPoint2);
numberingCache1.Append(numericPoint3);

numberReference1.Append(formula2);
numberReference1.Append(numberingCache1);

values1.Append(numberReference1);

barChartSeries1.Append(index1);
barChartSeries1.Append(order1);
barChartSeries1.Append(seriesText1);
barChartSeries1.Append(categoryAxisData1);
barChartSeries1.Append(values1);
C.Shape shape1 = new C.Shape() { Val = C.ShapeValues.Box };
C.AxisId axisId1 = new C.AxisId() { Val = (UInt32Value)74774400U };
C.AxisId axisId2 = new C.AxisId() { Val = (UInt32Value)74775936U };
C.AxisId axisId3 = new C.AxisId() { Val = (UInt32Value)0U };

bar3DChart1.Append(barDirection1);
bar3DChart1.Append(barGrouping1);
bar3DChart1.Append(barChartSeries1);
bar3DChart1.Append(shape1);
bar3DChart1.Append(axisId1);
bar3DChart1.Append(axisId2);
bar3DChart1.Append(axisId3);

C.CategoryAxis categoryAxis1 = new C.CategoryAxis();
C.AxisId axisId4 = new C.AxisId() { Val = (UInt32Value)74774400U };

C.Scaling scaling1 = new C.Scaling();
C.Orientation orientation1 = new C.Orientation() { Val = C.OrientationValues.MinMax };

scaling1.Append(orientation1);
C.AxisPosition axisPosition1 = new C.AxisPosition() { Val = C.AxisPositionValues.Bottom };
C.TickLabelPosition tickLabelPosition1 = new C.TickLabelPosition() { Val = C.TickLabelPositionValues.NextTo };
C.CrossingAxis crossingAxis1 = new C.CrossingAxis() { Val = (UInt32Value)74775936U };
C.Crosses crosses1 = new C.Crosses() { Val = C.CrossesValues.AutoZero };
C.AutoLabeled autoLabeled1 = new C.AutoLabeled() { Val = true };
C.LabelAlignment labelAlignment1 = new C.LabelAlignment() { Val = C.LabelAlignmentValues.Center };
C.LabelOffset labelOffset1 = new C.LabelOffset() { Val = (UInt16Value)100U };

categoryAxis1.Append(axisId4);
categoryAxis1.Append(scaling1);
categoryAxis1.Append(axisPosition1);
categoryAxis1.Append(tickLabelPosition1);
categoryAxis1.Append(crossingAxis1);
categoryAxis1.Append(crosses1);
categoryAxis1.Append(autoLabeled1);
categoryAxis1.Append(labelAlignment1);
categoryAxis1.Append(labelOffset1);

C.ValueAxis valueAxis1 = new C.ValueAxis();
C.AxisId axisId5 = new C.AxisId() { Val = (UInt32Value)74775936U };

C.Scaling scaling2 = new C.Scaling();
C.Orientation orientation2 = new C.Orientation() { Val = C.OrientationValues.MinMax };

scaling2.Append(orientation2);
C.AxisPosition axisPosition2 = new C.AxisPosition() { Val = C.AxisPositionValues.Left };
C.MajorGridlines majorGridlines1 = new C.MajorGridlines();
C.NumberingFormat numberingFormat1 = new C.NumberingFormat() { FormatCode = "General", SourceLinked = true };
C.TickLabelPosition tickLabelPosition2 = new C.TickLabelPosition() { Val = C.TickLabelPositionValues.NextTo };
C.CrossingAxis crossingAxis2 = new C.CrossingAxis() { Val = (UInt32Value)74774400U };
C.Crosses crosses2 = new C.Crosses() { Val = C.CrossesValues.AutoZero };
C.CrossBetween crossBetween1 = new C.CrossBetween() { Val = C.CrossBetweenValues.Between };

valueAxis1.Append(axisId5);
valueAxis1.Append(scaling2);
valueAxis1.Append(axisPosition2);
valueAxis1.Append(majorGridlines1);
valueAxis1.Append(numberingFormat1);
valueAxis1.Append(tickLabelPosition2);
valueAxis1.Append(crossingAxis2);
valueAxis1.Append(crosses2);
valueAxis1.Append(crossBetween1);

plotArea1.Append(layout2);
plotArea1.Append(bar3DChart1);
plotArea1.Append(categoryAxis1);
plotArea1.Append(valueAxis1);

C.Legend legend1 = new C.Legend();
C.LegendPosition legendPosition1 = new C.LegendPosition() { Val = C.LegendPositionValues.Right };
C.Layout layout3 = new C.Layout();

legend1.Append(legendPosition1);
legend1.Append(layout3);
C.PlotVisibleOnly plotVisibleOnly1 = new C.PlotVisibleOnly() { Val = true };

chart1.Append(title1);
chart1.Append(view3D1);
chart1.Append(plotArea1);
chart1.Append(legend1);
chart1.Append(plotVisibleOnly1);

C.PrintSettings printSettings1 = new C.PrintSettings();
C.HeaderFooter headerFooter1 = new C.HeaderFooter();
C.PageMargins pageMargins2 = new C.PageMargins() { Left = 0.70000000000000018D, Right = 0.70000000000000018D, Top = 0.75000000000000022D, Bottom = 0.75000000000000022D, Header = 0.3000000000000001D, Footer = 0.3000000000000001D };
C.PageSetup pageSetup2 = new C.PageSetup();

printSettings1.Append(headerFooter1);
printSettings1.Append(pageMargins2);
printSettings1.Append(pageSetup2);

chartSpace1.Append(editingLanguage1);
chartSpace1.Append(chart1);
chartSpace1.Append(printSettings1);

chartPart1.ChartSpace = chartSpace1;
}

// Generates content of spreadsheetPrinterSettingsPart1.
private void GenerateSpreadsheetPrinterSettingsPart1Content(SpreadsheetPrinterSettingsPart spreadsheetPrinterSettingsPart1)
{
System.IO.Stream data = GetBinaryDataStream(spreadsheetPrinterSettingsPart1Data);
spreadsheetPrinterSettingsPart1.FeedData(data);
data.Close();
}

// Generates content of worksheetPart2.
private void GenerateWorksheetPart2Content(WorksheetPart worksheetPart2)
{
Worksheet worksheet2 = new Worksheet();
SheetDimension sheetDimension2 = new SheetDimension() { Reference = "A1:V2" };

SheetViews sheetViews2 = new SheetViews();

SheetView sheetView2 = new SheetView() { TopLeftCell = "K1", WorkbookViewId = (UInt32Value)0U };
Selection selection2 = new Selection() { ActiveCell = "A3", SequenceOfReferences = new ListValue() { InnerText = "A3" } };

sheetView2.Append(selection2);

sheetViews2.Append(sheetView2);
SheetFormatProperties sheetFormatProperties2 = new SheetFormatProperties() { DefaultRowHeight = 15D };

Columns columns1 = new Columns();
Column column1 = new Column() { Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 18D, CustomWidth = true };
Column column2 = new Column() { Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 9D, CustomWidth = true };
Column column3 = new Column() { Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 35.42578125D, BestFit = true, CustomWidth = true };
Column column4 = new Column() { Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = 37.140625D, BestFit = true, CustomWidth = true };
Column column5 = new Column() { Min = (UInt32Value)5U, Max = (UInt32Value)5U, Width = 38D, BestFit = true, CustomWidth = true };
Column column6 = new Column() { Min = (UInt32Value)6U, Max = (UInt32Value)6U, Width = 24.85546875D, BestFit = true, CustomWidth = true };
Column column7 = new Column() { Min = (UInt32Value)7U, Max = (UInt32Value)9U, Width = 11D, CustomWidth = true };
Column column8 = new Column() { Min = (UInt32Value)10U, Max = (UInt32Value)12U, Width = 12D, CustomWidth = true };
Column column9 = new Column() { Min = (UInt32Value)13U, Max = (UInt32Value)13U, Width = 13D, CustomWidth = true };
Column column10 = new Column() { Min = (UInt32Value)14U, Max = (UInt32Value)14U, Width = 12D, CustomWidth = true };
Column column11 = new Column() { Min = (UInt32Value)15U, Max = (UInt32Value)15U, Width = 14.28515625D, CustomWidth = true };
Column column12 = new Column() { Min = (UInt32Value)16U, Max = (UInt32Value)17U, Width = 12D, CustomWidth = true };
Column column13 = new Column() { Min = (UInt32Value)18U, Max = (UInt32Value)18U, Width = 14.42578125D, BestFit = true, CustomWidth = true };
Column column14 = new Column() { Min = (UInt32Value)19U, Max = (UInt32Value)19U, Width = 17D, BestFit = true, CustomWidth = true };
Column column15 = new Column() { Min = (UInt32Value)20U, Max = (UInt32Value)20U, Width = 12D, CustomWidth = true };
Column column16 = new Column() { Min = (UInt32Value)21U, Max = (UInt32Value)21U, Width = 12.5703125D, BestFit = true, CustomWidth = true };
Column column17 = new Column() { Min = (UInt32Value)22U, Max = (UInt32Value)22U, Width = 12D, CustomWidth = true };

columns1.Append(column1);
columns1.Append(column2);
columns1.Append(column3);
columns1.Append(column4);
columns1.Append(column5);
columns1.Append(column6);
columns1.Append(column7);
columns1.Append(column8);
columns1.Append(column9);
columns1.Append(column10);
columns1.Append(column11);
columns1.Append(column12);
columns1.Append(column13);
columns1.Append(column14);
columns1.Append(column15);
columns1.Append(column16);
columns1.Append(column17);

SheetData sheetData2 = new SheetData();

Row row4 = new Row() { RowIndex = (UInt32Value)1U, Spans = new ListValue() { InnerText = "1:22" } };

Cell cell7 = new Cell() { CellReference = "A1", DataType = CellValues.SharedString };
CellValue cellValue7 = new CellValue();
cellValue7.Text = "10";

cell7.Append(cellValue7);

Cell cell8 = new Cell() { CellReference = "B1", DataType = CellValues.SharedString };
CellValue cellValue8 = new CellValue();
cellValue8.Text = "12";

cell8.Append(cellValue8);

Cell cell9 = new Cell() { CellReference = "C1", DataType = CellValues.SharedString };
CellValue cellValue9 = new CellValue();
cellValue9.Text = "13";

cell9.Append(cellValue9);

Cell cell10 = new Cell() { CellReference = "D1", DataType = CellValues.SharedString };
CellValue cellValue10 = new CellValue();
cellValue10.Text = "14";

cell10.Append(cellValue10);

Cell cell11 = new Cell() { CellReference = "E1", DataType = CellValues.SharedString };
CellValue cellValue11 = new CellValue();
cellValue11.Text = "15";

cell11.Append(cellValue11);

Cell cell12 = new Cell() { CellReference = "F1", DataType = CellValues.SharedString };
CellValue cellValue12 = new CellValue();
cellValue12.Text = "11";

cell12.Append(cellValue12);

Cell cell13 = new Cell() { CellReference = "G1", DataType = CellValues.SharedString };
CellValue cellValue13 = new CellValue();
cellValue13.Text = "16";

cell13.Append(cellValue13);

Cell cell14 = new Cell() { CellReference = "H1", DataType = CellValues.SharedString };
CellValue cellValue14 = new CellValue();
cellValue14.Text = "17";

cell14.Append(cellValue14);

Cell cell15 = new Cell() { CellReference = "I1", DataType = CellValues.SharedString };
CellValue cellValue15 = new CellValue();
cellValue15.Text = "18";

cell15.Append(cellValue15);

Cell cell16 = new Cell() { CellReference = "J1", DataType = CellValues.SharedString };
CellValue cellValue16 = new CellValue();
cellValue16.Text = "19";

cell16.Append(cellValue16);

Cell cell17 = new Cell() { CellReference = "K1", DataType = CellValues.SharedString };
CellValue cellValue17 = new CellValue();
cellValue17.Text = "20";

cell17.Append(cellValue17);

Cell cell18 = new Cell() { CellReference = "L1", DataType = CellValues.SharedString };
CellValue cellValue18 = new CellValue();
cellValue18.Text = "21";

cell18.Append(cellValue18);

Cell cell19 = new Cell() { CellReference = "M1", DataType = CellValues.SharedString };
CellValue cellValue19 = new CellValue();
cellValue19.Text = "22";

cell19.Append(cellValue19);

Cell cell20 = new Cell() { CellReference = "N1", DataType = CellValues.SharedString };
CellValue cellValue20 = new CellValue();
cellValue20.Text = "23";

cell20.Append(cellValue20);

Cell cell21 = new Cell() { CellReference = "O1", DataType = CellValues.SharedString };
CellValue cellValue21 = new CellValue();
cellValue21.Text = "24";

cell21.Append(cellValue21);

Cell cell22 = new Cell() { CellReference = "P1", DataType = CellValues.SharedString };
CellValue cellValue22 = new CellValue();
cellValue22.Text = "25";

cell22.Append(cellValue22);

Cell cell23 = new Cell() { CellReference = "Q1", DataType = CellValues.SharedString };
CellValue cellValue23 = new CellValue();
cellValue23.Text = "26";

cell23.Append(cellValue23);

Cell cell24 = new Cell() { CellReference = "R1", DataType = CellValues.SharedString };
CellValue cellValue24 = new CellValue();
cellValue24.Text = "27";

cell24.Append(cellValue24);

Cell cell25 = new Cell() { CellReference = "S1", DataType = CellValues.SharedString };
CellValue cellValue25 = new CellValue();
cellValue25.Text = "28";

cell25.Append(cellValue25);

Cell cell26 = new Cell() { CellReference = "T1", DataType = CellValues.SharedString };
CellValue cellValue26 = new CellValue();
cellValue26.Text = "29";

cell26.Append(cellValue26);

Cell cell27 = new Cell() { CellReference = "U1", DataType = CellValues.SharedString };
CellValue cellValue27 = new CellValue();
cellValue27.Text = "30";

cell27.Append(cellValue27);

Cell cell28 = new Cell() { CellReference = "V1", DataType = CellValues.SharedString };
CellValue cellValue28 = new CellValue();
cellValue28.Text = "31";

cell28.Append(cellValue28);

row4.Append(cell7);
row4.Append(cell8);
row4.Append(cell9);
row4.Append(cell10);
row4.Append(cell11);
row4.Append(cell12);
row4.Append(cell13);
row4.Append(cell14);
row4.Append(cell15);
row4.Append(cell16);
row4.Append(cell17);
row4.Append(cell18);
row4.Append(cell19);
row4.Append(cell20);
row4.Append(cell21);
row4.Append(cell22);
row4.Append(cell23);
row4.Append(cell24);
row4.Append(cell25);
row4.Append(cell26);
row4.Append(cell27);
row4.Append(cell28);

Row row5 = new Row() { RowIndex = (UInt32Value)2U, Spans = new ListValue() { InnerText = "1:22" } };

Cell cell29 = new Cell() { CellReference = "A2", DataType = CellValues.SharedString };
CellValue cellValue29 = new CellValue();
cellValue29.Text = "32";

cell29.Append(cellValue29);

Cell cell30 = new Cell() { CellReference = "B2", DataType = CellValues.SharedString };
CellValue cellValue30 = new CellValue();
cellValue30.Text = "33";

cell30.Append(cellValue30);

Cell cell31 = new Cell() { CellReference = "C2", DataType = CellValues.SharedString };
CellValue cellValue31 = new CellValue();
cellValue31.Text = "34";

cell31.Append(cellValue31);

Cell cell32 = new Cell() { CellReference = "D2", DataType = CellValues.SharedString };
CellValue cellValue32 = new CellValue();
cellValue32.Text = "35";

cell32.Append(cellValue32);

Cell cell33 = new Cell() { CellReference = "E2", DataType = CellValues.SharedString };
CellValue cellValue33 = new CellValue();
cellValue33.Text = "36";

cell33.Append(cellValue33);

Cell cell34 = new Cell() { CellReference = "F2", DataType = CellValues.SharedString };
CellValue cellValue34 = new CellValue();
cellValue34.Text = "37";

cell34.Append(cellValue34);

Cell cell35 = new Cell() { CellReference = "G2" };
CellValue cellValue35 = new CellValue();
cellValue35.Text = "1";

cell35.Append(cellValue35);

Cell cell36 = new Cell() { CellReference = "H2" };
CellValue cellValue36 = new CellValue();
cellValue36.Text = "3";

cell36.Append(cellValue36);

Cell cell37 = new Cell() { CellReference = "I2" };
CellValue cellValue37 = new CellValue();
cellValue37.Text = "2400";

cell37.Append(cellValue37);

Cell cell38 = new Cell() { CellReference = "J2" };
CellValue cellValue38 = new CellValue();
cellValue38.Text = "7200";

cell38.Append(cellValue38);

Cell cell39 = new Cell() { CellReference = "K2", DataType = CellValues.SharedString };
CellValue cellValue39 = new CellValue();
cellValue39.Text = "38";

cell39.Append(cellValue39);

Cell cell40 = new Cell() { CellReference = "L2", DataType = CellValues.SharedString };
CellValue cellValue40 = new CellValue();
cellValue40.Text = "39";

cell40.Append(cellValue40);

Cell cell41 = new Cell() { CellReference = "M2", DataType = CellValues.SharedString };
CellValue cellValue41 = new CellValue();
cellValue41.Text = "40";

cell41.Append(cellValue41);

Cell cell42 = new Cell() { CellReference = "N2", DataType = CellValues.SharedString };
CellValue cellValue42 = new CellValue();
cellValue42.Text = "41";

cell42.Append(cellValue42);

Cell cell43 = new Cell() { CellReference = "O2" };
CellValue cellValue43 = new CellValue();
cellValue43.Text = "5";

cell43.Append(cellValue43);

Cell cell44 = new Cell() { CellReference = "P2" };
CellValue cellValue44 = new CellValue();
cellValue44.Text = "5";

cell44.Append(cellValue44);

Cell cell45 = new Cell() { CellReference = "Q2" };
CellValue cellValue45 = new CellValue();
cellValue45.Text = "5";

cell45.Append(cellValue45);

Cell cell46 = new Cell() { CellReference = "R2" };
CellValue cellValue46 = new CellValue();
cellValue46.Text = "5";

cell46.Append(cellValue46);

Cell cell47 = new Cell() { CellReference = "S2", DataType = CellValues.SharedString };
CellValue cellValue47 = new CellValue();
cellValue47.Text = "42";

cell47.Append(cellValue47);

Cell cell48 = new Cell() { CellReference = "T2", DataType = CellValues.SharedString };
CellValue cellValue48 = new CellValue();
cellValue48.Text = "43";

cell48.Append(cellValue48);

Cell cell49 = new Cell() { CellReference = "U2", DataType = CellValues.SharedString };
CellValue cellValue49 = new CellValue();
cellValue49.Text = "44";

cell49.Append(cellValue49);

Cell cell50 = new Cell() { CellReference = "V2", DataType = CellValues.SharedString };
CellValue cellValue50 = new CellValue();
cellValue50.Text = "45";

cell50.Append(cellValue50);

row5.Append(cell29);
row5.Append(cell30);
row5.Append(cell31);
row5.Append(cell32);
row5.Append(cell33);
row5.Append(cell34);
row5.Append(cell35);
row5.Append(cell36);
row5.Append(cell37);
row5.Append(cell38);
row5.Append(cell39);
row5.Append(cell40);
row5.Append(cell41);
row5.Append(cell42);
row5.Append(cell43);
row5.Append(cell44);
row5.Append(cell45);
row5.Append(cell46);
row5.Append(cell47);
row5.Append(cell48);
row5.Append(cell49);
row5.Append(cell50);

sheetData2.Append(row4);
sheetData2.Append(row5);

ConditionalFormatting conditionalFormatting1 = new ConditionalFormatting() { SequenceOfReferences = new ListValue() { InnerText = "R1:R1048576" } };

ConditionalFormattingRule conditionalFormattingRule1 = new ConditionalFormattingRule() { Type = ConditionalFormatValues.IconSet, Priority = 2 };

IconSet iconSet1 = new IconSet() { ShowValue = false, Reverse = true };
ConditionalFormatValueObject conditionalFormatValueObject1 = new ConditionalFormatValueObject() { Type = ConditionalFormatValueObjectValues.Percent, Val = "0" };
ConditionalFormatValueObject conditionalFormatValueObject2 = new ConditionalFormatValueObject() { Type = ConditionalFormatValueObjectValues.Number, Val = "4" };
ConditionalFormatValueObject conditionalFormatValueObject3 = new ConditionalFormatValueObject() { Type = ConditionalFormatValueObjectValues.Number, Val = "5" };

iconSet1.Append(conditionalFormatValueObject1);
iconSet1.Append(conditionalFormatValueObject2);
iconSet1.Append(conditionalFormatValueObject3);

conditionalFormattingRule1.Append(iconSet1);

conditionalFormatting1.Append(conditionalFormattingRule1);

ConditionalFormatting conditionalFormatting2 = new ConditionalFormatting() { SequenceOfReferences = new ListValue() { InnerText = "O1:Q1048576" } };

ConditionalFormattingRule conditionalFormattingRule2 = new ConditionalFormattingRule() { Type = ConditionalFormatValues.IconSet, Priority = 1 };

IconSet iconSet2 = new IconSet() { ShowValue = false, Reverse = true };
ConditionalFormatValueObject conditionalFormatValueObject4 = new ConditionalFormatValueObject() { Type = ConditionalFormatValueObjectValues.Percent, Val = "0" };
ConditionalFormatValueObject conditionalFormatValueObject5 = new ConditionalFormatValueObject() { Type = ConditionalFormatValueObjectValues.Number, Val = "4" };
ConditionalFormatValueObject conditionalFormatValueObject6 = new ConditionalFormatValueObject() { Type = ConditionalFormatValueObjectValues.Number, Val = "5" };

iconSet2.Append(conditionalFormatValueObject4);
iconSet2.Append(conditionalFormatValueObject5);
iconSet2.Append(conditionalFormatValueObject6);

conditionalFormattingRule2.Append(iconSet2);

conditionalFormatting2.Append(conditionalFormattingRule2);
PageMargins pageMargins3 = new PageMargins() { Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
PageSetup pageSetup3 = new PageSetup() { Orientation = OrientationValues.Portrait, Id = "rId1" };

TableParts tableParts1 = new TableParts() { Count = (UInt32Value)1U };
TablePart tablePart1 = new TablePart() { Id = "rId2" };

tableParts1.Append(tablePart1);

worksheet2.Append(sheetDimension2);
worksheet2.Append(sheetViews2);
worksheet2.Append(sheetFormatProperties2);
worksheet2.Append(columns1);
worksheet2.Append(sheetData2);
worksheet2.Append(conditionalFormatting1);
worksheet2.Append(conditionalFormatting2);
worksheet2.Append(pageMargins3);
worksheet2.Append(pageSetup3);
worksheet2.Append(tableParts1);

worksheetPart2.Worksheet = worksheet2;
}

// Generates content of tableDefinitionPart1.
private void GenerateTableDefinitionPart1Content(TableDefinitionPart tableDefinitionPart1)
{
Table table1 = new Table() { Id = (UInt32Value)3U, Name = "Table3", DisplayName = "Table3", Reference = "A1:V51", TotalsRowShown = false };
AutoFilter autoFilter1 = new AutoFilter() { Reference = "A1:V51" };

TableColumns tableColumns1 = new TableColumns() { Count = (UInt32Value)22U };
TableColumn tableColumn1 = new TableColumn() { Id = (UInt32Value)1U, Name = "Asset Name" };
TableColumn tableColumn2 = new TableColumn() { Id = (UInt32Value)2U, Name = "Area" };
TableColumn tableColumn3 = new TableColumn() { Id = (UInt32Value)3U, Name = "Description" };
TableColumn tableColumn4 = new TableColumn() { Id = (UInt32Value)4U, Name = "Reponsible" };
TableColumn tableColumn5 = new TableColumn() { Id = (UInt32Value)5U, Name = "Security Responsible" };
TableColumn tableColumn6 = new TableColumn() { Id = (UInt32Value)6U, Name = "Category" };
TableColumn tableColumn7 = new TableColumn() { Id = (UInt32Value)7U, Name = "Risk Count" };
TableColumn tableColumn8 = new TableColumn() { Id = (UInt32Value)8U, Name = "Quantity" };
TableColumn tableColumn9 = new TableColumn() { Id = (UInt32Value)9U, Name = "Cost" };
TableColumn tableColumn10 = new TableColumn() { Id = (UInt32Value)10U, Name = "Total Cost" };
TableColumn tableColumn11 = new TableColumn() { Id = (UInt32Value)11U, Name = "Location" };
TableColumn tableColumn12 = new TableColumn() { Id = (UInt32Value)12U, Name = "Asset Code" };
TableColumn tableColumn13 = new TableColumn() { Id = (UInt32Value)13U, Name = "Classification" };
TableColumn tableColumn14 = new TableColumn() { Id = (UInt32Value)14U, Name = "Owner" };
TableColumn tableColumn15 = new TableColumn() { Id = (UInt32Value)15U, Name = "Confidentiality" };
TableColumn tableColumn16 = new TableColumn() { Id = (UInt32Value)16U, Name = "Integrity" };
TableColumn tableColumn17 = new TableColumn() { Id = (UInt32Value)17U, Name = "Availability" };
TableColumn tableColumn18 = new TableColumn() { Id = (UInt32Value)18U, Name = "Rating Average" };
TableColumn tableColumn19 = new TableColumn() { Id = (UInt32Value)19U, Name = "Asset Report Date" };
TableColumn tableColumn20 = new TableColumn() { Id = (UInt32Value)20U, Name = "Status" };
TableColumn tableColumn21 = new TableColumn() { Id = (UInt32Value)21U, Name = "Created Date" };
TableColumn tableColumn22 = new TableColumn() { Id = (UInt32Value)22U, Name = "Created By" };

tableColumns1.Append(tableColumn1);
tableColumns1.Append(tableColumn2);
tableColumns1.Append(tableColumn3);
tableColumns1.Append(tableColumn4);
tableColumns1.Append(tableColumn5);
tableColumns1.Append(tableColumn6);
tableColumns1.Append(tableColumn7);
tableColumns1.Append(tableColumn8);
tableColumns1.Append(tableColumn9);
tableColumns1.Append(tableColumn10);
tableColumns1.Append(tableColumn11);
tableColumns1.Append(tableColumn12);
tableColumns1.Append(tableColumn13);
tableColumns1.Append(tableColumn14);
tableColumns1.Append(tableColumn15);
tableColumns1.Append(tableColumn16);
tableColumns1.Append(tableColumn17);
tableColumns1.Append(tableColumn18);
tableColumns1.Append(tableColumn19);
tableColumns1.Append(tableColumn20);
tableColumns1.Append(tableColumn21);
tableColumns1.Append(tableColumn22);
TableStyleInfo tableStyleInfo1 = new TableStyleInfo() { Name = "TableStyleMedium13", ShowFirstColumn = false, ShowLastColumn = false, ShowRowStripes = true, ShowColumnStripes = false };

table1.Append(autoFilter1);
table1.Append(tableColumns1);
table1.Append(tableStyleInfo1);

tableDefinitionPart1.Table = table1;
}

// Generates content of spreadsheetPrinterSettingsPart2.
private void GenerateSpreadsheetPrinterSettingsPart2Content(SpreadsheetPrinterSettingsPart spreadsheetPrinterSettingsPart2)
{
System.IO.Stream data = GetBinaryDataStream(spreadsheetPrinterSettingsPart2Data);
spreadsheetPrinterSettingsPart2.FeedData(data);
data.Close();
}

// Generates content of worksheetPart3.
private void GenerateWorksheetPart3Content(WorksheetPart worksheetPart3)
{
Worksheet worksheet3 = new Worksheet();
SheetDimension sheetDimension3 = new SheetDimension() { Reference = "A1:D10" };

SheetViews sheetViews3 = new SheetViews();

SheetView sheetView3 = new SheetView() { WorkbookViewId = (UInt32Value)0U };
Selection selection3 = new Selection() { ActiveCell = "B21", SequenceOfReferences = new ListValue() { InnerText = "B21" } };

sheetView3.Append(selection3);

sheetViews3.Append(sheetView3);
SheetFormatProperties sheetFormatProperties3 = new SheetFormatProperties() { DefaultRowHeight = 15D };

Columns columns2 = new Columns();
Column column18 = new Column() { Min = (UInt32Value)1U, Max = (UInt32Value)1U, Width = 28.28515625D, CustomWidth = true };
Column column19 = new Column() { Min = (UInt32Value)2U, Max = (UInt32Value)2U, Width = 42.140625D, CustomWidth = true };
Column column20 = new Column() { Min = (UInt32Value)3U, Max = (UInt32Value)3U, Width = 25.7109375D, CustomWidth = true };
Column column21 = new Column() { Min = (UInt32Value)4U, Max = (UInt32Value)4U, Width = 13.5703125D, BestFit = true, CustomWidth = true };

columns2.Append(column18);
columns2.Append(column19);
columns2.Append(column20);
columns2.Append(column21);

SheetData sheetData3 = new SheetData();

Row row6 = new Row() { RowIndex = (UInt32Value)1U, Spans = new ListValue() { InnerText = "1:4" } };

Cell cell51 = new Cell() { CellReference = "A1", StyleIndex = (UInt32Value)8U, DataType = CellValues.SharedString };
CellValue cellValue51 = new CellValue();
cellValue51.Text = "0";

cell51.Append(cellValue51);
Cell cell52 = new Cell() { CellReference = "B1", StyleIndex = (UInt32Value)9U };
Cell cell53 = new Cell() { CellReference = "C1", StyleIndex = (UInt32Value)9U };
Cell cell54 = new Cell() { CellReference = "D1", StyleIndex = (UInt32Value)9U };

row6.Append(cell51);
row6.Append(cell52);
row6.Append(cell53);
row6.Append(cell54);

Row row7 = new Row() { RowIndex = (UInt32Value)2U, Spans = new ListValue() { InnerText = "1:4" } };
Cell cell55 = new Cell() { CellReference = "A2", StyleIndex = (UInt32Value)10U };
Cell cell56 = new Cell() { CellReference = "B2", StyleIndex = (UInt32Value)10U };
Cell cell57 = new Cell() { CellReference = "C2", StyleIndex = (UInt32Value)10U };
Cell cell58 = new Cell() { CellReference = "D2", StyleIndex = (UInt32Value)10U };

row7.Append(cell55);
row7.Append(cell56);
row7.Append(cell57);
row7.Append(cell58);

Row row8 = new Row() { RowIndex = (UInt32Value)3U, Spans = new ListValue() { InnerText = "1:4" } };

Cell cell59 = new Cell() { CellReference = "A3", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
CellValue cellValue52 = new CellValue();
cellValue52.Text = "1";

cell59.Append(cellValue52);
Cell cell60 = new Cell() { CellReference = "B3", StyleIndex = (UInt32Value)2U };
Cell cell61 = new Cell() { CellReference = "C3", StyleIndex = (UInt32Value)3U };
Cell cell62 = new Cell() { CellReference = "D3", StyleIndex = (UInt32Value)4U };

row8.Append(cell59);
row8.Append(cell60);
row8.Append(cell61);
row8.Append(cell62);

Row row9 = new Row() { RowIndex = (UInt32Value)4U, Spans = new ListValue() { InnerText = "1:4" } };

Cell cell63 = new Cell() { CellReference = "A4", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
CellValue cellValue53 = new CellValue();
cellValue53.Text = "2";

cell63.Append(cellValue53);
Cell cell64 = new Cell() { CellReference = "B4", StyleIndex = (UInt32Value)2U };
Cell cell65 = new Cell() { CellReference = "C4", StyleIndex = (UInt32Value)3U };
Cell cell66 = new Cell() { CellReference = "D4", StyleIndex = (UInt32Value)4U };

row9.Append(cell63);
row9.Append(cell64);
row9.Append(cell65);
row9.Append(cell66);

Row row10 = new Row() { RowIndex = (UInt32Value)5U, Spans = new ListValue() { InnerText = "1:4" } };

Cell cell67 = new Cell() { CellReference = "A5", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
CellValue cellValue54 = new CellValue();
cellValue54.Text = "3";

cell67.Append(cellValue54);
Cell cell68 = new Cell() { CellReference = "B5", StyleIndex = (UInt32Value)2U };
Cell cell69 = new Cell() { CellReference = "C5", StyleIndex = (UInt32Value)3U };
Cell cell70 = new Cell() { CellReference = "D5", StyleIndex = (UInt32Value)4U };

row10.Append(cell67);
row10.Append(cell68);
row10.Append(cell69);
row10.Append(cell70);

Row row11 = new Row() { RowIndex = (UInt32Value)6U, Spans = new ListValue() { InnerText = "1:4" } };

Cell cell71 = new Cell() { CellReference = "A6", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
CellValue cellValue55 = new CellValue();
cellValue55.Text = "4";

cell71.Append(cellValue55);
Cell cell72 = new Cell() { CellReference = "B6", StyleIndex = (UInt32Value)2U };
Cell cell73 = new Cell() { CellReference = "C6", StyleIndex = (UInt32Value)3U };
Cell cell74 = new Cell() { CellReference = "D6", StyleIndex = (UInt32Value)4U };

row11.Append(cell71);
row11.Append(cell72);
row11.Append(cell73);
row11.Append(cell74);

Row row12 = new Row() { RowIndex = (UInt32Value)7U, Spans = new ListValue() { InnerText = "1:4" } };

Cell cell75 = new Cell() { CellReference = "A7", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
CellValue cellValue56 = new CellValue();
cellValue56.Text = "5";

cell75.Append(cellValue56);
Cell cell76 = new Cell() { CellReference = "B7", StyleIndex = (UInt32Value)2U };
Cell cell77 = new Cell() { CellReference = "C7", StyleIndex = (UInt32Value)3U };
Cell cell78 = new Cell() { CellReference = "D7", StyleIndex = (UInt32Value)4U };

row12.Append(cell75);
row12.Append(cell76);
row12.Append(cell77);
row12.Append(cell78);

Row row13 = new Row() { RowIndex = (UInt32Value)8U, Spans = new ListValue() { InnerText = "1:4" } };

Cell cell79 = new Cell() { CellReference = "A8", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
CellValue cellValue57 = new CellValue();
cellValue57.Text = "6";

cell79.Append(cellValue57);
Cell cell80 = new Cell() { CellReference = "B8", StyleIndex = (UInt32Value)2U };
Cell cell81 = new Cell() { CellReference = "C8", StyleIndex = (UInt32Value)3U };
Cell cell82 = new Cell() { CellReference = "D8", StyleIndex = (UInt32Value)4U };

row13.Append(cell79);
row13.Append(cell80);
row13.Append(cell81);
row13.Append(cell82);

Row row14 = new Row() { RowIndex = (UInt32Value)9U, Spans = new ListValue() { InnerText = "1:4" } };

Cell cell83 = new Cell() { CellReference = "A9", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
CellValue cellValue58 = new CellValue();
cellValue58.Text = "7";

cell83.Append(cellValue58);

Cell cell84 = new Cell() { CellReference = "B9", StyleIndex = (UInt32Value)5U, DataType = CellValues.SharedString };
CellValue cellValue59 = new CellValue();
cellValue59.Text = "9";

cell84.Append(cellValue59);
Cell cell85 = new Cell() { CellReference = "C9", StyleIndex = (UInt32Value)6U };
Cell cell86 = new Cell() { CellReference = "D9", StyleIndex = (UInt32Value)7U };

row14.Append(cell83);
row14.Append(cell84);
row14.Append(cell85);
row14.Append(cell86);

Row row15 = new Row() { RowIndex = (UInt32Value)10U, Spans = new ListValue() { InnerText = "1:4" } };

Cell cell87 = new Cell() { CellReference = "A10", StyleIndex = (UInt32Value)1U, DataType = CellValues.SharedString };
CellValue cellValue60 = new CellValue();
cellValue60.Text = "8";

cell87.Append(cellValue60);
Cell cell88 = new Cell() { CellReference = "B10", StyleIndex = (UInt32Value)2U };
Cell cell89 = new Cell() { CellReference = "C10", StyleIndex = (UInt32Value)3U };
Cell cell90 = new Cell() { CellReference = "D10", StyleIndex = (UInt32Value)4U };

row15.Append(cell87);
row15.Append(cell88);
row15.Append(cell89);
row15.Append(cell90);

sheetData3.Append(row6);
sheetData3.Append(row7);
sheetData3.Append(row8);
sheetData3.Append(row9);
sheetData3.Append(row10);
sheetData3.Append(row11);
sheetData3.Append(row12);
sheetData3.Append(row13);
sheetData3.Append(row14);
sheetData3.Append(row15);

MergeCells mergeCells1 = new MergeCells() { Count = (UInt32Value)9U };
MergeCell mergeCell1 = new MergeCell() { Reference = "B7:D7" };
MergeCell mergeCell2 = new MergeCell() { Reference = "B8:D8" };
MergeCell mergeCell3 = new MergeCell() { Reference = "B9:D9" };
MergeCell mergeCell4 = new MergeCell() { Reference = "B10:D10" };
MergeCell mergeCell5 = new MergeCell() { Reference = "A1:D2" };
MergeCell mergeCell6 = new MergeCell() { Reference = "B3:D3" };
MergeCell mergeCell7 = new MergeCell() { Reference = "B4:D4" };
MergeCell mergeCell8 = new MergeCell() { Reference = "B5:D5" };
MergeCell mergeCell9 = new MergeCell() { Reference = "B6:D6" };

mergeCells1.Append(mergeCell1);
mergeCells1.Append(mergeCell2);
mergeCells1.Append(mergeCell3);
mergeCells1.Append(mergeCell4);
mergeCells1.Append(mergeCell5);
mergeCells1.Append(mergeCell6);
mergeCells1.Append(mergeCell7);
mergeCells1.Append(mergeCell8);
mergeCells1.Append(mergeCell9);
PageMargins pageMargins4 = new PageMargins() { Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D };
PageSetup pageSetup4 = new PageSetup() { Orientation = OrientationValues.Portrait, Id = "rId1" };

worksheet3.Append(sheetDimension3);
worksheet3.Append(sheetViews3);
worksheet3.Append(sheetFormatProperties3);
worksheet3.Append(columns2);
worksheet3.Append(sheetData3);
worksheet3.Append(mergeCells1);
worksheet3.Append(pageMargins4);
worksheet3.Append(pageSetup4);

worksheetPart3.Worksheet = worksheet3;
}

// Generates content of spreadsheetPrinterSettingsPart3.
private void GenerateSpreadsheetPrinterSettingsPart3Content(SpreadsheetPrinterSettingsPart spreadsheetPrinterSettingsPart3)
{
System.IO.Stream data = GetBinaryDataStream(spreadsheetPrinterSettingsPart3Data);
spreadsheetPrinterSettingsPart3.FeedData(data);
data.Close();
}

// Generates content of sharedStringTablePart1.
private void GenerateSharedStringTablePart1Content(SharedStringTablePart sharedStringTablePart1)
{
SharedStringTable sharedStringTable1 = new SharedStringTable() { Count = (UInt32Value)49U, UniqueCount = (UInt32Value)49U };

SharedStringItem sharedStringItem1 = new SharedStringItem();
Text text1 = new Text();
text1.Text = "Document Summary";

sharedStringItem1.Append(text1);

SharedStringItem sharedStringItem2 = new SharedStringItem();
Text text2 = new Text();
text2.Text = "Prepared By";

sharedStringItem2.Append(text2);

SharedStringItem sharedStringItem3 = new SharedStringItem();
Text text3 = new Text();
text3.Text = "Division/Section";

sharedStringItem3.Append(text3);

SharedStringItem sharedStringItem4 = new SharedStringItem();
Text text4 = new Text();
text4.Text = "Reviewed by";

sharedStringItem4.Append(text4);

SharedStringItem sharedStringItem5 = new SharedStringItem();
Text text5 = new Text();
text5.Text = "Version";

sharedStringItem5.Append(text5);

SharedStringItem sharedStringItem6 = new SharedStringItem();
Text text6 = new Text();
text6.Text = "Document Number";

sharedStringItem6.Append(text6);

SharedStringItem sharedStringItem7 = new SharedStringItem();
Text text7 = new Text();
text7.Text = "Effective From";

sharedStringItem7.Append(text7);

SharedStringItem sharedStringItem8 = new SharedStringItem();
Text text8 = new Text();
text8.Text = "Document Circulation";

sharedStringItem8.Append(text8);

SharedStringItem sharedStringItem9 = new SharedStringItem();
Text text9 = new Text();
text9.Text = "Approved by";

sharedStringItem9.Append(text9);

SharedStringItem sharedStringItem10 = new SharedStringItem();
Text text10 = new Text();
text10.Text = "CONFIDENTIAL";

sharedStringItem10.Append(text10);

SharedStringItem sharedStringItem11 = new SharedStringItem();
Text text11 = new Text();
text11.Text = "Asset Name";

sharedStringItem11.Append(text11);

SharedStringItem sharedStringItem12 = new SharedStringItem();
Text text12 = new Text();
text12.Text = "Category";

sharedStringItem12.Append(text12);

SharedStringItem sharedStringItem13 = new SharedStringItem();
Text text13 = new Text();
text13.Text = "Area";

sharedStringItem13.Append(text13);

SharedStringItem sharedStringItem14 = new SharedStringItem();
Text text14 = new Text();
text14.Text = "Description";

sharedStringItem14.Append(text14);

SharedStringItem sharedStringItem15 = new SharedStringItem();
Text text15 = new Text();
text15.Text = "Reponsible";

sharedStringItem15.Append(text15);

SharedStringItem sharedStringItem16 = new SharedStringItem();
Text text16 = new Text();
text16.Text = "Security Responsible";

sharedStringItem16.Append(text16);

SharedStringItem sharedStringItem17 = new SharedStringItem();
Text text17 = new Text();
text17.Text = "Risk Count";

sharedStringItem17.Append(text17);

SharedStringItem sharedStringItem18 = new SharedStringItem();
Text text18 = new Text();
text18.Text = "Quantity";

sharedStringItem18.Append(text18);

SharedStringItem sharedStringItem19 = new SharedStringItem();
Text text19 = new Text();
text19.Text = "Cost";

sharedStringItem19.Append(text19);

SharedStringItem sharedStringItem20 = new SharedStringItem();
Text text20 = new Text();
text20.Text = "Total Cost";

sharedStringItem20.Append(text20);

SharedStringItem sharedStringItem21 = new SharedStringItem();
Text text21 = new Text();
text21.Text = "Location";

sharedStringItem21.Append(text21);

SharedStringItem sharedStringItem22 = new SharedStringItem();
Text text22 = new Text();
text22.Text = "Asset Code";

sharedStringItem22.Append(text22);

SharedStringItem sharedStringItem23 = new SharedStringItem();
Text text23 = new Text();
text23.Text = "Classification";

sharedStringItem23.Append(text23);

SharedStringItem sharedStringItem24 = new SharedStringItem();
Text text24 = new Text();
text24.Text = "Owner";

sharedStringItem24.Append(text24);

SharedStringItem sharedStringItem25 = new SharedStringItem();
Text text25 = new Text();
text25.Text = "Confidentiality";

sharedStringItem25.Append(text25);

SharedStringItem sharedStringItem26 = new SharedStringItem();
Text text26 = new Text();
text26.Text = "Integrity";

sharedStringItem26.Append(text26);

SharedStringItem sharedStringItem27 = new SharedStringItem();
Text text27 = new Text();
text27.Text = "Availability";

sharedStringItem27.Append(text27);

SharedStringItem sharedStringItem28 = new SharedStringItem();
Text text28 = new Text();
text28.Text = "Rating Average";

sharedStringItem28.Append(text28);

SharedStringItem sharedStringItem29 = new SharedStringItem();
Text text29 = new Text();
text29.Text = "Asset Report Date";

sharedStringItem29.Append(text29);

SharedStringItem sharedStringItem30 = new SharedStringItem();
Text text30 = new Text();
text30.Text = "Status";

sharedStringItem30.Append(text30);

SharedStringItem sharedStringItem31 = new SharedStringItem();
Text text31 = new Text();
text31.Text = "Created Date";

sharedStringItem31.Append(text31);

SharedStringItem sharedStringItem32 = new SharedStringItem();
Text text32 = new Text();
text32.Text = "Created By";

sharedStringItem32.Append(text32);

SharedStringItem sharedStringItem33 = new SharedStringItem();
Text text33 = new Text();
text33.Text = "Network diagram";

sharedStringItem33.Append(text33);

SharedStringItem sharedStringItem34 = new SharedStringItem();
Text text34 = new Text();
text34.Text = "Delhi";

sharedStringItem34.Append(text34);

SharedStringItem sharedStringItem35 = new SharedStringItem();
Text text35 = new Text();
text35.Text = "Lan, WAN, Wireless network diagrams";

sharedStringItem35.Append(text35);

SharedStringItem sharedStringItem36 = new SharedStringItem();
Text text36 = new Text();
text36.Text = "Sunilee, sunil.yadav@niiconsulting.com";

sharedStringItem36.Append(text36);

SharedStringItem sharedStringItem37 = new SharedStringItem();
Text text37 = new Text();
text37.Text = "wasim, wasim.halani@niiconsulting.com";

sharedStringItem37.Append(text37);

SharedStringItem sharedStringItem38 = new SharedStringItem();
Text text38 = new Text();
text38.Text = "cat";

sharedStringItem38.Append(text38);

SharedStringItem sharedStringItem39 = new SharedStringItem();
Text text39 = new Text();
text39.Text = "Network Services";

sharedStringItem39.Append(text39);

SharedStringItem sharedStringItem40 = new SharedStringItem();
Text text40 = new Text();
text40.Text = "NII Admin";

sharedStringItem40.Append(text40);

SharedStringItem sharedStringItem41 = new SharedStringItem();
Text text41 = new Text();
text41.Text = "WNS Private Sensitive";

sharedStringItem41.Append(text41);

SharedStringItem sharedStringItem42 = new SharedStringItem();
Text text42 = new Text();
text42.Text = "Server and Networks";

sharedStringItem42.Append(text42);

SharedStringItem sharedStringItem43 = new SharedStringItem();
Text text43 = new Text();
text43.Text = "2/2/2010";

sharedStringItem43.Append(text43);

SharedStringItem sharedStringItem44 = new SharedStringItem();
Text text44 = new Text();
text44.Text = "Approved";

sharedStringItem44.Append(text44);

SharedStringItem sharedStringItem45 = new SharedStringItem();
Text text45 = new Text();
text45.Text = "2/2/2009";

sharedStringItem45.Append(text45);

SharedStringItem sharedStringItem46 = new SharedStringItem();
Text text46 = new Text();
text46.Text = "Sunil Yadav";

sharedStringItem46.Append(text46);

SharedStringItem sharedStringItem47 = new SharedStringItem();
Text text47 = new Text();
text47.Text = "HIGH";

sharedStringItem47.Append(text47);

SharedStringItem sharedStringItem48 = new SharedStringItem();
Text text48 = new Text();
text48.Text = "MEDIUM";

sharedStringItem48.Append(text48);

SharedStringItem sharedStringItem49 = new SharedStringItem();
Text text49 = new Text();
text49.Text = "LOW";

sharedStringItem49.Append(text49);

sharedStringTable1.Append(sharedStringItem1);
sharedStringTable1.Append(sharedStringItem2);
sharedStringTable1.Append(sharedStringItem3);
sharedStringTable1.Append(sharedStringItem4);
sharedStringTable1.Append(sharedStringItem5);
sharedStringTable1.Append(sharedStringItem6);
sharedStringTable1.Append(sharedStringItem7);
sharedStringTable1.Append(sharedStringItem8);
sharedStringTable1.Append(sharedStringItem9);
sharedStringTable1.Append(sharedStringItem10);
sharedStringTable1.Append(sharedStringItem11);
sharedStringTable1.Append(sharedStringItem12);
sharedStringTable1.Append(sharedStringItem13);
sharedStringTable1.Append(sharedStringItem14);
sharedStringTable1.Append(sharedStringItem15);
sharedStringTable1.Append(sharedStringItem16);
sharedStringTable1.Append(sharedStringItem17);
sharedStringTable1.Append(sharedStringItem18);
sharedStringTable1.Append(sharedStringItem19);
sharedStringTable1.Append(sharedStringItem20);
sharedStringTable1.Append(sharedStringItem21);
sharedStringTable1.Append(sharedStringItem22);
sharedStringTable1.Append(sharedStringItem23);
sharedStringTable1.Append(sharedStringItem24);
sharedStringTable1.Append(sharedStringItem25);
sharedStringTable1.Append(sharedStringItem26);
sharedStringTable1.Append(sharedStringItem27);
sharedStringTable1.Append(sharedStringItem28);
sharedStringTable1.Append(sharedStringItem29);
sharedStringTable1.Append(sharedStringItem30);
sharedStringTable1.Append(sharedStringItem31);
sharedStringTable1.Append(sharedStringItem32);
sharedStringTable1.Append(sharedStringItem33);
sharedStringTable1.Append(sharedStringItem34);
sharedStringTable1.Append(sharedStringItem35);
sharedStringTable1.Append(sharedStringItem36);
sharedStringTable1.Append(sharedStringItem37);
sharedStringTable1.Append(sharedStringItem38);
sharedStringTable1.Append(sharedStringItem39);
sharedStringTable1.Append(sharedStringItem40);
sharedStringTable1.Append(sharedStringItem41);
sharedStringTable1.Append(sharedStringItem42);
sharedStringTable1.Append(sharedStringItem43);
sharedStringTable1.Append(sharedStringItem44);
sharedStringTable1.Append(sharedStringItem45);
sharedStringTable1.Append(sharedStringItem46);
sharedStringTable1.Append(sharedStringItem47);
sharedStringTable1.Append(sharedStringItem48);
sharedStringTable1.Append(sharedStringItem49);

sharedStringTablePart1.SharedStringTable = sharedStringTable1;
}

// Generates content of workbookStylesPart1.
private void GenerateWorkbookStylesPart1Content(WorkbookStylesPart workbookStylesPart1)
{
Stylesheet stylesheet1 = new Stylesheet();

Fonts fonts1 = new Fonts() { Count = (UInt32Value)4U };

Font font1 = new Font();
FontSize fontSize1 = new FontSize() { Val = 11D };
Color color1 = new Color() { Theme = (UInt32Value)1U };
FontName fontName1 = new FontName() { Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering1 = new FontFamilyNumbering() { Val = 2 };
FontScheme fontScheme1 = new FontScheme() { Val = FontSchemeValues.Minor };

font1.Append(fontSize1);
font1.Append(color1);
font1.Append(fontName1);
font1.Append(fontFamilyNumbering1);
font1.Append(fontScheme1);

Font font2 = new Font();
Bold bold1 = new Bold();
FontSize fontSize2 = new FontSize() { Val = 11D };
Color color2 = new Color() { Theme = (UInt32Value)1U };
FontName fontName2 = new FontName() { Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering2 = new FontFamilyNumbering() { Val = 2 };
FontScheme fontScheme2 = new FontScheme() { Val = FontSchemeValues.Minor };

font2.Append(bold1);
font2.Append(fontSize2);
font2.Append(color2);
font2.Append(fontName2);
font2.Append(fontFamilyNumbering2);
font2.Append(fontScheme2);

Font font3 = new Font();
Bold bold2 = new Bold();
FontSize fontSize3 = new FontSize() { Val = 11D };
Color color3 = new Color() { Rgb = "FFFF0000" };
FontName fontName3 = new FontName() { Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering3 = new FontFamilyNumbering() { Val = 2 };
FontScheme fontScheme3 = new FontScheme() { Val = FontSchemeValues.Minor };

font3.Append(bold2);
font3.Append(fontSize3);
font3.Append(color3);
font3.Append(fontName3);
font3.Append(fontFamilyNumbering3);
font3.Append(fontScheme3);

Font font4 = new Font();
FontSize fontSize4 = new FontSize() { Val = 11D };
Color color4 = new Color() { Theme = (UInt32Value)0U };
FontName fontName4 = new FontName() { Val = "Calibri" };
FontFamilyNumbering fontFamilyNumbering4 = new FontFamilyNumbering() { Val = 2 };
FontScheme fontScheme4 = new FontScheme() { Val = FontSchemeValues.Minor };

font4.Append(fontSize4);
font4.Append(color4);
font4.Append(fontName4);
font4.Append(fontFamilyNumbering4);
font4.Append(fontScheme4);

fonts1.Append(font1);
fonts1.Append(font2);
fonts1.Append(font3);
fonts1.Append(font4);

Fills fills1 = new Fills() { Count = (UInt32Value)2U };

Fill fill1 = new Fill();
PatternFill patternFill1 = new PatternFill() { PatternType = PatternValues.None };

fill1.Append(patternFill1);

Fill fill2 = new Fill();
PatternFill patternFill2 = new PatternFill() { PatternType = PatternValues.Gray125 };

fill2.Append(patternFill2);

fills1.Append(fill1);
fills1.Append(fill2);

Borders borders1 = new Borders() { Count = (UInt32Value)6U };

Border border1 = new Border();
LeftBorder leftBorder1 = new LeftBorder();
RightBorder rightBorder1 = new RightBorder();
TopBorder topBorder1 = new TopBorder();
BottomBorder bottomBorder1 = new BottomBorder();
DiagonalBorder diagonalBorder1 = new DiagonalBorder();

border1.Append(leftBorder1);
border1.Append(rightBorder1);
border1.Append(topBorder1);
border1.Append(bottomBorder1);
border1.Append(diagonalBorder1);

Border border2 = new Border();

LeftBorder leftBorder2 = new LeftBorder() { Style = BorderStyleValues.Thin };
Color color5 = new Color() { Indexed = (UInt32Value)64U };

leftBorder2.Append(color5);

RightBorder rightBorder2 = new RightBorder() { Style = BorderStyleValues.Thin };
Color color6 = new Color() { Indexed = (UInt32Value)64U };

rightBorder2.Append(color6);

TopBorder topBorder2 = new TopBorder() { Style = BorderStyleValues.Thin };
Color color7 = new Color() { Indexed = (UInt32Value)64U };

topBorder2.Append(color7);

BottomBorder bottomBorder2 = new BottomBorder() { Style = BorderStyleValues.Thin };
Color color8 = new Color() { Indexed = (UInt32Value)64U };

bottomBorder2.Append(color8);
DiagonalBorder diagonalBorder2 = new DiagonalBorder();

border2.Append(leftBorder2);
border2.Append(rightBorder2);
border2.Append(topBorder2);
border2.Append(bottomBorder2);
border2.Append(diagonalBorder2);

Border border3 = new Border();

LeftBorder leftBorder3 = new LeftBorder() { Style = BorderStyleValues.Thin };
Color color9 = new Color() { Indexed = (UInt32Value)64U };

leftBorder3.Append(color9);
RightBorder rightBorder3 = new RightBorder();

TopBorder topBorder3 = new TopBorder() { Style = BorderStyleValues.Thin };
Color color10 = new Color() { Indexed = (UInt32Value)64U };

topBorder3.Append(color10);

BottomBorder bottomBorder3 = new BottomBorder() { Style = BorderStyleValues.Thin };
Color color11 = new Color() { Indexed = (UInt32Value)64U };

bottomBorder3.Append(color11);
DiagonalBorder diagonalBorder3 = new DiagonalBorder();

border3.Append(leftBorder3);
border3.Append(rightBorder3);
border3.Append(topBorder3);
border3.Append(bottomBorder3);
border3.Append(diagonalBorder3);

Border border4 = new Border();
LeftBorder leftBorder4 = new LeftBorder();
RightBorder rightBorder4 = new RightBorder();

TopBorder topBorder4 = new TopBorder() { Style = BorderStyleValues.Thin };
Color color12 = new Color() { Indexed = (UInt32Value)64U };

topBorder4.Append(color12);

BottomBorder bottomBorder4 = new BottomBorder() { Style = BorderStyleValues.Thin };
Color color13 = new Color() { Indexed = (UInt32Value)64U };

bottomBorder4.Append(color13);
DiagonalBorder diagonalBorder4 = new DiagonalBorder();

border4.Append(leftBorder4);
border4.Append(rightBorder4);
border4.Append(topBorder4);
border4.Append(bottomBorder4);
border4.Append(diagonalBorder4);

Border border5 = new Border();
LeftBorder leftBorder5 = new LeftBorder();

RightBorder rightBorder5 = new RightBorder() { Style = BorderStyleValues.Thin };
Color color14 = new Color() { Indexed = (UInt32Value)64U };

rightBorder5.Append(color14);

TopBorder topBorder5 = new TopBorder() { Style = BorderStyleValues.Thin };
Color color15 = new Color() { Indexed = (UInt32Value)64U };

topBorder5.Append(color15);

BottomBorder bottomBorder5 = new BottomBorder() { Style = BorderStyleValues.Thin };
Color color16 = new Color() { Indexed = (UInt32Value)64U };

bottomBorder5.Append(color16);
DiagonalBorder diagonalBorder5 = new DiagonalBorder();

border5.Append(leftBorder5);
border5.Append(rightBorder5);
border5.Append(topBorder5);
border5.Append(bottomBorder5);
border5.Append(diagonalBorder5);

Border border6 = new Border();
LeftBorder leftBorder6 = new LeftBorder();
RightBorder rightBorder6 = new RightBorder();
TopBorder topBorder6 = new TopBorder();

BottomBorder bottomBorder6 = new BottomBorder() { Style = BorderStyleValues.Thin };
Color color17 = new Color() { Indexed = (UInt32Value)64U };

bottomBorder6.Append(color17);
DiagonalBorder diagonalBorder6 = new DiagonalBorder();

border6.Append(leftBorder6);
border6.Append(rightBorder6);
border6.Append(topBorder6);
border6.Append(bottomBorder6);
border6.Append(diagonalBorder6);

borders1.Append(border1);
borders1.Append(border2);
borders1.Append(border3);
borders1.Append(border4);
borders1.Append(border5);
borders1.Append(border6);

CellStyleFormats cellStyleFormats1 = new CellStyleFormats() { Count = (UInt32Value)1U };
CellFormat cellFormat1 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U };

cellStyleFormats1.Append(cellFormat1);

CellFormats cellFormats1 = new CellFormats() { Count = (UInt32Value)12U };
CellFormat cellFormat2 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U };
CellFormat cellFormat3 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)1U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyBorder = true };
CellFormat cellFormat4 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyBorder = true, ApplyAlignment = true };
CellFormat cellFormat5 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyBorder = true, ApplyAlignment = true };
CellFormat cellFormat6 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyBorder = true, ApplyAlignment = true };
CellFormat cellFormat7 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)2U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyBorder = true, ApplyAlignment = true };
CellFormat cellFormat8 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)3U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyBorder = true, ApplyAlignment = true };
CellFormat cellFormat9 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)2U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)4U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyBorder = true, ApplyAlignment = true };

CellFormat cellFormat10 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)1U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true, ApplyAlignment = true };
Alignment alignment1 = new Alignment() { Horizontal = HorizontalAlignmentValues.Center, Vertical = VerticalAlignmentValues.Center };

cellFormat10.Append(alignment1);
CellFormat cellFormat11 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyAlignment = true };
CellFormat cellFormat12 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)0U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)5U, FormatId = (UInt32Value)0U, ApplyBorder = true, ApplyAlignment = true };
CellFormat cellFormat13 = new CellFormat() { NumberFormatId = (UInt32Value)0U, FontId = (UInt32Value)3U, FillId = (UInt32Value)0U, BorderId = (UInt32Value)0U, FormatId = (UInt32Value)0U, ApplyFont = true };

cellFormats1.Append(cellFormat2);
cellFormats1.Append(cellFormat3);
cellFormats1.Append(cellFormat4);
cellFormats1.Append(cellFormat5);
cellFormats1.Append(cellFormat6);
cellFormats1.Append(cellFormat7);
cellFormats1.Append(cellFormat8);
cellFormats1.Append(cellFormat9);
cellFormats1.Append(cellFormat10);
cellFormats1.Append(cellFormat11);
cellFormats1.Append(cellFormat12);
cellFormats1.Append(cellFormat13);

CellStyles cellStyles1 = new CellStyles() { Count = (UInt32Value)1U };
CellStyle cellStyle1 = new CellStyle() { Name = "Normal", FormatId = (UInt32Value)0U, BuiltinId = (UInt32Value)0U };

cellStyles1.Append(cellStyle1);
DifferentialFormats differentialFormats1 = new DifferentialFormats() { Count = (UInt32Value)0U };
TableStyles tableStyles1 = new TableStyles() { Count = (UInt32Value)0U, DefaultTableStyle = "TableStyleMedium9", DefaultPivotStyle = "PivotStyleLight16" };

stylesheet1.Append(fonts1);
stylesheet1.Append(fills1);
stylesheet1.Append(borders1);
stylesheet1.Append(cellStyleFormats1);
stylesheet1.Append(cellFormats1);
stylesheet1.Append(cellStyles1);
stylesheet1.Append(differentialFormats1);
stylesheet1.Append(tableStyles1);

workbookStylesPart1.Stylesheet = stylesheet1;
}

// Generates content of themePart1.
private void GenerateThemePart1Content(ThemePart themePart1)
{
A.Theme theme1 = new A.Theme() { Name = "Office Theme" };

A.ThemeElements themeElements1 = new A.ThemeElements();

A.ColorScheme colorScheme1 = new A.ColorScheme() { Name = "Office" };

A.Dark1Color dark1Color1 = new A.Dark1Color();
A.SystemColor systemColor1 = new A.SystemColor() { Val = A.SystemColorValues.WindowText, LastColor = "000000" };

dark1Color1.Append(systemColor1);

A.Light1Color light1Color1 = new A.Light1Color();
A.SystemColor systemColor2 = new A.SystemColor() { Val = A.SystemColorValues.Window, LastColor = "FFFFFF" };

light1Color1.Append(systemColor2);

A.Dark2Color dark2Color1 = new A.Dark2Color();
A.RgbColorModelHex rgbColorModelHex1 = new A.RgbColorModelHex() { Val = "1F497D" };

dark2Color1.Append(rgbColorModelHex1);

A.Light2Color light2Color1 = new A.Light2Color();
A.RgbColorModelHex rgbColorModelHex2 = new A.RgbColorModelHex() { Val = "EEECE1" };

light2Color1.Append(rgbColorModelHex2);

A.Accent1Color accent1Color1 = new A.Accent1Color();
A.RgbColorModelHex rgbColorModelHex3 = new A.RgbColorModelHex() { Val = "4F81BD" };

accent1Color1.Append(rgbColorModelHex3);

A.Accent2Color accent2Color1 = new A.Accent2Color();
A.RgbColorModelHex rgbColorModelHex4 = new A.RgbColorModelHex() { Val = "C0504D" };

accent2Color1.Append(rgbColorModelHex4);

A.Accent3Color accent3Color1 = new A.Accent3Color();
A.RgbColorModelHex rgbColorModelHex5 = new A.RgbColorModelHex() { Val = "9BBB59" };

accent3Color1.Append(rgbColorModelHex5);

A.Accent4Color accent4Color1 = new A.Accent4Color();
A.RgbColorModelHex rgbColorModelHex6 = new A.RgbColorModelHex() { Val = "8064A2" };

accent4Color1.Append(rgbColorModelHex6);

A.Accent5Color accent5Color1 = new A.Accent5Color();
A.RgbColorModelHex rgbColorModelHex7 = new A.RgbColorModelHex() { Val = "4BACC6" };

accent5Color1.Append(rgbColorModelHex7);

A.Accent6Color accent6Color1 = new A.Accent6Color();
A.RgbColorModelHex rgbColorModelHex8 = new A.RgbColorModelHex() { Val = "F79646" };

accent6Color1.Append(rgbColorModelHex8);

A.Hyperlink hyperlink1 = new A.Hyperlink();
A.RgbColorModelHex rgbColorModelHex9 = new A.RgbColorModelHex() { Val = "0000FF" };

hyperlink1.Append(rgbColorModelHex9);

A.FollowedHyperlinkColor followedHyperlinkColor1 = new A.FollowedHyperlinkColor();
A.RgbColorModelHex rgbColorModelHex10 = new A.RgbColorModelHex() { Val = "800080" };

followedHyperlinkColor1.Append(rgbColorModelHex10);

colorScheme1.Append(dark1Color1);
colorScheme1.Append(light1Color1);
colorScheme1.Append(dark2Color1);
colorScheme1.Append(light2Color1);
colorScheme1.Append(accent1Color1);
colorScheme1.Append(accent2Color1);
colorScheme1.Append(accent3Color1);
colorScheme1.Append(accent4Color1);
colorScheme1.Append(accent5Color1);
colorScheme1.Append(accent6Color1);
colorScheme1.Append(hyperlink1);
colorScheme1.Append(followedHyperlinkColor1);

A.FontScheme fontScheme5 = new A.FontScheme() { Name = "Office" };

A.MajorFont majorFont1 = new A.MajorFont();
A.LatinFont latinFont1 = new A.LatinFont() { Typeface = "Cambria" };
A.EastAsianFont eastAsianFont1 = new A.EastAsianFont() { Typeface = "" };
A.ComplexScriptFont complexScriptFont1 = new A.ComplexScriptFont() { Typeface = "" };
A.SupplementalFont supplementalFont1 = new A.SupplementalFont() { Script = "Jpan", Typeface = "ＭＳＰゴシック" };
A.SupplementalFont supplementalFont2 = new A.SupplementalFont() { Script = "Hang", Typeface = "맑은 고딕" };
A.SupplementalFont supplementalFont3 = new A.SupplementalFont() { Script = "Hans", Typeface = "宋体" };
A.SupplementalFont supplementalFont4 = new A.SupplementalFont() { Script = "Hant", Typeface = "新細明體" };
A.SupplementalFont supplementalFont5 = new A.SupplementalFont() { Script = "Arab", Typeface = "Times New Roman" };
A.SupplementalFont supplementalFont6 = new A.SupplementalFont() { Script = "Hebr", Typeface = "Times New Roman" };
A.SupplementalFont supplementalFont7 = new A.SupplementalFont() { Script = "Thai", Typeface = "Tahoma" };
A.SupplementalFont supplementalFont8 = new A.SupplementalFont() { Script = "Ethi", Typeface = "Nyala" };
A.SupplementalFont supplementalFont9 = new A.SupplementalFont() { Script = "Beng", Typeface = "Vrinda" };
A.SupplementalFont supplementalFont10 = new A.SupplementalFont() { Script = "Gujr", Typeface = "Shruti" };
A.SupplementalFont supplementalFont11 = new A.SupplementalFont() { Script = "Khmr", Typeface = "MoolBoran" };
A.SupplementalFont supplementalFont12 = new A.SupplementalFont() { Script = "Knda", Typeface = "Tunga" };
A.SupplementalFont supplementalFont13 = new A.SupplementalFont() { Script = "Guru", Typeface = "Raavi" };
A.SupplementalFont supplementalFont14 = new A.SupplementalFont() { Script = "Cans", Typeface = "Euphemia" };
A.SupplementalFont supplementalFont15 = new A.SupplementalFont() { Script = "Cher", Typeface = "Plantagenet Cherokee" };
A.SupplementalFont supplementalFont16 = new A.SupplementalFont() { Script = "Yiii", Typeface = "Microsoft Yi Baiti" };
A.SupplementalFont supplementalFont17 = new A.SupplementalFont() { Script = "Tibt", Typeface = "Microsoft Himalaya" };
A.SupplementalFont supplementalFont18 = new A.SupplementalFont() { Script = "Thaa", Typeface = "MV Boli" };
A.SupplementalFont supplementalFont19 = new A.SupplementalFont() { Script = "Deva", Typeface = "Mangal" };
A.SupplementalFont supplementalFont20 = new A.SupplementalFont() { Script = "Telu", Typeface = "Gautami" };
A.SupplementalFont supplementalFont21 = new A.SupplementalFont() { Script = "Taml", Typeface = "Latha" };
A.SupplementalFont supplementalFont22 = new A.SupplementalFont() { Script = "Syrc", Typeface = "Estrangelo Edessa" };
A.SupplementalFont supplementalFont23 = new A.SupplementalFont() { Script = "Orya", Typeface = "Kalinga" };
A.SupplementalFont supplementalFont24 = new A.SupplementalFont() { Script = "Mlym", Typeface = "Kartika" };
A.SupplementalFont supplementalFont25 = new A.SupplementalFont() { Script = "Laoo", Typeface = "DokChampa" };
A.SupplementalFont supplementalFont26 = new A.SupplementalFont() { Script = "Sinh", Typeface = "Iskoola Pota" };
A.SupplementalFont supplementalFont27 = new A.SupplementalFont() { Script = "Mong", Typeface = "Mongolian Baiti" };
A.SupplementalFont supplementalFont28 = new A.SupplementalFont() { Script = "Viet", Typeface = "Times New Roman" };
A.SupplementalFont supplementalFont29 = new A.SupplementalFont() { Script = "Uigh", Typeface = "Microsoft Uighur" };

majorFont1.Append(latinFont1);
majorFont1.Append(eastAsianFont1);
majorFont1.Append(complexScriptFont1);
majorFont1.Append(supplementalFont1);
majorFont1.Append(supplementalFont2);
majorFont1.Append(supplementalFont3);
majorFont1.Append(supplementalFont4);
majorFont1.Append(supplementalFont5);
majorFont1.Append(supplementalFont6);
majorFont1.Append(supplementalFont7);
majorFont1.Append(supplementalFont8);
majorFont1.Append(supplementalFont9);
majorFont1.Append(supplementalFont10);
majorFont1.Append(supplementalFont11);
majorFont1.Append(supplementalFont12);
majorFont1.Append(supplementalFont13);
majorFont1.Append(supplementalFont14);
majorFont1.Append(supplementalFont15);
majorFont1.Append(supplementalFont16);
majorFont1.Append(supplementalFont17);
majorFont1.Append(supplementalFont18);
majorFont1.Append(supplementalFont19);
majorFont1.Append(supplementalFont20);
majorFont1.Append(supplementalFont21);
majorFont1.Append(supplementalFont22);
majorFont1.Append(supplementalFont23);
majorFont1.Append(supplementalFont24);
majorFont1.Append(supplementalFont25);
majorFont1.Append(supplementalFont26);
majorFont1.Append(supplementalFont27);
majorFont1.Append(supplementalFont28);
majorFont1.Append(supplementalFont29);

A.MinorFont minorFont1 = new A.MinorFont();
A.LatinFont latinFont2 = new A.LatinFont() { Typeface = "Calibri" };
A.EastAsianFont eastAsianFont2 = new A.EastAsianFont() { Typeface = "" };
A.ComplexScriptFont complexScriptFont2 = new A.ComplexScriptFont() { Typeface = "" };
A.SupplementalFont supplementalFont30 = new A.SupplementalFont() { Script = "Jpan", Typeface = "ＭＳＰゴシック" };
A.SupplementalFont supplementalFont31 = new A.SupplementalFont() { Script = "Hang", Typeface = "맑은 고딕" };
A.SupplementalFont supplementalFont32 = new A.SupplementalFont() { Script = "Hans", Typeface = "宋体" };
A.SupplementalFont supplementalFont33 = new A.SupplementalFont() { Script = "Hant", Typeface = "新細明體" };
A.SupplementalFont supplementalFont34 = new A.SupplementalFont() { Script = "Arab", Typeface = "Arial" };
A.SupplementalFont supplementalFont35 = new A.SupplementalFont() { Script = "Hebr", Typeface = "Arial" };
A.SupplementalFont supplementalFont36 = new A.SupplementalFont() { Script = "Thai", Typeface = "Tahoma" };
A.SupplementalFont supplementalFont37 = new A.SupplementalFont() { Script = "Ethi", Typeface = "Nyala" };
A.SupplementalFont supplementalFont38 = new A.SupplementalFont() { Script = "Beng", Typeface = "Vrinda" };
A.SupplementalFont supplementalFont39 = new A.SupplementalFont() { Script = "Gujr", Typeface = "Shruti" };
A.SupplementalFont supplementalFont40 = new A.SupplementalFont() { Script = "Khmr", Typeface = "DaunPenh" };
A.SupplementalFont supplementalFont41 = new A.SupplementalFont() { Script = "Knda", Typeface = "Tunga" };
A.SupplementalFont supplementalFont42 = new A.SupplementalFont() { Script = "Guru", Typeface = "Raavi" };
A.SupplementalFont supplementalFont43 = new A.SupplementalFont() { Script = "Cans", Typeface = "Euphemia" };
A.SupplementalFont supplementalFont44 = new A.SupplementalFont() { Script = "Cher", Typeface = "Plantagenet Cherokee" };
A.SupplementalFont supplementalFont45 = new A.SupplementalFont() { Script = "Yiii", Typeface = "Microsoft Yi Baiti" };
A.SupplementalFont supplementalFont46 = new A.SupplementalFont() { Script = "Tibt", Typeface = "Microsoft Himalaya" };
A.SupplementalFont supplementalFont47 = new A.SupplementalFont() { Script = "Thaa", Typeface = "MV Boli" };
A.SupplementalFont supplementalFont48 = new A.SupplementalFont() { Script = "Deva", Typeface = "Mangal" };
A.SupplementalFont supplementalFont49 = new A.SupplementalFont() { Script = "Telu", Typeface = "Gautami" };
A.SupplementalFont supplementalFont50 = new A.SupplementalFont() { Script = "Taml", Typeface = "Latha" };
A.SupplementalFont supplementalFont51 = new A.SupplementalFont() { Script = "Syrc", Typeface = "Estrangelo Edessa" };
A.SupplementalFont supplementalFont52 = new A.SupplementalFont() { Script = "Orya", Typeface = "Kalinga" };
A.SupplementalFont supplementalFont53 = new A.SupplementalFont() { Script = "Mlym", Typeface = "Kartika" };
A.SupplementalFont supplementalFont54 = new A.SupplementalFont() { Script = "Laoo", Typeface = "DokChampa" };
A.SupplementalFont supplementalFont55 = new A.SupplementalFont() { Script = "Sinh", Typeface = "Iskoola Pota" };
A.SupplementalFont supplementalFont56 = new A.SupplementalFont() { Script = "Mong", Typeface = "Mongolian Baiti" };
A.SupplementalFont supplementalFont57 = new A.SupplementalFont() { Script = "Viet", Typeface = "Arial" };
A.SupplementalFont supplementalFont58 = new A.SupplementalFont() { Script = "Uigh", Typeface = "Microsoft Uighur" };

minorFont1.Append(latinFont2);
minorFont1.Append(eastAsianFont2);
minorFont1.Append(complexScriptFont2);
minorFont1.Append(supplementalFont30);
minorFont1.Append(supplementalFont31);
minorFont1.Append(supplementalFont32);
minorFont1.Append(supplementalFont33);
minorFont1.Append(supplementalFont34);
minorFont1.Append(supplementalFont35);
minorFont1.Append(supplementalFont36);
minorFont1.Append(supplementalFont37);
minorFont1.Append(supplementalFont38);
minorFont1.Append(supplementalFont39);
minorFont1.Append(supplementalFont40);
minorFont1.Append(supplementalFont41);
minorFont1.Append(supplementalFont42);
minorFont1.Append(supplementalFont43);
minorFont1.Append(supplementalFont44);
minorFont1.Append(supplementalFont45);
minorFont1.Append(supplementalFont46);
minorFont1.Append(supplementalFont47);
minorFont1.Append(supplementalFont48);
minorFont1.Append(supplementalFont49);
minorFont1.Append(supplementalFont50);
minorFont1.Append(supplementalFont51);
minorFont1.Append(supplementalFont52);
minorFont1.Append(supplementalFont53);
minorFont1.Append(supplementalFont54);
minorFont1.Append(supplementalFont55);
minorFont1.Append(supplementalFont56);
minorFont1.Append(supplementalFont57);
minorFont1.Append(supplementalFont58);

fontScheme5.Append(majorFont1);
fontScheme5.Append(minorFont1);

A.FormatScheme formatScheme1 = new A.FormatScheme() { Name = "Office" };

A.FillStyleList fillStyleList1 = new A.FillStyleList();

A.SolidFill solidFill1 = new A.SolidFill();
A.SchemeColor schemeColor1 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };

solidFill1.Append(schemeColor1);

A.GradientFill gradientFill1 = new A.GradientFill() { RotateWithShape = true };

A.GradientStopList gradientStopList1 = new A.GradientStopList();

A.GradientStop gradientStop1 = new A.GradientStop() { Position = 0 };

A.SchemeColor schemeColor2 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Tint tint1 = new A.Tint() { Val = 50000 };
A.SaturationModulation saturationModulation1 = new A.SaturationModulation() { Val = 300000 };

schemeColor2.Append(tint1);
schemeColor2.Append(saturationModulation1);

gradientStop1.Append(schemeColor2);

A.GradientStop gradientStop2 = new A.GradientStop() { Position = 35000 };

A.SchemeColor schemeColor3 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Tint tint2 = new A.Tint() { Val = 37000 };
A.SaturationModulation saturationModulation2 = new A.SaturationModulation() { Val = 300000 };

schemeColor3.Append(tint2);
schemeColor3.Append(saturationModulation2);

gradientStop2.Append(schemeColor3);

A.GradientStop gradientStop3 = new A.GradientStop() { Position = 100000 };

A.SchemeColor schemeColor4 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Tint tint3 = new A.Tint() { Val = 15000 };
A.SaturationModulation saturationModulation3 = new A.SaturationModulation() { Val = 350000 };

schemeColor4.Append(tint3);
schemeColor4.Append(saturationModulation3);

gradientStop3.Append(schemeColor4);

gradientStopList1.Append(gradientStop1);
gradientStopList1.Append(gradientStop2);
gradientStopList1.Append(gradientStop3);
A.LinearGradientFill linearGradientFill1 = new A.LinearGradientFill() { Angle = 16200000, Scaled = true };

gradientFill1.Append(gradientStopList1);
gradientFill1.Append(linearGradientFill1);

A.GradientFill gradientFill2 = new A.GradientFill() { RotateWithShape = true };

A.GradientStopList gradientStopList2 = new A.GradientStopList();

A.GradientStop gradientStop4 = new A.GradientStop() { Position = 0 };

A.SchemeColor schemeColor5 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Shade shade1 = new A.Shade() { Val = 51000 };
A.SaturationModulation saturationModulation4 = new A.SaturationModulation() { Val = 130000 };

schemeColor5.Append(shade1);
schemeColor5.Append(saturationModulation4);

gradientStop4.Append(schemeColor5);

A.GradientStop gradientStop5 = new A.GradientStop() { Position = 80000 };

A.SchemeColor schemeColor6 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Shade shade2 = new A.Shade() { Val = 93000 };
A.SaturationModulation saturationModulation5 = new A.SaturationModulation() { Val = 130000 };

schemeColor6.Append(shade2);
schemeColor6.Append(saturationModulation5);

gradientStop5.Append(schemeColor6);

A.GradientStop gradientStop6 = new A.GradientStop() { Position = 100000 };

A.SchemeColor schemeColor7 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Shade shade3 = new A.Shade() { Val = 94000 };
A.SaturationModulation saturationModulation6 = new A.SaturationModulation() { Val = 135000 };

schemeColor7.Append(shade3);
schemeColor7.Append(saturationModulation6);

gradientStop6.Append(schemeColor7);

gradientStopList2.Append(gradientStop4);
gradientStopList2.Append(gradientStop5);
gradientStopList2.Append(gradientStop6);
A.LinearGradientFill linearGradientFill2 = new A.LinearGradientFill() { Angle = 16200000, Scaled = false };

gradientFill2.Append(gradientStopList2);
gradientFill2.Append(linearGradientFill2);

fillStyleList1.Append(solidFill1);
fillStyleList1.Append(gradientFill1);
fillStyleList1.Append(gradientFill2);

A.LineStyleList lineStyleList1 = new A.LineStyleList();

A.Outline outline1 = new A.Outline() { Width = 9525, CapType = A.LineCapValues.Flat, CompoundLineType = A.CompoundLineValues.Single, Alignment = A.PenAlignmentValues.Center };

A.SolidFill solidFill2 = new A.SolidFill();

A.SchemeColor schemeColor8 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Shade shade4 = new A.Shade() { Val = 95000 };
A.SaturationModulation saturationModulation7 = new A.SaturationModulation() { Val = 105000 };

schemeColor8.Append(shade4);
schemeColor8.Append(saturationModulation7);

solidFill2.Append(schemeColor8);
A.PresetDash presetDash1 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };

outline1.Append(solidFill2);
outline1.Append(presetDash1);

A.Outline outline2 = new A.Outline() { Width = 25400, CapType = A.LineCapValues.Flat, CompoundLineType = A.CompoundLineValues.Single, Alignment = A.PenAlignmentValues.Center };

A.SolidFill solidFill3 = new A.SolidFill();
A.SchemeColor schemeColor9 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };

solidFill3.Append(schemeColor9);
A.PresetDash presetDash2 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };

outline2.Append(solidFill3);
outline2.Append(presetDash2);

A.Outline outline3 = new A.Outline() { Width = 38100, CapType = A.LineCapValues.Flat, CompoundLineType = A.CompoundLineValues.Single, Alignment = A.PenAlignmentValues.Center };

A.SolidFill solidFill4 = new A.SolidFill();
A.SchemeColor schemeColor10 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };

solidFill4.Append(schemeColor10);
A.PresetDash presetDash3 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };

outline3.Append(solidFill4);
outline3.Append(presetDash3);

lineStyleList1.Append(outline1);
lineStyleList1.Append(outline2);
lineStyleList1.Append(outline3);

A.EffectStyleList effectStyleList1 = new A.EffectStyleList();

A.EffectStyle effectStyle1 = new A.EffectStyle();

A.EffectList effectList1 = new A.EffectList();

A.OuterShadow outerShadow1 = new A.OuterShadow() { BlurRadius = 40000L, Distance = 20000L, Direction = 5400000, RotateWithShape = false };

A.RgbColorModelHex rgbColorModelHex11 = new A.RgbColorModelHex() { Val = "000000" };
A.Alpha alpha1 = new A.Alpha() { Val = 38000 };

rgbColorModelHex11.Append(alpha1);

outerShadow1.Append(rgbColorModelHex11);

effectList1.Append(outerShadow1);

effectStyle1.Append(effectList1);

A.EffectStyle effectStyle2 = new A.EffectStyle();

A.EffectList effectList2 = new A.EffectList();

A.OuterShadow outerShadow2 = new A.OuterShadow() { BlurRadius = 40000L, Distance = 23000L, Direction = 5400000, RotateWithShape = false };

A.RgbColorModelHex rgbColorModelHex12 = new A.RgbColorModelHex() { Val = "000000" };
A.Alpha alpha2 = new A.Alpha() { Val = 35000 };

rgbColorModelHex12.Append(alpha2);

outerShadow2.Append(rgbColorModelHex12);

effectList2.Append(outerShadow2);

effectStyle2.Append(effectList2);

A.EffectStyle effectStyle3 = new A.EffectStyle();

A.EffectList effectList3 = new A.EffectList();

A.OuterShadow outerShadow3 = new A.OuterShadow() { BlurRadius = 40000L, Distance = 23000L, Direction = 5400000, RotateWithShape = false };

A.RgbColorModelHex rgbColorModelHex13 = new A.RgbColorModelHex() { Val = "000000" };
A.Alpha alpha3 = new A.Alpha() { Val = 35000 };

rgbColorModelHex13.Append(alpha3);

outerShadow3.Append(rgbColorModelHex13);

effectList3.Append(outerShadow3);

A.Scene3DType scene3DType1 = new A.Scene3DType();

A.Camera camera1 = new A.Camera() { Preset = A.PresetCameraValues.OrthographicFront };
A.Rotation rotation1 = new A.Rotation() { Latitude = 0, Longitude = 0, Revolution = 0 };

camera1.Append(rotation1);

A.LightRig lightRig1 = new A.LightRig() { Rig = A.LightRigValues.ThreePoints, Direction = A.LightRigDirectionValues.Top };
A.Rotation rotation2 = new A.Rotation() { Latitude = 0, Longitude = 0, Revolution = 1200000 };

lightRig1.Append(rotation2);

scene3DType1.Append(camera1);
scene3DType1.Append(lightRig1);

A.Shape3DType shape3DType1 = new A.Shape3DType();
A.BevelTop bevelTop1 = new A.BevelTop() { Width = 63500L, Height = 25400L };

shape3DType1.Append(bevelTop1);

effectStyle3.Append(effectList3);
effectStyle3.Append(scene3DType1);
effectStyle3.Append(shape3DType1);

effectStyleList1.Append(effectStyle1);
effectStyleList1.Append(effectStyle2);
effectStyleList1.Append(effectStyle3);

A.BackgroundFillStyleList backgroundFillStyleList1 = new A.BackgroundFillStyleList();

A.SolidFill solidFill5 = new A.SolidFill();
A.SchemeColor schemeColor11 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };

solidFill5.Append(schemeColor11);

A.GradientFill gradientFill3 = new A.GradientFill() { RotateWithShape = true };

A.GradientStopList gradientStopList3 = new A.GradientStopList();

A.GradientStop gradientStop7 = new A.GradientStop() { Position = 0 };

A.SchemeColor schemeColor12 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Tint tint4 = new A.Tint() { Val = 40000 };
A.SaturationModulation saturationModulation8 = new A.SaturationModulation() { Val = 350000 };

schemeColor12.Append(tint4);
schemeColor12.Append(saturationModulation8);

gradientStop7.Append(schemeColor12);

A.GradientStop gradientStop8 = new A.GradientStop() { Position = 40000 };

A.SchemeColor schemeColor13 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Tint tint5 = new A.Tint() { Val = 45000 };
A.Shade shade5 = new A.Shade() { Val = 99000 };
A.SaturationModulation saturationModulation9 = new A.SaturationModulation() { Val = 350000 };

schemeColor13.Append(tint5);
schemeColor13.Append(shade5);
schemeColor13.Append(saturationModulation9);

gradientStop8.Append(schemeColor13);

A.GradientStop gradientStop9 = new A.GradientStop() { Position = 100000 };

A.SchemeColor schemeColor14 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Shade shade6 = new A.Shade() { Val = 20000 };
A.SaturationModulation saturationModulation10 = new A.SaturationModulation() { Val = 255000 };

schemeColor14.Append(shade6);
schemeColor14.Append(saturationModulation10);

gradientStop9.Append(schemeColor14);

gradientStopList3.Append(gradientStop7);
gradientStopList3.Append(gradientStop8);
gradientStopList3.Append(gradientStop9);

A.PathGradientFill pathGradientFill1 = new A.PathGradientFill() { Path = A.PathShadeValues.Circle };
A.FillToRectangle fillToRectangle1 = new A.FillToRectangle() { Left = 50000, Top = -80000, Right = 50000, Bottom = 180000 };

pathGradientFill1.Append(fillToRectangle1);

gradientFill3.Append(gradientStopList3);
gradientFill3.Append(pathGradientFill1);

A.GradientFill gradientFill4 = new A.GradientFill() { RotateWithShape = true };

A.GradientStopList gradientStopList4 = new A.GradientStopList();

A.GradientStop gradientStop10 = new A.GradientStop() { Position = 0 };

A.SchemeColor schemeColor15 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Tint tint6 = new A.Tint() { Val = 80000 };
A.SaturationModulation saturationModulation11 = new A.SaturationModulation() { Val = 300000 };

schemeColor15.Append(tint6);
schemeColor15.Append(saturationModulation11);

gradientStop10.Append(schemeColor15);

A.GradientStop gradientStop11 = new A.GradientStop() { Position = 100000 };

A.SchemeColor schemeColor16 = new A.SchemeColor() { Val = A.SchemeColorValues.PhColor };
A.Shade shade7 = new A.Shade() { Val = 30000 };
A.SaturationModulation saturationModulation12 = new A.SaturationModulation() { Val = 200000 };

schemeColor16.Append(shade7);
schemeColor16.Append(saturationModulation12);

gradientStop11.Append(schemeColor16);

gradientStopList4.Append(gradientStop10);
gradientStopList4.Append(gradientStop11);

A.PathGradientFill pathGradientFill2 = new A.PathGradientFill() { Path = A.PathShadeValues.Circle };
A.FillToRectangle fillToRectangle2 = new A.FillToRectangle() { Left = 50000, Top = 50000, Right = 50000, Bottom = 50000 };

pathGradientFill2.Append(fillToRectangle2);

gradientFill4.Append(gradientStopList4);
gradientFill4.Append(pathGradientFill2);

backgroundFillStyleList1.Append(solidFill5);
backgroundFillStyleList1.Append(gradientFill3);
backgroundFillStyleList1.Append(gradientFill4);

formatScheme1.Append(fillStyleList1);
formatScheme1.Append(lineStyleList1);
formatScheme1.Append(effectStyleList1);
formatScheme1.Append(backgroundFillStyleList1);

themeElements1.Append(colorScheme1);
themeElements1.Append(fontScheme5);
themeElements1.Append(formatScheme1);
A.ObjectDefaults objectDefaults1 = new A.ObjectDefaults();
A.ExtraColorSchemeList extraColorSchemeList1 = new A.ExtraColorSchemeList();

theme1.Append(themeElements1);
theme1.Append(objectDefaults1);
theme1.Append(extraColorSchemeList1);

themePart1.Theme = theme1;
}

private void SetPackageProperties(OpenXmlPackage document)
{
document.PackageProperties.Creator = "";
document.PackageProperties.Created = System.Xml.XmlConvert.ToDateTime("2006-09-16T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind);
document.PackageProperties.Modified = System.Xml.XmlConvert.ToDateTime("2010-03-27T11:38:59Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind);
}

#region Binary Data
private string spreadsheetPrinterSettingsPart1Data = "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAAbcAMQdQ++ABwEAAQDqCm8IZAABAA8AWAICAAEAWAIDAAEATABlAHQAdABlAHIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAABAAAAAgAAABQBAAD/////AAAAAAAAAAAAAAAAAAAAAERJTlUiADgEdAZQF32QVYIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJAAAAAAAAAABAAEAAAAAAAAAAAAAAAAAAAABAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAOAQAAFNNVEoAAAAAEAAoBEgAUAAgAEwAYQBzAGUAcgBKAGUAdAAgADMAMAA1ADAAIABTAGUAcgBpAGUAcwAgAFAAQwBMACAANgAAAElucHV0QmluAEZPUk1TT1VSQ0UAUkVTRExMAFVuaXJlc0RMTABSZXNvbHV0aW9uADYwMGRwaQBGYXN0UmVzAFRydWUAT3JpZW50YXRpb24AUE9SVFJBSVQASFBPcmllbnRSb3RhdGUxODAARmFsc2UAUGFwZXJTaXplAExFVFRFUgBNZWRpYVR5cGUAQVVUTwBFY29ub21vZGUARmFsc2UAVGV4dEFzQmxhY2sARmFsc2UAVFRBc0JpdG1hcHNTZXR0aW5nAFRUTW9kZU91dGxpbmUAUkVUQ2hvaWNlAFRydWUAUHJpbnRRdWFsaXR5R3JvdXAAUFFHcm91cF8zAEhQRG9jUHJvcFJlc291cmNlRGF0YQBocHpobDRheS5jYWIASFBDb2xvck1vZGUATU9OT0NIUk9NRV9NT0RFAEhQUERMVHlwZQBQRExfUENMNgBIUFBKTEVuY29kaW5nAFVURjgASFBKb2JBY2NvdW50aW5nAEhQSk9CQUNDVF9KT0JBQ05UAEhQQm9ybk9uRGF0ZQBIUEJPRABIUEpvYkJ5Sm9iT3ZlcnJpZGUASkJKTwBIUFhNTEZpbGVVc2VkAGhwYzMwNTA2LnhtbABIUFNtYXJ0RHVwbGV4U2luZ2xlUGFnZUpvYgBUcnVlAEhQU21hcnREdXBsZXhPZGRQYWdlSm9iAFRydWUASFBNYW51YWxEdXBsZXhEaWFsb2dJdGVtcwBJbnN0cnVjdGlvbklEXzAxX0ZBQ0VET1dOLU5PUk9UQVRFAEhQTWFudWFsRmVlZE9yaWVudGF0aW9uAEZBQ0VET1dOAEhQT3V0cHV0QmluT3JpZW50YXRpb24ARkFDRURPV04ASFBNYW51YWxEdXBsZXhQYWdlT3JkZXIARXZlblBhZ2VzRmlyc3QASFBNYXBNYW51YWxGZWVkVG9UcmF5MQBUcnVlAEhQUHJpbnRPbkJvdGhTaWRlc01hbnVhbGx5AEZhbHNlAEhQQ292ZXJzAE90aGVyX1BhZ2VzAFBTQWxpZ25tZW50RmlsZQBIUFpMUzRheQBIUFNtYXJ0SHViAEluZXRfU0lEXzI2M19CSURfNTE0X0hJRF8yNjUASFBDb25zdW1lckN1c3RvbVBhcGVyAFRydWUASFBQcmVBbmFseXNpcwBUcnVlAEhQTWFudWFsRHVwbGV4RGlhbG9nTW9kZWwATW9kZWxlc3MASFBMcGlTZWxlY3Rpb24ATm9uZQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUBcAAElVUEgLABEAAAAAAAEAAAACAAAAAQAAAAAAAAAAAAAAAwAAAAAAAAAAAAAAAQABAGQAAQABAAMAAgAAAAEAAAACAAAATABlAHQAdABlAHIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIABbAG4AbwBuAGUAXQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAFsAbgBvAG4AZQBdAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAcgBpAGEAbAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANAAAAFAAAAAAAAAAAQAAAAAAAADAwMAAAAAAAMDAwAAAAAAAAAAAAAAAAAAAAAAAAQAAAAEAAABkAAAAAAAAAAAAgD8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAIBAAADAQAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAFIASQBOAEsATwBPAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8AEEAdQB0AG8AbQBhAHQAaQBjAD4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAEAAAAPAAAAFAEAAAAAAAAPAAAAFAEAAAAAAAACAAAAAAAAAAAAAAAPAAAAFAEAAA8AAAAUAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANAQAADAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGQAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKUAAADxDAAAAAAAAAAAAABqAAAALg8AAAAAAAAAAAAAawAAAP4LAAAAAAAAAAAAAJoAAAAPEgAAAAAAAAAAAABtAAAA+QsAAAAAAAAAAAAAbQAAAPkLAAAAAAAAAAAAAAIAAAD/////RVhDRUwuRVhFAAAAAAAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAAPAAAAFAEAAA8AAAAUAQAADwAAABQBAAAPAAAAFAEAAAAAAAAAAAAAAAAAABMBAAAAAAAAAAAAAACAAAAAAAAAQwA6AFwAUAByAG8AZwByAGEAbQAgAEYAaQBsAGUAcwBcAE0AaQBjAHIAbwBzAG8AZgB0ACAATwBmAGYAaQBjAGUAXABPAGYAZgBpAGMAZQAxADIAXABFAFgAQwBFAEwALgBFAFgARQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==";

private string spreadsheetPrinterSettingsPart2Data = "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAAbcAMQdQ++ABwEAAQDqCm8IZAABAA8AWAICAAEAWAIDAAEATABlAHQAdABlAHIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAABAAAAAgAAABQBAAD/////AAAAAAAAAAAAAAAAAAAAAERJTlUiADgEdAZQF32QVYIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJAAAAAAAAAABAAEAAAAAAAAAAAAAAAAAAAABAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAOAQAAFNNVEoAAAAAEAAoBEgAUAAgAEwAYQBzAGUAcgBKAGUAdAAgADMAMAA1ADAAIABTAGUAcgBpAGUAcwAgAFAAQwBMACAANgAAAElucHV0QmluAEZPUk1TT1VSQ0UAUkVTRExMAFVuaXJlc0RMTABSZXNvbHV0aW9uADYwMGRwaQBGYXN0UmVzAFRydWUAT3JpZW50YXRpb24AUE9SVFJBSVQASFBPcmllbnRSb3RhdGUxODAARmFsc2UAUGFwZXJTaXplAExFVFRFUgBNZWRpYVR5cGUAQVVUTwBFY29ub21vZGUARmFsc2UAVGV4dEFzQmxhY2sARmFsc2UAVFRBc0JpdG1hcHNTZXR0aW5nAFRUTW9kZU91dGxpbmUAUkVUQ2hvaWNlAFRydWUAUHJpbnRRdWFsaXR5R3JvdXAAUFFHcm91cF8zAEhQRG9jUHJvcFJlc291cmNlRGF0YQBocHpobDRheS5jYWIASFBDb2xvck1vZGUATU9OT0NIUk9NRV9NT0RFAEhQUERMVHlwZQBQRExfUENMNgBIUFBKTEVuY29kaW5nAFVURjgASFBKb2JBY2NvdW50aW5nAEhQSk9CQUNDVF9KT0JBQ05UAEhQQm9ybk9uRGF0ZQBIUEJPRABIUEpvYkJ5Sm9iT3ZlcnJpZGUASkJKTwBIUFhNTEZpbGVVc2VkAGhwYzMwNTA2LnhtbABIUFNtYXJ0RHVwbGV4U2luZ2xlUGFnZUpvYgBUcnVlAEhQU21hcnREdXBsZXhPZGRQYWdlSm9iAFRydWUASFBNYW51YWxEdXBsZXhEaWFsb2dJdGVtcwBJbnN0cnVjdGlvbklEXzAxX0ZBQ0VET1dOLU5PUk9UQVRFAEhQTWFudWFsRmVlZE9yaWVudGF0aW9uAEZBQ0VET1dOAEhQT3V0cHV0QmluT3JpZW50YXRpb24ARkFDRURPV04ASFBNYW51YWxEdXBsZXhQYWdlT3JkZXIARXZlblBhZ2VzRmlyc3QASFBNYXBNYW51YWxGZWVkVG9UcmF5MQBUcnVlAEhQUHJpbnRPbkJvdGhTaWRlc01hbnVhbGx5AEZhbHNlAEhQQ292ZXJzAE90aGVyX1BhZ2VzAFBTQWxpZ25tZW50RmlsZQBIUFpMUzRheQBIUFNtYXJ0SHViAEluZXRfU0lEXzI2M19CSURfNTE0X0hJRF8yNjUASFBDb25zdW1lckN1c3RvbVBhcGVyAFRydWUASFBQcmVBbmFseXNpcwBUcnVlAEhQTWFudWFsRHVwbGV4RGlhbG9nTW9kZWwATW9kZWxlc3MASFBMcGlTZWxlY3Rpb24ATm9uZQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUBcAAElVUEgLABEAAAAAAAEAAAACAAAAAQAAAAAAAAAAAAAAAwAAAAAAAAAAAAAAAQABAGQAAQABAAMAAgAAAAEAAAACAAAATABlAHQAdABlAHIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIABbAG4AbwBuAGUAXQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAFsAbgBvAG4AZQBdAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAcgBpAGEAbAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANAAAAFAAAAAAAAAAAQAAAAAAAADAwMAAAAAAAMDAwAAAAAAAAAAAAAAAAAAAAAAAAQAAAAEAAABkAAAAAAAAAAAAgD8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAIBAAADAQAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAFIASQBOAEsATwBPAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8AEEAdQB0AG8AbQBhAHQAaQBjAD4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAEAAAAPAAAAFAEAAAAAAAAPAAAAFAEAAAAAAAACAAAAAAAAAAAAAAAPAAAAFAEAAA8AAAAUAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANAQAADAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGQAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKUAAADxDAAAAAAAAAAAAABqAAAALg8AAAAAAAAAAAAAawAAAP4LAAAAAAAAAAAAAJoAAAAPEgAAAAAAAAAAAABtAAAA+QsAAAAAAAAAAAAAbQAAAPkLAAAAAAAAAAAAAAIAAAD/////RVhDRUwuRVhFAAAAAAAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAAPAAAAFAEAAA8AAAAUAQAADwAAABQBAAAPAAAAFAEAAAAAAAAAAAAAAAAAABMBAAAAAAAAAAAAAACAAAAAAAAAQwA6AFwAUAByAG8AZwByAGEAbQAgAEYAaQBsAGUAcwBcAE0AaQBjAHIAbwBzAG8AZgB0ACAATwBmAGYAaQBjAGUAXABPAGYAZgBpAGMAZQAxADIAXABFAFgAQwBFAEwALgBFAFgARQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==";

private string spreadsheetPrinterSettingsPart3Data = "AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAAbcAMQdQ++ABwEAAQDqCm8IZAABAA8AWAICAAEAWAIDAAEATABlAHQAdABlAHIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAABAAAAAgAAABQBAAD/////AAAAAAAAAAAAAAAAAAAAAERJTlUiADgEdAZQF32QVYIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJAAAAAAAAAABAAEAAAAAAAAAAAAAAAAAAAABAAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAOAQAAFNNVEoAAAAAEAAoBEgAUAAgAEwAYQBzAGUAcgBKAGUAdAAgADMAMAA1ADAAIABTAGUAcgBpAGUAcwAgAFAAQwBMACAANgAAAElucHV0QmluAEZPUk1TT1VSQ0UAUkVTRExMAFVuaXJlc0RMTABSZXNvbHV0aW9uADYwMGRwaQBGYXN0UmVzAFRydWUAT3JpZW50YXRpb24AUE9SVFJBSVQASFBPcmllbnRSb3RhdGUxODAARmFsc2UAUGFwZXJTaXplAExFVFRFUgBNZWRpYVR5cGUAQVVUTwBFY29ub21vZGUARmFsc2UAVGV4dEFzQmxhY2sARmFsc2UAVFRBc0JpdG1hcHNTZXR0aW5nAFRUTW9kZU91dGxpbmUAUkVUQ2hvaWNlAFRydWUAUHJpbnRRdWFsaXR5R3JvdXAAUFFHcm91cF8zAEhQRG9jUHJvcFJlc291cmNlRGF0YQBocHpobDRheS5jYWIASFBDb2xvck1vZGUATU9OT0NIUk9NRV9NT0RFAEhQUERMVHlwZQBQRExfUENMNgBIUFBKTEVuY29kaW5nAFVURjgASFBKb2JBY2NvdW50aW5nAEhQSk9CQUNDVF9KT0JBQ05UAEhQQm9ybk9uRGF0ZQBIUEJPRABIUEpvYkJ5Sm9iT3ZlcnJpZGUASkJKTwBIUFhNTEZpbGVVc2VkAGhwYzMwNTA2LnhtbABIUFNtYXJ0RHVwbGV4U2luZ2xlUGFnZUpvYgBUcnVlAEhQU21hcnREdXBsZXhPZGRQYWdlSm9iAFRydWUASFBNYW51YWxEdXBsZXhEaWFsb2dJdGVtcwBJbnN0cnVjdGlvbklEXzAxX0ZBQ0VET1dOLU5PUk9UQVRFAEhQTWFudWFsRmVlZE9yaWVudGF0aW9uAEZBQ0VET1dOAEhQT3V0cHV0QmluT3JpZW50YXRpb24ARkFDRURPV04ASFBNYW51YWxEdXBsZXhQYWdlT3JkZXIARXZlblBhZ2VzRmlyc3QASFBNYXBNYW51YWxGZWVkVG9UcmF5MQBUcnVlAEhQUHJpbnRPbkJvdGhTaWRlc01hbnVhbGx5AEZhbHNlAEhQQ292ZXJzAE90aGVyX1BhZ2VzAFBTQWxpZ25tZW50RmlsZQBIUFpMUzRheQBIUFNtYXJ0SHViAEluZXRfU0lEXzI2M19CSURfNTE0X0hJRF8yNjUASFBDb25zdW1lckN1c3RvbVBhcGVyAFRydWUASFBQcmVBbmFseXNpcwBUcnVlAEhQTWFudWFsRHVwbGV4RGlhbG9nTW9kZWwATW9kZWxlc3MASFBMcGlTZWxlY3Rpb24ATm9uZQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAUBcAAElVUEgLABEAAAAAAAEAAAACAAAAAQAAAAAAAAAAAAAAAwAAAAAAAAAAAAAAAQABAGQAAQABAAMAAgAAAAEAAAACAAAATABlAHQAdABlAHIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAAAAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIABbAG4AbwBuAGUAXQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAgAFsAbgBvAG4AZQBdAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAcgBpAGEAbAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANAAAAFAAAAAAAAAAAQAAAAAAAADAwMAAAAAAAMDAwAAAAAAAAAAAAAAAAAAAAAAAAQAAAAEAAABkAAAAAAAAAAAAgD8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAAAAAAAAAAAAAIBAAADAQAAAAAAAAAAAAABAAAAAAAAAAAAAAAAAAAAAAAAAFIASQBOAEsATwBPAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA8AEEAdQB0AG8AbQBhAHQAaQBjAD4AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAEAAAAPAAAAFAEAAAAAAAAPAAAAFAEAAAAAAAACAAAAAAAAAAAAAAAPAAAAFAEAAA8AAAAUAQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAANAQAADAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGQAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAKUAAADxDAAAAAAAAAAAAABqAAAALg8AAAAAAAAAAAAAawAAAP4LAAAAAAAAAAAAAJoAAAAPEgAAAAAAAAAAAABtAAAA+QsAAAAAAAAAAAAAbQAAAPkLAAAAAAAAAAAAAAIAAAD/////RVhDRUwuRVhFAAAAAAAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAABAAAAAQAAAAEAAAAPAAAAFAEAAA8AAAAUAQAADwAAABQBAAAPAAAAFAEAAAAAAAAAAAAAAAAAABMBAAAAAAAAAAAAAACAAAAAAAAAQwA6AFwAUAByAG8AZwByAGEAbQAgAEYAaQBsAGUAcwBcAE0AaQBjAHIAbwBzAG8AZgB0ACAATwBmAGYAaQBjAGUAXABPAGYAZgBpAGMAZQAxADIAXABFAFgAQwBFAEwALgBFAFgARQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA==";

private System.IO.Stream GetBinaryDataStream(string base64String)
{
return new System.IO.MemoryStream(System.Convert.FromBase64String(base64String));
}

#endregion

}
}

Rinkur's Blog

Monday, April 19, 2010

Deploying Crystal Report XI Merge Modules

Access denied while connecting to remote system using WMI

Exporting Table in ms excel using open xml sdk

Followers

Blog Archive

About Me