Is there an efficient/quick way to clear the contents of a worksheet? I tried iterating through all of the cells, but that takes forever?
I also tried removing the worksheet and adding a new one with the same name. This causes other problems.
Currently there is no way other than to iterate the rows and cells. Make sure if you iterate rows and cells to use a foreach loop rather than a for, because a foreach will only iterate the rows and cells which have previously been accessed at some point.