如何在angular 9中将xml响应转换为xlsx以下载文件，获取SyntaxError: JSON中位置0处的意外标记P

npm install xlsx file-saver --save

import { Component } from '@angular/core';
import { saveAs } from 'file-saver';
import * as XLSX from 'xlsx';

handleXMLResponse(response: string) {
  const parser = new DOMParser();
  const xmlDoc = parser.parseFromString(response, 'text/xml');

  // 解析XML并构建XLSX数据
  const workbook = XLSX.utils.book_new();
  const worksheet = XLSX.utils.table_to_sheet(xmlDoc.getElementsByTagName('table')[0]);
  XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

  // 将XLSX文件保存为Blob对象
  const excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });
  const blob = new Blob([excelBuffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });

  // 下载XLSX文件
  saveAs(blob, 'data.xlsx');
}

import { HttpClient } from '@angular/common/http';

// ...

constructor(private http: HttpClient) {}

downloadXML() {
  this.http.get('your-xml-api-url', { responseType: 'text' }).subscribe(
    (response) => {
      this.handleXMLResponse(response);
    },
    (error) => {
      console.error(error);
    }
  );
}

<button (click)="downloadXML()">下载XLSX文件</button>