在javascript中删除csv文件中的空单元格(行)

// 读取CSV文件
function readCSVFile(file) {
  return new Promise((resolve, reject) => {
    const reader = new FileReader();
    reader.onload = (event) => {
      resolve(event.target.result);
    };
    reader.onerror = (event) => {
      reject(event.target.error);
    };
    reader.readAsText(file);
  });
}

// 解析CSV数据
function parseCSVData(csvData) {
  const lines = csvData.split('\n');
  const data = lines.map(line => line.split(','));
  return data;
}

// 删除空单元格（行）
function removeEmptyCells(data) {
  return data.filter(row => row.some(cell => cell.trim() !== ''));
}

// 生成CSV数据
function generateCSVData(data) {
  return data.map(row => row.join(',')).join('\n');
}

// 导出CSV文件
function exportCSVFile(csvData, fileName) {
  const blob = new Blob([csvData], { type: 'text/csv;charset=utf-8;' });
  if (navigator.msSaveBlob) {
    navigator.msSaveBlob(blob, fileName);
  } else {
    const link = document.createElement('a');
    if (link.download !== undefined) {
      const url = URL.createObjectURL(blob);
      link.setAttribute('href', url);
      link.setAttribute('download', fileName);
      link.style.visibility = 'hidden';
      document.body.appendChild(link);
      link.click();
      document.body.removeChild(link);
    }
  }
}

// 处理CSV文件
function processCSVFile(file) {
  readCSVFile(file)
    .then(csvData => {
      const data = parseCSVData(csvData);
      const filteredData = removeEmptyCells(data);
      const newCSVData = generateCSVData(filteredData);
      exportCSVFile(newCSVData, 'filtered.csv');
    })
    .catch(error => {
      console.error('Error processing CSV file:', error);
    });
}

// 选择CSV文件的input元素
const fileInput = document.querySelector('input[type="file"]');
fileInput.addEventListener('change', (event) => {
  const file = event.target.files[0];
  processCSVFile(file);
});