private static void ExportToSingleSheet([NotNull] WorkbookPart workbookPart, [NotNull] IResourceScope scope)
{
Contract.Requires(workbookPart != null);
Contract.Requires(scope != null);
var languages = scope.Languages.Concat(scope.Comments).Distinct().ToArray();
var entries = scope.Entries.ToArray();
var sheet = new Sheet {
Name = "ResXResourceManager", Id = "Id1", SheetId = 1
};
workbookPart.Workbook = new Workbook().AppendItem(new Sheets(sheet));
var worksheetPart = workbookPart.AddNewPart <WorksheetPart>(sheet.Id);
Contract.Assume(worksheetPart != null);
var worksheet = new Worksheet();
worksheetPart.Worksheet = worksheet;
var headerRow = _singleSheetFixedColumnHeaders.Concat(languages.GetLanguageColumnHeaders(scope));
var dataRows = entries.Select(e => new[] { e.Container.ProjectName, e.Container.UniqueName }.Concat(e.GetDataRow(languages, scope)));
var rows = new[] { headerRow }.Concat(dataRows);
worksheet.AppendItem(rows.Aggregate(new SheetData(), AppendRow));
}
private static Worksheet Protect(this Worksheet worksheet)
{
// ReSharper disable once AssignNullToNotNullAttribute
return(worksheet.AppendItem(new SheetProtection {
Sheet = true, Objects = true, Scenarios = true, FormatColumns = false, FormatRows = false, Sort = false, AutoFilter = false
}));
}
private static Worksheet Protect(this Worksheet worksheet)
{
return(worksheet.AppendItem(new SheetProtection {
Sheet = true, Objects = true, Scenarios = true, FormatColumns = false, FormatRows = false, Sort = false, AutoFilter = false
}));
}
