Some text formatting may have changed in this file because the maximum number of fonts was exceeded解决办法

google资料:

1. http://www.mrexcel.com/forum/showthread.php?t=354225

You are getting the following message

Quote:

Originally Posted by dannypon79 '' some text formatting may have changed in this file because the maximum number of font was exceeded''

because the maximum number of fonts was exceeded.

Excel has a limitation on the number of formats allowed (depending on the version), so if you can clean up the formats and reduced the number of fonts used you should be able to avoid that message.

2.http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_21748309.html

Do you have any other files/documents or applications open (apart from the MS-Excel created object & your Java program)?

Solution:

1. getStyle Once, such as put it as Object or Map.. Then reuse it. Avoid generate many times in program.

(for{ set sheet sytle}..ect.)

2. Restart all excel, and then generate the excel and open to see it. All style is setted, and no msg box.

OK now!