Skip to content

テンプレートとなるExcelファイルパスと入力したいデータをJSONで渡すと、データを入力した後、ExcelをBase64エンコーディングして返却します。

Notifications You must be signed in to change notification settings

nkwtnb/xlsx-creator

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

xlsx-creator

You pass the Excel file path and json format data you want to input to this program.
Make Excel with data you want to input and return base64 encoded string of it.

example of data(json)

"cell": {
    "name1": {
        "value": "foo"
    }
    "name2": {
        "value": "bar"
    }
    "name3": {
        "value": 123
    }
},
"row": {
    "details1": {
        "insertRow": true
        "value": [
            {
                "name1-1": {
                    "value": "foo1-1"
                }
                "name1-2": {
                    "value": "bar1-1"
                }
                "name1-3": {
                    "value": 1231-1
                }
            },
            {
                "name2-1": {
                    "value": "foo2-1"
                }
                "name2-2": {
                    "value": "bar2-1"
                }
                "name2-3": {
                    "value": 1232-1
                }
            }

        ]
    },
    "details2": {
        "insertRow": false
        "value": [
            {
                "name1-1": {
                    "value": "foo1-1"
                }
                "name1-2": {
                    "value": "bar1-1"
                }
                "name1-3": {
                    "value": 1231-1
                }
            },
            {
                "name2-1": {
                    "value": "foo2-1"
                }
                "name2-2": {
                    "value": "bar2-1"
                }
                "name2-3": {
                    "value": 1232-1
                }
            }

        ]
    }
}

build

IntelliJ

  1. execute build command below
    Menu > Build > Build Artifacts > xlsx-creator.jar > Build
  2. then the jar file will be outputted in out folder

About

テンプレートとなるExcelファイルパスと入力したいデータをJSONで渡すと、データを入力した後、ExcelをBase64エンコーディングして返却します。

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages