将不同对齐的Excel转换为JSON

为此,您可以使用ExcelJS模块,它有很多好的特性。

我已经更新了,允许将列顺序传递给readvalues函数。

例如:

var excel = require('exceljs');
var wb = new excel.Workbook();
var path = require('path');
var client1Path = path.resolve(__dirname, 'client1_data.xlsx');
var client2Path = path.resolve(__dirname, 'client2_data.xlsx');

function readValues(filePath, columnNumbers) {
    let columnNames = Object.entries(columnNumbers).reduce((a, [key,value]) => {
        a[value] = key;
        return a;
    }, []);

    return wb.xlsx.readFile(filePath).then( () => {
        var worksheet = wb.getWorksheet("Sheet1");
        var values = [];
        worksheet.eachRow((row) => {
            let obj = row.values.reduce((o, v, index) => {
                if (columnNames[index]) o[columnNames[index]] = v;
                return o;
            }, {});
            values.push(obj);
        });
        return values;
    });
}

async function testReadData() {
    try {
        let client1Data = await readValues(client1Path, { price: 1, name: 2, country: 3});
        console.log('testReadData: Client 1 data: ', client1Data);
        let client2Data = await readValues(client2Path, { price: 2, name: 1, country: 4});
        console.log('testReadData: Client 2 data: ', client2Data);
    } catch (error) {
        console.error('testReadData: Error occurred: ', error);
    }
}

testReadData();

我使用的数据与您的示例中的数据相同(现已更正)。

例如

客户端1数据:

$50 Jack    USA
$30 Harold  USA

客户端2数据:

Jack    $50 Florida USA
Harold  $30 California  USA

输出如下:

testreaddata:客户端1数据:

[ { price: '$50', name: 'Jack', country: 'USA' },
{ price: '$30', name: 'Harold', country: 'USA' } ]

testreaddata:客户端2数据:

[ { name: 'Jack', price: '$50', country: 'USA' },
{ name: 'Harold', price: '$30', country: 'USA' } ]