public void CreateWorkbookFromDict()
        {
            var workbook = XLSExporter.CreateWorkbookFromDictionary("MySheet", testData);

            Assert.AreEqual(1, workbook.NumberOfSheets);
            var sheet = workbook.GetSheetAt(0);

            Assert.AreEqual("MySheet", sheet.SheetName);
            Assert.AreEqual("TestKey", sheet.GetRow(0).GetCell(0).StringCellValue);
            Assert.AreEqual("TestValue", sheet.GetRow(0).GetCell(1).StringCellValue);
            Assert.AreEqual("TestKey2", sheet.GetRow(1).GetCell(0).StringCellValue);
            Assert.AreEqual("TestValue2", sheet.GetRow(1).GetCell(1).StringCellValue);
        }
 public void CreateWorkbookFromDictWithNullData_ExpectedException()
 {
     XLSExporter.CreateWorkbookFromDictionary("MySheet", null);
 }
 public void CreateWorkbookFromDictWithNullData_ExpectedException()
 {
     Assert.That(() => XLSExporter.CreateWorkbookFromDictionary("MySheet", null), Throws.ArgumentNullException);
 }
 public void CreateWorkbookFromDictWithNullSheetName_ExpectedException()
 {
     XLSExporter.CreateWorkbookFromDictionary(null, testData);
 }
 public void CreateWorkbookFromDictWithNullSheetName_ExpectedException()
 {
     Assert.That(() => XLSExporter.CreateWorkbookFromDictionary(null, testData), Throws.ArgumentNullException);
 }