Soft artisans excel writer cannot cope with large workbook

Question

I am trying to open a workbook and loop through each sheet using office writer - the workbook has over 30 sheets, but the office writer workbook object thinks there are only 6. There something weird in the workbook that is breaking office writer I cant attach the workbook to this post so I am hoping someone from SA will assist [email protected]

Answer 1

Seems like the answer here is don't use soft artisans. I have since switched to Aspose Cells and its a much more robust product.