在angular 7中导入excel并使用node js保存到数据库中

npm install xlsx

import * as XLSX from 'xlsx';
import { HttpClient } from '@angular/common/http';

importExcel(file: File) {
  const reader: FileReader = new FileReader();
  reader.onload = (e: any) => {
    const bstr: string = e.target.result;
    const workbook: XLSX.WorkBook = XLSX.read(bstr, { type: 'binary' });
    const sheetName: string = workbook.SheetNames[0];
    const worksheet: XLSX.WorkSheet = workbook.Sheets[sheetName];
    const jsonData: any[] = XLSX.utils.sheet_to_json(worksheet, { raw: true });
    
    // 将jsonData发送到后端保存到数据库中
    this.http.post('http://your-api-endpoint', jsonData).subscribe(
      response => {
        console.log('Excel数据已保存到数据库');
      },
      error => {
        console.error('保存Excel数据到数据库时出错', error);
      }
    );
  };
  reader.readAsBinaryString(file);
}

<input type="file" (change)="importExcel($event.target.files[0])">
<button (click)="importExcel()">导入Excel</button>

const express = require('express');
const app = express();
const mysql = require('mysql');
const bodyParser = require('body-parser');

app.use(bodyParser.json());

const connection = mysql.createConnection({
  host: 'your-database-host',
  user: 'your-database-username',
  password: 'your-database-password',
  database: 'your-database-name'
});

app.post('/api/save-excel-data', (req, res) => {
  const jsonData = req.body;
  const query = 'INSERT INTO your_table_name (column1, column2, ...) VALUES ?';
  const values = jsonData.map(obj => Object.values(obj));
  
  connection.query(query, [values], (error, results) => {
    if (error) {
      console.error('保存Excel数据到数据库时出错', error);
      res.status(500).json({ error: '保存Excel数据到数据库时出错' });
    } else {
      console.log('Excel数据已保存到数据库');
      res.status(200).json({ message: 'Excel数据已保存到数据库' });
    }
  });
});

app.listen(3000, () => {
  console.log('服务器已启动');
});