ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Appending rows in excel from C# (https://www.excelbanter.com/excel-programming/390309-appending-rows-excel-c.html)

KevinB

Appending rows in excel from C#
 
I am opening an existing spreadsheet and appending rows from a SQL Db. The
rows are being appended correctly where I want them to be, ex. starting at
N15. However, the existing content, from A1:M519, is being wiped out. The
data I am adding will always be placed at the end of the existing content.
Any ideas on how to keep the existing stuff from being wiped out?

Thanks in advance.

Regards.
--
Kevin C. Brown
Developer
The Darby Group

Tim

Appending rows in excel from C#
 
How about showing your code?

It's difficult to suppose that Excel is deciding on its own to remove the
existing data, so the obvious suggestion on how to avoid this is to change
your code, but not having seen it it's not possible to be any more
explicit...

Tim


"KevinB" wrote in message
...
I am opening an existing spreadsheet and appending rows from a SQL Db. The
rows are being appended correctly where I want them to be, ex. starting at
N15. However, the existing content, from A1:M519, is being wiped out.
The
data I am adding will always be placed at the end of the existing content.
Any ideas on how to keep the existing stuff from being wiped out?

Thanks in advance.

Regards.
--
Kevin C. Brown
Developer
The Darby Group





All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com