public void InsertImage(AkbExcelCellCoordinate cell, Image image) { try { SetSelect(cell.Row, cell.Column); Clipboard.SetImage(image); PasteObject(); } catch (Exception e) { XWriteLogs(MethodBase.GetCurrentMethod().Name, e.Message); } }
/// <summary> /// 2017/08/11 AKB Nguyen Thanh Tung /// </summary> /// <param name="cellStart"></param> /// <param name="objValue"></param> /// <returns></returns> public string SetRangeValue(AkbExcelCellCoordinate cellStart, object[,] objValue) { string strRange = string.Empty; try { if (objValue == null) { return(null); } int countRow = objValue.GetLength(0) - 1; int countCol = objValue.GetLength(1) - 1; string NameColStart = GetExcelColumnName(cellStart.Column); string NameColEnd = GetExcelColumnName(cellStart.Column + countCol); int rowEnd = cellStart.Row + countRow; strRange = NameColStart + cellStart.Row + ":" + NameColEnd + rowEnd; _parameters = new Object[1]; _parameters[0] = strRange; _mobjRange = GetProperty(_mobjWorkSheet, "Range", _parameters); SetProperty(_mobjRange, "Value2", objValue); } catch (Exception e) { strRange = string.Empty; XWriteLogs(MethodBase.GetCurrentMethod().Name, e.Message); } finally { FreeMemory(); } return(strRange); }
public void SetCellString(AkbExcelCellCoordinate coor, object val) { var cellVal = "'" + val; SetValue(coor.Row, coor.Column, cellVal); }
public object GetCellValue(AkbExcelCellCoordinate coor) { return(GetValue(coor.Row, coor.Column)); }
public void SetCellValue(AkbExcelCellCoordinate coor, object val) { SetValue(coor.Row, coor.Column, val); }