public void FillTable_WithHeaders(int rowCount, Type[] colTypes, string[] colNames)
{
BasicFrame frame = BasicFrameGenerator.CreateTable(rowCount, colTypes, colNames);
ExcelFile excelFile = new ExcelFile();
ExcelWorksheet ws = excelFile.Worksheets.Add("test");
excelFile.Worksheets.ActiveWorksheet = ws;
BasicFrameToExcelWriter writer = new BasicFrameToExcelWriter();
writer.ExportHeaders = true;
writer.FillTable(ws, frame);
Assert.Equal(frame.RowCount+1, ws.Rows.Count);
// Assert.Equal(frame.ColumnCount, ws.Columns.Count);
}
public void SetHeaders(int id, string[] colNames)
{
ExcelFile excelFile = new ExcelFile();
ExcelWorksheet ws = excelFile.Worksheets.Add("test");
excelFile.Worksheets.ActiveWorksheet = ws;
BasicFrameToExcelWriter writer = new BasicFrameToExcelWriter();
writer.ExportHeaders = true;
writer.SetHeaders(ws, colNames);
Assert.Equal(1, ws.Rows.Count);
for (int i = 0; i < colNames.Length; i++)
{
Assert.Equal(colNames[i], ws.Cells[0, i].Value);
}
// Assert.Equal(frame.ColumnCount, ws.Columns.Count);
}
public void SetParams(string fileName, int rowCount, Type[] colTypes, bool exportHeaders, bool exportRowKeys)
{
IFrame frame = BasicFrameGenerator.CreateTable(rowCount, colTypes);
Dictionary<string, object> paramDic = new Dictionary<string, object>();
paramDic.Add(BasicFrameToExcelWriter._ParamName_FileName, fileName);
paramDic.Add(BasicFrameToExcelWriter._ParamName_InputFrame, frame);
paramDic.Add(BasicFrameToExcelWriter._ParamName_ExportHeaders, exportHeaders);
BasicFrameToExcelWriter writer = new BasicFrameToExcelWriter();
writer.SetParams(paramDic);
Assert.Equal(fileName, writer.FileName);
Assert.Same(frame, writer.InputFrame);
Assert.Equal(exportHeaders, writer.ExportHeaders);
}
public void WriteToFile_WithHeaders(string fileName, int rowCount, Type[] colTypes, int expectedLineCount, string[] colNames)
{
string inputFile = Path.Combine(_TestDir, fileName);
IFrame frame = BasicFrameGenerator.CreateTable(rowCount, colTypes, colNames);
BasicFrameToExcelWriter writer = new BasicFrameToExcelWriter();
writer.FileName = inputFile;
writer.ExportHeaders = true;
writer.InputFrame = frame;
writer.Write();
var exists = File.Exists(inputFile);
Assert.True(exists);
}
public void SetUp()
{
this.target = new BasicFrameToExcelWriter();
Directory.CreateDirectory(_TestDir);
}
public void SetParam_ForFrame(int rowCount, Type[] colTypes)
{
IFrame frame = BasicFrameGenerator.CreateTable(rowCount, colTypes);
BasicFrameToExcelWriter writer = new BasicFrameToExcelWriter();
writer.SetParam(BasicFrameToExcelWriter._ParamName_InputFrame, frame);
Assert.Same(frame, writer.InputFrame);
}
public void SetParam_ForFileName(string fileName)
{
BasicFrameToExcelWriter writer = new BasicFrameToExcelWriter();
writer.SetParam(BasicFrameToExcelWriter._ParamName_FileName, fileName);
Assert.Equal(fileName, writer.FileName);
}
public void SetParam_ForExportHeaders(bool exportHeaders)
{
BasicFrameToExcelWriter writer = new BasicFrameToExcelWriter();
writer.SetParam(BasicFrameToExcelWriter._ParamName_ExportHeaders, exportHeaders);
Assert.Equal(exportHeaders, writer.ExportHeaders);
}
