Excel File

Question

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

Joginder Banger · Answer

Hi Umer Ali 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 Ganapathy · Answer

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