public void SetCellValue(string sheetName, int rowIndex, string columnName, string value)
{
dynamic xlsWorkSheet = wkb.Worksheets[sheetName];
xlsWorkSheet.Cells[rowIndex, ExcelConvert.ToIndex(columnName) + 1] = value;
}
public void SetCellValue(int rowIndex, string columnName, string value)
{
app.ActiveSheet.Cells[rowIndex, ExcelConvert.ToIndex(columnName) + 1] = value;
}