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 init
Create 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
<pre class='brush:php;toolbar:false;'>// 读取数据表方法
const readFileData = (tableName)=>{
let fname = dataPaths[tableName].xlsx
const xlsxData = xlsx.parse(fs.readFileSync(fname));
......
}</pre>
in
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.writeFile
Method, 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}写入成功`); }); }
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.
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!

Both Python and JavaScript's choices in development environments are important. 1) Python's development environment includes PyCharm, JupyterNotebook and Anaconda, which are suitable for data science and rapid prototyping. 2) The development environment of JavaScript includes Node.js, VSCode and Webpack, which are suitable for front-end and back-end development. Choosing the right tools according to project needs can improve development efficiency and project success rate.

Yes, the engine core of JavaScript is written in C. 1) The C language provides efficient performance and underlying control, which is suitable for the development of JavaScript engine. 2) Taking the V8 engine as an example, its core is written in C, combining the efficiency and object-oriented characteristics of C. 3) The working principle of the JavaScript engine includes parsing, compiling and execution, and the C language plays a key role in these processes.

JavaScript is at the heart of modern websites because it enhances the interactivity and dynamicity of web pages. 1) It allows to change content without refreshing the page, 2) manipulate web pages through DOMAPI, 3) support complex interactive effects such as animation and drag-and-drop, 4) optimize performance and best practices to improve user experience.

C and JavaScript achieve interoperability through WebAssembly. 1) C code is compiled into WebAssembly module and introduced into JavaScript environment to enhance computing power. 2) In game development, C handles physics engines and graphics rendering, and JavaScript is responsible for game logic and user interface.

JavaScript is widely used in websites, mobile applications, desktop applications and server-side programming. 1) In website development, JavaScript operates DOM together with HTML and CSS to achieve dynamic effects and supports frameworks such as jQuery and React. 2) Through ReactNative and Ionic, JavaScript is used to develop cross-platform mobile applications. 3) The Electron framework enables JavaScript to build desktop applications. 4) Node.js allows JavaScript to run on the server side and supports high concurrent requests.

Python is more suitable for data science and automation, while JavaScript is more suitable for front-end and full-stack development. 1. Python performs well in data science and machine learning, using libraries such as NumPy and Pandas for data processing and modeling. 2. Python is concise and efficient in automation and scripting. 3. JavaScript is indispensable in front-end development and is used to build dynamic web pages and single-page applications. 4. JavaScript plays a role in back-end development through Node.js and supports full-stack development.

C and C play a vital role in the JavaScript engine, mainly used to implement interpreters and JIT compilers. 1) C is used to parse JavaScript source code and generate an abstract syntax tree. 2) C is responsible for generating and executing bytecode. 3) C implements the JIT compiler, optimizes and compiles hot-spot code at runtime, and significantly improves the execution efficiency of JavaScript.

JavaScript's application in the real world includes front-end and back-end development. 1) Display front-end applications by building a TODO list application, involving DOM operations and event processing. 2) Build RESTfulAPI through Node.js and Express to demonstrate back-end applications.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 English version
Recommended: Win version, supports code prompts!

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool

WebStorm Mac version
Useful JavaScript development tools

Dreamweaver CS6
Visual web development tools
