public void ThenICanWriteToExcel()
{
ExcelInteropHelper.WriteExcel(1, 9, "test");
//ExcelInteropHelper.SaveExcel();
// 1. Single values
ExcelInteropHelper.WriteExcel("I2", "test1");
//ExcelInteropHelper.CloseExcel();
// 2. Multidimentional Arrays
string[,] rangeValues = new string[3, 3] {
{ "a", "b", "c" },
{ "d", "e", "f" },
{ "g", "h", "i" }
};
ExcelInteropHelper.WriteExcel("I3:K5", rangeValues);
//ExcelInteropHelper.CloseExcel();
// When values are of dynamic range, mention start cell only
ExcelInteropHelper.WriteExcel("I6", rangeValues);
rangeValues = new string[3, 1] {
{ "a" },
{ "d" },
{ "g" }
};
// When values are of dynamic range, mention start cell only
ExcelInteropHelper.WriteExcel("I9", rangeValues);
// 3. One dimensional array (single column)
string[] rangeValues1 = new string[3] {
"a", "b", "c"
};
ExcelInteropHelper.WriteExcel("I12", rangeValues1);
// Always use CloseExcel at end of all oprations
ExcelInteropHelper.CloseExcel();
}