/**
* Create a new CT_Workbook with all values Set to default
*/
private void OnWorkbookCreate()
{
doc = new WorkbookDocument();
workbook = doc.Workbook;
// don't EVER use the 1904 date system
CT_WorkbookPr workbookPr = workbook.AddNewWorkbookPr();
workbookPr.date1904 = (false);
CT_BookViews bvs = workbook.AddNewBookViews();
CT_BookView bv = bvs.AddNewWorkbookView();
bv.activeTab = 0;
workbook.AddNewSheets();
ExtendedProperties expProps = GetProperties().ExtendedProperties;
CT_ExtendedProperties ctExtendedProp= expProps.GetUnderlyingProperties();
ctExtendedProp.Application = DOCUMENT_CREATOR;
ctExtendedProp.DocSecurity = 0;
ctExtendedProp.DocSecuritySpecified = true;
ctExtendedProp.ScaleCrop = false;
ctExtendedProp.ScaleCropSpecified = true;
ctExtendedProp.LinksUpToDate = false;
ctExtendedProp.LinksUpToDateSpecified = true;
ctExtendedProp.HyperlinksChanged = false;
ctExtendedProp.HyperlinksChangedSpecified = true;
ctExtendedProp.SharedDoc = false;
ctExtendedProp.SharedDocSpecified = true;
sharedStringSource = (SharedStringsTable)CreateRelationship(XSSFRelation.SHARED_STRINGS, XSSFFactory.GetInstance());
stylesSource = (StylesTable)CreateRelationship(XSSFRelation.STYLES, XSSFFactory.GetInstance());
namedRanges = new List<XSSFName>();
sheets = new List<XSSFSheet>();
pivotTables = new List<XSSFPivotTable>();
}
public void SerializeWorksheetDocumentTest()
{
CT_Workbook worksheet = new CT_Workbook();
CT_Sheet sheet1 = new CT_Sheet();
sheet1.name = "Sheet1";
sheet1.sheetId = 1u;
sheet1.id = "rId1";
worksheet.sheets.sheet.Add(sheet1);
var bks = worksheet.AddNewBookViews();
var bk = bks.AddNewWorkbookView();
bk.xWindow = 360;
bk.xWindowSpecified = true;
bk.yWindow = 60;
bk.yWindowSpecified = true;
bk.windowWidth = 11295;
bk.windowWidthSpecified = true;
bk.windowHeight = 5580;
bk.windowHeightSpecified = true;
StringWriter stream = new StringWriter();
WorkbookDocument_Accessor.serializer.Serialize(stream, worksheet, WorkbookDocument_Accessor.namespaces);
string expected = @"<?xml version=""1.0"" encoding=""utf-16""?>
<workbook xmlns:r=""http://schemas.openxmlformats.org/officeDocument/2006/relationships"" xmlns=""http://schemas.openxmlformats.org/spreadsheetml/2006/main"">
<bookViews>
<workbookView xWindow=""360"" yWindow=""60"" windowWidth=""11295"" windowHeight=""5580"" />
</bookViews>
<sheets>
<sheet name=""Sheet1"" sheetId=""1"" r:id=""rId1"" />
</sheets>
</workbook>";
Assert.AreEqual(expected, stream.ToString());
}
