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("");
}
