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 inNode. I hope it will be helpful to you!

Currently I want to useCocos Creatorto make a word game, similar toMy Life Restart Simulator.

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

There are some libraries on the Internet that node callsexcel. I usednode-xlsx, The bottom layer of this library is built on the powerfulSheetJSand 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 usepnpm add node-xlsxto 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 jsonis created, find the relative paths of the xlsx and json folders throughpath

// 获取 __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 usereadFileSync

// 读取数据表方法 const readFileData = (tableName)=>{ let fname = dataPaths[tableName].xlsx const xlsxData = xlsx.parse(fs.readFileSync(fname)); ...... }

in

fs

here The readxlsxDatais 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 ofxlsxData[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 ofAttribute: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 usingfs.writeFileMethod, use the formatutf-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

excelobjects. You need to use thexlsx.buildmethod. 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!