0

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 marcus.scholz@riotinto.com

Programnik
  • 1,449
  • 1
  • 9
  • 13
  • What version of office writer are you using. There was a bug fix around the early versions of officewriter 8.3 that fixed a bug with the symptoms you are describing. – Sam Plus Plus Oct 16 '14 at 04:46
  • ExcelWriter can handle workbooks with 100s of worksheets. Behavior like this doesn't have to do with the size of the workbook. It is usually caused by ExcelWriter having trouble parsing something in a worksheet and then not adding that sheet to the Worksheets collection. – Aviva M. Oct 19 '14 at 01:05
  • Thanks Aviva M. Are you from soft artisans? If so, are you interested in testing this workbook? There may be a bug in office writer. I can send it to you if you like. Thanks. – Programnik Oct 20 '14 at 04:28

1 Answers1

0

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.

Programnik
  • 1,449
  • 1
  • 9
  • 13