insert row to Excel using C#

[Tim Wallace]

I need to insert a row into an Excel spreadsheet using C#. I get a
reference to the app, the workbook, the sheet. When I attempt to call
Insert, I keep getting errors, probably because I'm not certain what the
args are (and cannot find any documentation to help). I supplied the 2 args
as I thought were correct ( Microsoft.Office.Inerop.Excel.XlDirection.xlUp,
row_num ), but these don't seem correct. Can anyone please help or point me
to a valid Web source?

TIA,

Tim

[django]

Your argument Microsoft.Office.Inerop.Excel.XlDirection.xlUp,
row_num

Inerop -->Interop

[Danny Tuppeny]

"Tim Wallace" <twallace-ThisDoesNotBelong-AT-emailDOTcom> wrote in message
news:Oa*************@TK2MSFTNGP10.phx.gbl...

I need to insert a row into an Excel spreadsheet using C#. I get a
reference to the app, the workbook, the sheet. When I attempt to call
Insert, I keep getting errors, probably because I'm not certain what the
args are (and cannot find any documentation to help). I supplied the 2
args as I thought were correct (
Microsoft.Office.Inerop.Excel.XlDirection.xlUp, row_num ), but these don't
seem correct. Can anyone please help or point me to a valid Web source?

Can't you use ADO.NET with an Excel connection string instead? Then you just
use T-SQL INSERT statements :)

http://www.c-sharpcorner.com/Code/20...essExcelDb.asp

[Tim Wallace]

Thanks. I'll give it a try.

By the way, in my code it reads "Interop"; I just mistyped it in my post.

Tim

"django" <la****@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Your argument Microsoft.Office.Inerop.Excel.XlDirection.xlUp,
row_num

Inerop -->Interop

[Tim Wallace]

I still get the "Cannot shift objects off sheet" error. Any ideas?

Tim

"django" <la****@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Your argument Microsoft.Office.Inerop.Excel.XlDirection.xlUp,
row_num

Inerop -->Interop

[carion1]

Yes, if he defines a range. You can also use adox to change the schema
without instantiating Excel. Office automation is evil.

--

Derek Davis
dd******@gmail.com

"Danny Tuppeny" <gr****@dannytuppeny.commmmmm> wrote in message
news:43***********************@ptn-nntp-reader02.plus.net...

"Tim Wallace" <twallace-ThisDoesNotBelong-AT-emailDOTcom> wrote in message
news:Oa*************@TK2MSFTNGP10.phx.gbl...

I need to insert a row into an Excel spreadsheet using C#. I get a
reference to the app, the workbook, the sheet. When I attempt to call
Insert, I keep getting errors, probably because I'm not certain what the
args are (and cannot find any documentation to help). I supplied the 2
args as I thought were correct (
Microsoft.Office.Inerop.Excel.XlDirection.xlUp , row_num ), but these don't
seem correct. Can anyone please help or point me to a valid Web source?

Can't you use ADO.NET with an Excel connection string instead? Then you
just use T-SQL INSERT statements :)

http://www.c-sharpcorner.com/Code/20...essExcelDb.asp