public void SetupXlsxSpreadSheetDocument(Action <XlsxSpreadsheetDocument> func)
{
if (func is null)
{
throw new ArgumentNullException(nameof(func));
}
using (var ms = new MemoryStream())
{
using (var spreadsheetDocument = SpreadsheetDocument.Create(ms, SpreadsheetDocumentType.Workbook))
{
var spreadsheet = new XlsxSpreadsheetDocument(spreadsheetDocument);
spreadsheet.InitializeWorkbook();
spreadsheet.Save();
func(spreadsheet);
}
}
}
public void SimpleTest()
{
var ex = Record.Exception(() =>
{
using (var ms = new MemoryStream())
{
using (var spreadsheetDocument = SpreadsheetDocument.Create(ms, SpreadsheetDocumentType.Workbook))
{
var spreadsheet = new XlsxSpreadsheetDocument(spreadsheetDocument);
spreadsheet.InitializeWorkbook();
spreadsheet.Save();
}
Assert.True(ms.Length > 0);
}
});
Assert.Null(ex);
}
public void SheetTests()
{
var ex = Record.Exception(() =>
{
using (var ms = new MemoryStream())
{
using (var spreadsheetDocument = SpreadsheetDocument.Create(ms, SpreadsheetDocumentType.Workbook))
{
var spreadsheet = new XlsxSpreadsheetDocument(spreadsheetDocument);
spreadsheet.InitializeWorkbook();
spreadsheet.Save();
var addSheet = spreadsheet.AddSheet("test");
var getSheet = spreadsheet.GetSheet("test");
Assert.Same(getSheet.SheetName, addSheet.SheetName);
Assert.Equal(getSheet.SheetIndex, addSheet.SheetIndex);
}
}
});
Assert.Null(ex);
}
