excel open existing .xls and write dotnet

[csgraham74]

Hi guys,

just wondering if anyone could - help me work out how to open an
existing spreadsheet in excel and write to it then save it.

I have some code that opens a new worksheet everytime but i want to
just write info to the smae worksheet.

Thanks
in advance


Colin

 

[Guest]

You can use OleDbCommand to 'Insert' data to worksheet.

HTH

Elton Wang

 

[sloan]

Check
http://msdn.microsoft.com/library/d...tskCodeExampleReadingExcelDataIntoDataset.asp

Thats "reading" data into a DataSet, but with the
OleDbConnection
you should be able to run an INSERT statement.

Think of "Sheet1" as a table name. (the bottom tabs at the bottom of the
excel file)

 

[rpraveen]

Colin,

If you want a way to do this in .Net without any dependancy on MS
Excel, you could use Syncfuison's Essential XlsIO to insert data into
existing Excel files:

http://www.syncfusion.com/Products/product.aspx?p=4&tab_id=0

Regards,
Praveen Ramesh
Syncfusion, Inc.
www.syncfusion.com