Let's talk about how to use Node to convert Excel to JSON

How to use Node to convert Excel to JSON? The following article will introduce to you the method of converting Excel to JSON in Node. I hope it will be helpful to you!

Currently I want to use Cocos Creator to make a word game, similar to My Life Restart Simulator.

The most important point is about data storage. In My Life Restart Simulator, most event and talent data are stored in excel tables. Of course, if you want to use Cocos Creator, because I am not planning to deploy a server, so I need to convert the data into a JSON file in advance. Then I can create a project, use node to read the excel file, and convert the data into JSON. [Related tutorial recommendations: nodejs video tutorial]

There are some libraries on the Internet that node calls excel. I used node-xlsx, The bottom layer of this library is built on the powerful SheetJS and has good enough format compatibility for xlsx documents.

npm address: node-xlsx - npm (npmjs.com)

Start

Before this I have created a new I have created a talent tabletalentTable.xlsx, which has many talents added and has different attribute bonuses

pnpm initCreate a project, and then use pnpm add node-xlsx to import the library into the project.

Create a main fileexcelMain.js. In this file, you need to introduce the required libraries

import { fileURLToPath } from 'node:url'
import path from 'path';
import fs from 'fs';
import xlsx from 'node-xlsx';

You can add the required stored json files in advancetalent. After json is created, find the relative paths of the xlsx and json folders through path

// 获取 __dirname 的 ESM 写法
const __dirname = path.dirname(fileURLToPath(import.meta.url))
// xlsx文件路径
const xlsxPath = path.resolve(__dirname, '../../assets/JsonData');

Because I have many tables, I can create a table path object

// 事件， 玩家， 门派， 天赋， 武学
let dataNames = ['event', 'player', 'sect', 'talent', 'skill']
let dataPaths = {};
for(let iname of dataNames) {
    dataPaths[iname] = {
        xlsx: path.resolve(xlsxPath, `./${iname}Table.xlsx`),
        json: path.resolve(xlsxPath, `./${iname}.json`)
    }
}

Then create a read file method, here you need to use readFileSync<div class="code" style="position:relative; padding:0px; margin:0px;"><pre class='brush:php;toolbar:false;'>// 读取数据表方法 const readFileData = (tableName)=&gt;{ let fname = dataPaths[tableName].xlsx const xlsxData = xlsx.parse(fs.readFileSync(fname)); ...... }</pre><div class="contentsignin">Copy after login</div></div> in

fs

here The read xlsxData is an array object. The elements in the array actually represent sheets. There is not only one table in the xlsx table, so it is an array object. But what I need Just the first form.

So just get the data of xlsxData[0].data, the data of data is arranged according to rows The array object

# is then converted into JSON format data. It needs to be changed into the format of Attribute:Attribute value, so you can create a method to convert The properties in the first row are combined with the data starting in the third row to create an array of objects.

const oneAndTwo = (arr)=>{
    if (arr.length <= 2) return [];
    let newarr = []
    for(let i = 2; i < arr.length; i++) {
        let newobj = {};
        for(let j = 0; j < arr[0].length; j++) {
            let jname = arr[0][j];
            newobj[jname] = (arr[i][j] != undefined)? arr[i][j] : null;
        }
        newarr.push(newobj)
    }
    return newarr;
}

The returned object is as follows

Then you can start writing the data into the json file using fs.writeFileMethod, use the format utf-8

// 写入JSON文件方法
const writeJson = (arr, jsonName)=>{
    let path = dataPaths[jsonName].json;
    let d = { data: arr }
    fs.writeFile(path, JSON.stringify(d), 'utf-8', (err)=>{
        console.log(`${jsonName}写入成功`);
    });
}

## Such required game fixed events and talents The data json will appear.

It is also easier to store JSON data as

excel objects. You need to use the xlsx.build method. I won’t go into too much introduction here. You can refer to it. npmHow to use the address.

For more node-related knowledge, please visit:

nodejs tutorial!

The above is the detailed content of Let's talk about how to use Node to convert Excel to JSON. For more information, please follow other related articles on the PHP Chinese website!