如何使用jquery或php下载xlsx格式的html表格数据

$.ajax({
  url: 'download.php',
  method: 'POST',
  data: { htmlTableData: $('#yourTable').html() },
  success: function(response) {
    var downloadLink = $('<a></a>')
      .attr('href', response)
      .attr('download', 'table.xlsx')
      .hide();
    $('body').append(downloadLink);
    downloadLink[0].click();
    downloadLink.remove();
  }
});

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$htmlTableData = $_POST['htmlTableData'];

// 创建一个新的Excel对象
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

// 将HTML表格数据转换为XLSX格式
$sheet->fromArray(getTableData($htmlTableData), null, 'A1');

// 保存Excel文件到临时目录
$writer = new Xlsx($spreadsheet);
$filename = tempnam(sys_get_temp_dir(), 'table_') . '.xlsx';
$writer->save($filename);

// 返回Excel文件路径
echo $filename;