search
HomeWeb Front-endJS TutorialLet's talk about how to use Node to convert Excel to JSON

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

Nov 28, 2022 pm 08:02 PM
excelnodejs​jsonnode

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!

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

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

Lets talk about how to use Node to convert Excel to JSON

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`)
    }
}

Lets talk about how to use Node to convert Excel to JSON

Then create a read file method, here you need to use readFileSync<pre class='brush:php;toolbar:false;'>// 读取数据表方法 const readFileData = (tableName)=&gt;{ let fname = dataPaths[tableName].xlsx const xlsxData = xlsx.parse(fs.readFileSync(fname)); ...... }</pre> 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.

Lets talk about how to use Node to convert Excel to JSON

Lets talk about how to use Node to convert Excel to JSON

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

Lets talk about how to use Node to convert Excel to JSON

# 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

Lets talk about how to use Node to convert Excel to JSON

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), &#39;utf-8&#39;, (err)=>{
        console.log(`${jsonName}写入成功`);
    });
}

Lets talk about how to use Node to convert Excel to JSON

Lets talk about how to use Node to convert Excel to JSON

## 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!

Statement
This article is reproduced at:掘金社区. If there is any infringement, please contact admin@php.cn delete
Python vs. JavaScript: Development Environments and ToolsPython vs. JavaScript: Development Environments and ToolsApr 26, 2025 am 12:09 AM

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.

Is JavaScript Written in C? Examining the EvidenceIs JavaScript Written in C? Examining the EvidenceApr 25, 2025 am 12:15 AM

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's Role: Making the Web Interactive and DynamicJavaScript's Role: Making the Web Interactive and DynamicApr 24, 2025 am 12:12 AM

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: The Connection ExplainedC and JavaScript: The Connection ExplainedApr 23, 2025 am 12:07 AM

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.

From Websites to Apps: The Diverse Applications of JavaScriptFrom Websites to Apps: The Diverse Applications of JavaScriptApr 22, 2025 am 12:02 AM

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 vs. JavaScript: Use Cases and Applications ComparedPython vs. JavaScript: Use Cases and Applications ComparedApr 21, 2025 am 12:01 AM

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.

The Role of C/C   in JavaScript Interpreters and CompilersThe Role of C/C in JavaScript Interpreters and CompilersApr 20, 2025 am 12:01 AM

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 in Action: Real-World Examples and ProjectsJavaScript in Action: Real-World Examples and ProjectsApr 19, 2025 am 12:13 AM

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.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

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

Hot Tools

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools