private void SheetDataSet(SheetData sheetData1, string reference, Worksheet worksheet1)
{
var sheetDimension1 = new SheetDimension()
{
Reference = reference
};
var sheetViews1 = new SheetViews();
var sheetView1 = new SheetView()
{
TabSelected = true, WorkbookViewId = 0
};
var sheetFormatProperties1 = new SheetFormatProperties {
DefaultRowHeight = 15D, DyDescent = 0.25D
};
var filter = new AutoFilter()
{
Reference = reference
};
var pageMargins1 = new PageMargins()
{
Left = 0.7D, Right = 0.7D, Top = 0.75D, Bottom = 0.75D, Header = 0.3D, Footer = 0.3D
};
sheetViews1.AppendChild(sheetView1);
worksheet1.AppendChild(sheetDimension1);
worksheet1.AppendChild(sheetViews1);
worksheet1.AppendChild(sheetFormatProperties1);
worksheet1.AppendChild(sheetData1);
worksheet1.AppendChild(filter);
worksheet1.AppendChild(pageMargins1);
}
private void AppendSheetViews(WorksheetPart worksheetPart, bool hasKey)
{
SheetViews sheetViews = worksheetPart.Worksheet.AppendChild(new SheetViews());
SheetView sheetView = sheetViews.AppendChild(new SheetView()
{
WorkbookViewId = 0U
});
Pane pane = new Pane()
{
VerticalSplit = 4D,
HorizontalSplit = hasKey ? 2D : 1D,
TopLeftCell = hasKey ? "C5" : "B5",
ActivePane = PaneValues.BottomRight,
State = PaneStateValues.Frozen
};
sheetView.AppendChild(pane);
}
private void AddSheet(SheetContext sheetContext)
{
WorkbookPart workbookPart = sheetContext.DocumentContext.WorkbookPart;
WorksheetPart worksheetPart = sheetContext.WorksheetPart;
uint sheetCount = workbookPart.GetSheetCount();
Worksheet worksheet = new Worksheet()
{
MCAttributes = new MarkupCompatibilityAttributes()
{
Ignorable = "x14ac xr xr2 xr3"
}
};
worksheet.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
worksheet.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
worksheet.AddNamespaceDeclaration("x14ac", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac");
worksheet.AddNamespaceDeclaration("xr", "http://schemas.microsoft.com/office/spreadsheetml/2014/revision");
worksheet.AddNamespaceDeclaration("xr2", "http://schemas.microsoft.com/office/spreadsheetml/2015/revision2");
worksheet.AddNamespaceDeclaration("xr3", "http://schemas.microsoft.com/office/spreadsheetml/2016/revision3");
worksheetPart.Worksheet = worksheet;
SheetViews sheetViews = worksheet.GetOrCreateSheetViews();
SheetView sheetView = new SheetView {
WorkbookViewId = (UInt32Value)0U
};
if (sheetCount == 0)
{
sheetView.TabSelected = true;
}
sheetViews.AppendChild(sheetView);
SheetFormatProperties sheetFormatProperties = new SheetFormatProperties
{
DefaultRowHeight = 15D,
DyDescent = 0.25D,
};
ColumnContext CreateColumnContext(IPropertyRenderer renderer) =>
new ColumnContext(
sheetContext,
renderer.GetMetadata <ExcelColumnMetadata>() ?? _defaultColumnMetadata,
renderer);
sheetContext.Columns = sheetContext
.ReportProvider
.Renderers
.Select(CreateColumnContext)
.ToList();
Columns columns = sheetContext.IsNotTransposed ? CreateColumns(sheetContext.Columns) : CreateColumnsTransposed();
SheetData sheetData = new SheetData();
//workSheet.Append(sheetDimension);
worksheet.Append(sheetViews);
worksheet.Append(sheetFormatProperties);
if (columns != null)
{
worksheet.Append(columns);
}
worksheet.Append(sheetData);
//workSheet.Append(pageMargins);
// Append a new worksheet and associate it with the workbook.
Sheets sheets = workbookPart.Workbook.Sheets;
Sheet sheet = new Sheet
{
Id = workbookPart.GetIdOfPart(worksheetPart),
SheetId = sheetCount + 1,
Name = sheetContext.ReportProvider.ReportName,
};
sheets.Append(sheet);
bool freezeTopRow = ExcelMetadata.GetFirstDefinedValue(
ExcelMetadata.FreezeTopRow,
sheetContext.SheetMetadata,
sheetContext.DocumentMetadata);
if (freezeTopRow)
{
worksheet.FreezeTopRow(rowNum: 1);
}
sheetContext.SheetData = sheetData;
sheetContext.Sheet = sheet;
}
