dongweizhen2009
2019-08-19 09:53
浏览 600
已采纳

将html表格内容导出为xlsx格式

Iam using PHP+jQuery to export the html table contents. When I click on on export button, the excel file is generated successfully as xls format. I want to generate the file as xlsx format.

$FileName="my-file.xls";
header('Content-Type: application/force-download');
header('Content-disposition: attachment; filename='.$FileName.'');
header("Pragma: ");
header("Cache-Control: ");
echo $_REQUEST['tableData'];
exit();

Adding the jQuery

var clone_val = $(".tblExport").clone();
$("#tData").val($('<span><style> .textFormat {  mso-number-format:"\@"; } .numberFormat { mso-number-format:"0\.00" }</style>').append (clone_val).html());
$("#excel-export-form").submit();

The table contents is stored inside a input box having attribute id="tData" name="tableData" using jQuery. When I changed the filename as my-file.xlsx, a corrupted xlsx file is generated. Also tried Data Table excel export, but it didn't support multiple headers.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • douke7274 2019-08-19 10:04
    已采纳

    You can do this with a php library. I prefer PhpSpreadsheet to use for working with excel.

    点赞 打赏 评论

相关推荐 更多相似问题