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(data) {
  const lines = data.split('\n');
  const headers = lines[0].split(',');
  const rows = lines.slice(1);

  return rows.map((row) => {
    const values = row.split(',');
    return headers.reduce((obj, header, index) => {
      obj[header] = values[index];
      return obj;
    }, {});
  });
}

// 获取列值
function getColumnValues(data, column) {
  return data.map((row) => row[column]);
}

// 示例用法
const fileInput = document.getElementById('csvFileInput');
fileInput.addEventListener('change', async (event) => {
  const file = event.target.files[0];
  const csvData = await readCSVFile(file);
  const parsedData = parseCSVData(csvData);
  const columnValues = getColumnValues(parsedData, 'columnName');
  console.log(columnValues);
});