public XlsxWriterInternal(Workbook workbook)
{
_workbook = workbook;
_relationshipCounter = new RelationshipCounter();
_sharedStrings = new SharedStrings();
_package = new XlsxPackage();
_styles = GetXlsxStyles();
}
public XlsxWriterInternal(Workbook workbook, CompressionOption compressionOption)
{
_workbook = workbook;
_relationshipCounter = new RelationshipCounter();
_sharedStrings = new SharedStrings();
_package = new XlsxPackage { CompressionOption = compressionOption };
_styles = GetXlsxStyles();
}
public XlsxWriterInternal(Workbook workbook, CompressionOption compressionOption)
{
_workbook = workbook;
_relationshipCounter = new RelationshipCounter();
_sharedStrings = new SharedStrings();
_package = new XlsxPackage {
CompressionOption = compressionOption
};
_styles = GetXlsxStyles();
}
// ReSharper disable once MemberHidesStaticFromOuterClass
internal static void Save(Workbook workbook, Stream outputStream, bool compress)
{
var relationshipCounter = new RelationshipCounter();
var package = new XlsxPackage();
// Must be done before calling GetXlsxStyles as it may add styles
foreach (var sheet in workbook.Sheets)
{
HandleLargeNumbers(sheet);
}
ExtractWorkbookSpecialXmlParts(workbook, out var styles, out var ignoredErrors);
var sharedStrings = new SharedStrings();
// docProps/core.xml
var cp = CreateCoreFileProperties(workbook, relationshipCounter);
package.XmlFiles.Add(cp.Target);
package.Relationships.Add(cp);
// xl/styles.xml
var stylesXml = StyleWriter.CreateStyleXml(styles);
var stylesRel = new Relationship(relationshipCounter)
{
Type = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles",
Target = stylesXml
};
package.XmlFiles.Add(stylesXml);
package.WorkbookRelationships.Add(stylesRel);
// xl/worksheets/sheetX.xml
var sheetPackageInfos = new List <SheetPackageInfo>();
var i = 0;
foreach (var sheet in workbook.Sheets)
{
i++;
var rel = CreateSheetFile(sheet, i, relationshipCounter, styles, ignoredErrors[sheet],
sharedStrings, out var sheetRels);
if (sheetRels != null)
{
package.XmlFiles.Add(sheetRels);
}
package.XmlFiles.Add(rel.Target);
package.WorkbookRelationships.Add(rel);
var sheetPackageInfo = new SheetPackageInfo
{
RelationshipId = rel.Id,
SheetId = i,
SheetName = sheet.Name
};
if (sheet.PageSetup.PrintRepeatColumns > 0)
{
sheetPackageInfo.RepeatCols = "'" + sheet.Name + "'!$A:$" +
CellAddressHelper.ColToReference(sheet.PageSetup.PrintRepeatColumns - 1);
}
if (sheet.PageSetup.PrintRepeatRows > 0)
{
sheetPackageInfo.RepeatRows = "'" + sheet.Name + "'!$1:$" + sheet.PageSetup.PrintRepeatRows;
}
sheetPackageInfos.Add(sheetPackageInfo);
}
// xl/sharedStrings.xml
if (sharedStrings.Count > 0)
{
var ssx = sharedStrings.ToRelationship(relationshipCounter);
package.XmlFiles.Add(ssx.Target);
package.WorkbookRelationships.Add(ssx);
}
// xl/workbook.xml
var wb = CreateWorkbookFile(sheetPackageInfos, relationshipCounter);
package.XmlFiles.Add(wb.Target);
package.Relationships.Add(wb);
// xl/_rels/workbook.xml.rels
package.SaveToStream(outputStream, compress);
}