Skip to content

Latest commit

 

History

History
53 lines (36 loc) · 982 Bytes

README-en.md

File metadata and controls

53 lines (36 loc) · 982 Bytes

Introduce

中文文档

This is an internationalization helper that helps you convert the files you want to internationalize between Json and Excel.

Install with npm

npm install convert-excel-js -g

Yarn

yarn global add convert-excel-js

How to use it

Convert json to excel

excel [filePath] [fileName]

excel ./filename.json
# excel ./filename.json appText

Convert excel to json

json [filePath] [sheetName] [keyColumn] [valueColumn] [fileName]

json ./filename.xlsx Sheet A B
# json ./filename.xlsx Sheet A B fileName.js

Add time stamp

If you expect the file name to record the time just insert _time_ 'into the name for example:

Convert json to excel

excel [filePath] [fileName]

excel ./filename.json appText._time_.json

Convert excel to json

json [filePath] [sheetName] [keyColumn] [valueColumn] [fileName]

json ./filename.xlsx Sheet A B fileName._time_.js