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 })); }