private static object[] GetRange(string cellStart, string cellEnd, IExcelEngine excelEngine)
{
object[,] oArray = excelEngine.GetRange(cellStart, cellEnd);
return ExcelUtils.GetFirstRankArray(oArray);
}
private static object GetCell(string map, IExcelEngine excelEngine)
{
object returnObject = excelEngine.GetCellValue(map);
if (returnObject == null)
{
return new object();
}
return returnObject;
}
public BendSheetData(string sourceFile, string targetFile, BendSheetDataType fileType)
{
_sourceFileName = sourceFile;
_fileType = fileType;
using (_engine = new ExcelEngine(sourceFile))
{
LoadSourceFile();
_engine.CloseExcelWorkbook();
}
_engine = new ExcelEngine(targetFile);
WriteTargetFile();
Caption();
}
public BendSheetData(string fileName, BendSheetDataType fileType)
{
_sourceFileName = fileName;
_fileType = fileType;
_engine = new ExcelEngine(fileName);
LoadSourceFile();
}
public BendSheetData(string templateFile, string directory)
{
_engine = new ExcelEngine(templateFile);
_directory = directory;
LoadSourceFile();
}
public BendSheetData(IExcelEngine engine, BendSheetDataType fileType)
{
_fileType = fileType;
_engine = engine;
LoadSourceFile();
}
