Skip to content

Instantly share code, notes, and snippets.

@yuktse

yuktse/ExcelOutput

Created March 6, 2014 08:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yuktse/9385035 to your computer and use it in GitHub Desktop.
Save yuktse/9385035 to your computer and use it in GitHub Desktop.
Download ZIP
EXCEL导出XML格式文件，要注意的地方。
Raw
ExcelOutput
EXCEL导出XML结构：如果用于程序，如果打不开，出错的地方可能在于
1. Row index。删了，并补上空白行<Row />
2. <Table> 中的 ExpandedRowCount， ExpandedColumnCount。删了
3. WorksheetOptions标签里的内容，可能会导致WPS出错
4. 没有使用htmlspecialchars函数转换特别字符，WPS会出错
5. 数字类型的格填入了文字
6. 注意换行符"\r\n"之类要换成"&#10;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment