Forum Discussion
Too many different cell formats error
- We are trying to generate excel contains above 65490 cell formats using Javascript code.
- Our requirement is to have cell color, borders and their respective values.
- But when we try to open it we are facing, 'We found some issue in content, would you like to repair it?' error message.
- If we click 'yes', the whole excel styles were removed and then opened.
- And also if we increase the cell formats and cell count further, we are experiencing 'Too many different cells formats error' and couldn't open excel also.
- We found that it is due to excel limitation of 'Unique cell formats/cell styles' of 65,490 counts.
Kindly increase the count or help us to fix this issue asap. TIA.
1 Reply
My knowledge about Java is actually and to put it mildly very limited :),
nevertheless I found this information/link.
Maybe this link will help you a bit further to a solution.You receive a "Too many different cell formats" error message in Excel
...if it doesn't help, just ignore it 🙂
