c# - How to reduce the range in get_range() parameters because it is not accepting the '-' (minus) operator? -

int nrows = 2; int ncolumns = dt.rows.count; string upperleftcell = "b2"; int endrownumber = system.int32.parse(upperleftcell.substring(1))+ nrows - 1; char endcolumnletter = system.convert.tochar(convert.toint32(upperleftcell[0]) + ncolumns - 1); string upperrightcell = system.string.format("{0}{1}",endcolumnletter, system.int32.parse(upperleftcell.substring(1))); string lowerrightcell = system.string.format("{0}{1}",endcolumnletter, endrownumber);  excel.range rg = ws.get_range(upperleftcell, lowerrightcell); (int = 1; <= dt.rows.count; i++) {    rg[1, i] = dt.rows[i - 1][0].tostring();      //for adding header text    rg[2, i] = int.parse(dt.rows[i - 1][1].tostring());  //for adding datarow value }  excel.range chartrange = ws.get_range(upperleftcell, lowerrightcell); 

this code snippet. need reduce lowerrightcell value 1 in both statements have used parameter!!

you should able when create string lowerrightcell.

string lowerrightcell = system.string.format("{0}{1}",endcolumnletter, endrownumber - 1);