public void Given_SheetName_ExcelDocument_Should_GetWorkseetPart()
{
//Arrange
var stream = new MemoryStream(); //Avoid having to use actual file on disk
var spreadsheetDocument = SpreadsheetDocument.Create(stream, SpreadsheetDocumentType.Workbook);
// Add a WorkbookPart.
WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();
workbookpart.Workbook = new Workbook();
// Add a WorksheetPart.
WorksheetPart worksheetPart = workbookpart.AddNewPart <WorksheetPart>();
worksheetPart.Worksheet = new Worksheet(new SheetData());
// Add a sheets list.
Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild <Sheets>(new Sheets());
// Append the new worksheet and associate it with the workbook.
string expectedId = workbookpart.GetIdOfPart(worksheetPart);
string sheetName = "mySheet";
Sheet sheet = new Sheet()
{
Id = expectedId,
SheetId = 1,
Name = sheetName
};
sheets.Append(sheet);
var wrapper = new SpreadsheetDocumentWrapper(spreadsheetDocument);
string fakeFilePath = "path";
var sut = new ExcelDocument(fakeFilePath);
//Act
WorksheetPart result = sut.GetWorksheetPart(wrapper, sheetName);
//Assert
Assert.IsNotNull(result);
var actualId = workbookpart.GetIdOfPart(result);
Assert.AreEqual(expectedId, actualId);
}
public SpreadsheetDocumentWrapper(SpreadsheetDocumentWrapper excelDoc)
{
this.excelDock = excelDock;
}
