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