Excel File
i am opening an existing excel file in c# when the excel sheet open it shows me existing data in it ,so before opening an existing file i all rows must be empty ,how to do this, but this excel sheet is in compatible mode
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Joginder BangerPosted Nov 28, 2014, 6:56 AM
first of all you need a save in you save on project. like any folder and after then change the security like a editable mode.
run this query
string sqlQ = "Delete [" + sheetname + "$]";
and after then new sheet add with the same name.
Selva GanapathyPosted Nov 28, 2014, 5:45 AM
Hi Umer ali,
Can i know Why you try to open existing one instead of creating new (for this case, because you want an empty excel)?
Regards,
Selva Ganapathy K