Excel Generated Through open XML programatically causing issue with styles exceeding limit 65490.

sravanthi 1 Reputation point
2021-07-14T11:59:08.01+00:00

Excel Generated Through open XML programatically causing issue with styles exceeding limit 65490.

Unable to Open the Generated Excel due to the breach of style limit 65490.

excel Contains:170 Pages
Each Page contains 640 cells.( Total will be1,02,400 Cells)

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,838 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Daniel Zhang-MSFT 9,621 Reputation points
    2021-07-15T02:33:35.077+00:00

    Hi sravanthi-2938,
    First, we can know that Maximum limit of Unique cell formats/cell styles is 65490 from this document.
    So you need to reduce the use of cell formatting in the code.
    And I suggest to try method three and method four mentioned in this document.
    Best Regards,
    Daniel Zhang

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments