Selecting a Range using TableName & ColumnName in C#

Question

What i want to do is to select a Range using TableName & ColumnName

the Working Code in VB.net is

Dim xlApp As Interop.Excel.Application = GetObject(workbookName).Application
xlApp.Range(tableName & "[ColumnName]")._Default(i + 1).Value = 3

How Can i do just the Same in C# ??? i tried something like that but no luck :(

var xlApp = new Excel.Application();
xlApp.Range[tableName + "[ColumnName]"][i+1].Value = 3

Dhinesh · Accepted Answer · 2015-06-03 07:32:43Z

1

Interop.Excel.Application xlApp = 
     Interaction.GetObject(workbookName).Application;
xlApp.Range(tableName + "[ColumnName]")._Default(i + 1).Value = 3;

Try this

answered Jun 3, 2015 at 7:32

Dhinesh

1812 gold badges5 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yehia Amer Over a year ago

i tried your way: Interop.Excel.Application xlApp = Interaction.GetObject(workbookName).Application; .Application is marked red in IntelliSense !

Collectives™ on Stack Overflow

Selecting a Range using TableName & ColumnName in C#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related