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