Home >Topic List >Solution to garbled characters when opening excel
Solution to garbled characters when opening excel
If garbled characters appear when opening a file in Excel, it may be because the file encoding is inconsistent with Excel's default encoding. If you want to know more about excel garbled content, you can read the article below this topic.
How to solve the problem of garbled characters exported to excel by phpThe solution to the garbled code exported by PHP to excel: first open the corresponding PHP code file; then add the ob_end_clean function after processing the data and before outputting the excel file to solve the garbled code problem.
Reasons and solutions for garbled characters exported from java to excelReason for garbled code: httpheader requires that the exported content must be encoded in iso8859-1. Solution: When exporting Excel from Java, convert the content encoding to "iso8859-1" encoding, and use the String(byte[],decode) method to transcode.
Related Resource DownloadsMore>