JavaScript解析CSV文件并计算值

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

// 解析CSV内容并计算总和
function parseCSVAndCalculateSum(csvContent) {
  const lines = csvContent.split("\n");
  const data = lines.map(line => line.split(","));
  
  let sum = 0;
  for (let i = 0; i < data.length; i++) {
    const row = data[i];
    for (let j = 0; j < row.length; j++) {
      const value = parseFloat(row[j]);
      if (!isNaN(value)) {
        sum += value;
      }
    }
  }
  
  return sum;
}

// 处理CSV文件
function handleCSVFile(file) {
  readCSVFile(file)
    .then(csvContent => {
      const sum = parseCSVAndCalculateSum(csvContent);
      console.log("Sum:", sum);
    })
    .catch(error => {
      console.error("Error:", error);
    });
}

// 示例：选择CSV文件并处理
const fileInput = document.getElementById("csvFileInput");
fileInput.addEventListener("change", function (e) {
  const file = e.target.files[0];
  handleCSVFile(file);
});