public void SpreadsheetHelper_Save_MissingPath() { Spreadsheet doc = new Spreadsheet(); doc.CreateAndAppendWorksheet <TestClass>(tcs); doc.Save(""); }
public void SpreadsheetHelper_Save() { Spreadsheet doc = new Spreadsheet(); doc.CreateAndAppendWorksheet <TestClass>(tcs); string filename = string.Format("{0:yyyyMMdd_hhmmss}testfile1.xlsx", DateTime.Now); doc.Save(filename); Assert.IsTrue(File.Exists(filename)); }
public void SpreadsheetHelper_Doc_CreateHeader() { Spreadsheet doc = new Spreadsheet(); doc.CreateAndAppendWorksheet<TestClass>(tcs); PropertyInfo[] props = typeof(TestClass).GetProperties(); int columnIndex = 1; foreach (PropertyInfo prop in typeof(TestClass).GetProperties()) { Assert.AreEqual(prop.Name,doc.doc.GetCellValueAsString(1,columnIndex)); columnIndex++; } }
public void SpreadsheetHelper_Doc_CreateHeader() { Spreadsheet doc = new Spreadsheet(); doc.CreateAndAppendWorksheet <TestClass>(tcs); PropertyInfo[] props = typeof(TestClass).GetProperties(); int columnIndex = 1; foreach (PropertyInfo prop in typeof(TestClass).GetProperties()) { Assert.AreEqual(prop.Name, doc.doc.GetCellValueAsString(1, columnIndex)); columnIndex++; } }
public void SpreadsheetHelper_DisplayWidth() { TestClassWithDisplayWidth tc1 = new TestClassWithDisplayWidth(); Spreadsheet doc = new Spreadsheet(); doc.CreateAndAppendWorksheet<TestClassWithDisplayWidth>(new List<TestClassWithDisplayWidth>() { tc1 }); PropertyInfo[] props = typeof(TestClassWithDisplayWidth).GetProperties(); int columnIndex = 1; foreach (PropertyInfo prop in typeof(TestClassWithDisplayWidth).GetProperties()) { foreach (DisplayWidth dw in prop.GetCustomAttributes(typeof(DisplayWidth))) { Assert.AreEqual(dw.Width, doc.doc.GetColumnWidth(columnIndex)); break; } columnIndex++; } }
public void SpreadsheetHelper_DisplayWidth() { TestClassWithDisplayWidth tc1 = new TestClassWithDisplayWidth(); Spreadsheet doc = new Spreadsheet(); doc.CreateAndAppendWorksheet <TestClassWithDisplayWidth>(new List <TestClassWithDisplayWidth>() { tc1 }); PropertyInfo[] props = typeof(TestClassWithDisplayWidth).GetProperties(); int columnIndex = 1; foreach (PropertyInfo prop in typeof(TestClassWithDisplayWidth).GetProperties()) { foreach (DisplayWidth dw in prop.GetCustomAttributes(typeof(DisplayWidth))) { Assert.AreEqual(dw.Width, doc.doc.GetColumnWidth(columnIndex)); break; } columnIndex++; } }
public void SpreadsheetHelper_SaveStream() { Spreadsheet doc = new Spreadsheet(); doc.CreateAndAppendWorksheet<TestClass>(tcs); string filename = string.Format("{0:yyyyMMdd_hhmmss}testfile2.xlsx", DateTime.Now); FileStream stream = new FileStream(filename, FileMode.CreateNew); doc.Save(stream); Assert.IsTrue(File.Exists(filename)); }
public void SpreadsheetHelper_Save_MissingPath() { Spreadsheet doc = new Spreadsheet(); doc.CreateAndAppendWorksheet<TestClass>(tcs); doc.Save(""); }