Created
March 6, 2014 08:41
-
-
Save yuktse/9385035 to your computer and use it in GitHub Desktop.
EXCEL导出XML格式文件，要注意的地方。
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| EXCEL导出XML结构：如果用于程序，如果打不开，出错的地方可能在于 | |
| 1. Row index。删了，并补上空白行<Row /> | |
| 2. <Table> 中的 ExpandedRowCount， ExpandedColumnCount。删了 | |
| 3. WorksheetOptions标签里的内容，可能会导致WPS出错 | |
| 4. 没有使用htmlspecialchars函数转换特别字符，WPS会出错 | |
| 5. 数字类型的格填入了文字 | |
| 6. 注意换行符"\r\n"之类要换成" " |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment