public void AppendErrorRows(string sheetName, IWorksheetWriter worksheetWriter) { if (worksheetWriter == null) { throw new ArgumentNullException("worksheetWriter"); } if (FileContentStream == null) { throw new InvalidOperationException(string.Format("Cannot {0} prior to initializing from a template.", MethodBase.GetCurrentMethod().Name)); } using (SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.Open(FileContentStream, true)) { //Access the main Workbook part, which contains data WorkbookPart workbookPart = spreadsheetDoc.WorkbookPart; Sheet ss = ExcelUtility.FindSheet(sheetName, workbookPart); if (ss == null) { throw new InvalidOperationException("Cannot find sheet named '" + sheetName + "' in workbook."); } WorksheetPart worksheetPart = (WorksheetPart)workbookPart.GetPartById(ss.Id); if (worksheetPart != null) { worksheetWriter.CreateErrorRows(worksheetPart); worksheetPart.Worksheet.Save(); } } }
public void AppendErrorRows(string sheetName, IWorksheetWriter worksheetWriter) { if (worksheetWriter == null) { throw new ArgumentNullException("worksheetWriter"); } if (FileContentStream == null) { throw new InvalidOperationException(string.Format("Cannot {0} prior to initializing from a template.", MethodBase.GetCurrentMethod().Name)); } using (SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.Open(FileContentStream, true)) { //Access the main Workbook part, which contains data WorkbookPart workbookPart = spreadsheetDoc.WorkbookPart; Sheet ss = ExcelUtility.FindSheet(sheetName, workbookPart); if (ss == null) { throw new InvalidOperationException("Cannot find sheet named '" + sheetName + "' in workbook."); } WorksheetPart worksheetPart = (WorksheetPart)workbookPart.GetPartById(ss.Id); if (worksheetPart != null) { worksheetWriter.CreateErrorRows(worksheetPart); worksheetPart.Worksheet.Save(); } } }