How to update Content of Exel sheet [modified]

[Member 4659001]

In One of my page i need to read the data from Exel Sheet , and After reading the content form it I need to delete the content of Exel Sheet (means i need to delete all rows it contain I have done till how to read data from exel , Now i need to blank it so Plz Guide me how to Blank Exel sheet Well for deleting i used a function private void call1() { string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\OrderHeader.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb"); using (DbConnection connection = factory.CreateConnection()) { connection.ConnectionString = connectionString; using (DbCommand command = connection.CreateCommand()) { command.CommandText = "Delete from [OrderHeader$]"; connection.Open(); command.ExecuteNonQuery(); } } } But it is giving error msg Deleting data in a linked table is not supported by this ISAM.

Raghvendra

modified on Wednesday, March 4, 2009 9:29 AM

[Jorgen Andersson]

You can't do that, Excel isn't a relational datasource. You can delete values in fields (cells). But you can't delete an entire record at once.