vb.net - Selecting a Range using TableName & ColumnName in C# -


what want select range using tablename & columnname

the working code in vb.net

dim xlapp interop.excel.application = getobject(workbookname).application xlapp.range(tablename & "[columnname]")._default(i + 1).value = 3 

how can same in c# ??? tried no luck :(

var xlapp = new excel.application(); xlapp.range[tablename + "[columnname]"][i+1].value = 3 

interop.excel.application xlapp =       interaction.getobject(workbookname).application; xlapp.range(tablename + "[columnname]")._default(i + 1).value = 3; 

try this


Comments