JarCasting
JarCasting JarCasting

cell-info-2-json

Excel cell information in JsonArray format String.

License

License
Categories

Categories

JSON Data
GroupId

GroupId

io.github.no-dumps
ArtifactId

ArtifactId

cell-info-2-json
Last Version

Last Version

1.0
Release Date

Release Date
Type

Type

jar
Description

Description

cell-info-2-json
Excel cell information in JsonArray format String.
Project URL

Project URL

https://github.com/no-dumps/cell-info-2-json
Source Code Management

Source Code Management

https://github.com/no-dumps/cell-info-2-json

Download cell-info-2-json

Filename Size
cell-info-2-json-1.0.pom
cell-info-2-json-1.0.jar 13 KB
cell-info-2-json-1.0-sources.jar 5 KB
cell-info-2-json-1.0-javadoc.jar 438 KB
cell-info-2-json-1.0-jar-with-dependencies.jar 40 MB
Browse

How to add to project

<!-- https://jarcasting.com/artifacts/io.github.no-dumps/cell-info-2-json/ -->
<dependency>
    <groupId>io.github.no-dumps</groupId>
    <artifactId>cell-info-2-json</artifactId>
    <version>1.0</version>
</dependency>
// https://jarcasting.com/artifacts/io.github.no-dumps/cell-info-2-json/
implementation 'io.github.no-dumps:cell-info-2-json:1.0'
// https://jarcasting.com/artifacts/io.github.no-dumps/cell-info-2-json/
implementation ("io.github.no-dumps:cell-info-2-json:1.0")
'io.github.no-dumps:cell-info-2-json:jar:1.0'
<dependency org="io.github.no-dumps" name="cell-info-2-json" rev="1.0">
  <artifact name="cell-info-2-json" type="jar" />
</dependency>
@Grapes(
@Grab(group='io.github.no-dumps', module='cell-info-2-json', version='1.0')
)
libraryDependencies += "io.github.no-dumps" % "cell-info-2-json" % "1.0"
[io.github.no-dumps/cell-info-2-json "1.0"]

Dependencies

compile (3)

Group / Artifact Type Version
com.fasterxml.jackson.core : jackson-databind jar 2.9.10.7
org.apache.poi : poi jar 5.0.0
org.apache.poi : poi-ooxml jar 5.0.0

Project Modules

There are no modules declared in this project.

cell-info-2-json

πŸ“¦ Description

This project is a Maven project that has the ability to return Excel cell information in JsonArray format String.

πŸ’¬ Usage

Just add the code below to your maven dependencies:

<dependency>
    <groupId>io.github.no-dumps</groupId>
    <artifactId>cell-info-2-json</artifactId>
    <version>1.0</version>
</dependency>

Write Program:

import nodump.noouchi.CellInfo2Json;

import java.io.IOException;

public class Program {
    public static void main(String[] args) throws IOException {
        String cellInfo = CellInfo2Json.getCellInfo("excelPath");
    }
}
View Sample String CellInfo2Json.getCellInfo() 
[
  {
    "SheetName": "γ‚·γƒΌγƒˆ1",
    "CellInfo": [
      {
        "cellRange": "A1",
        "value": "γƒ†γ‚Ήγƒˆ",
        "alignment": "GENERAL",
        "borderBottom": "THIN",
        "borderLeft": "THIN",
        "borderRight": "THIN",
        "borderTop": "THIN",
        "bottomBorderColor": "0",
        "leftBorderColor": "0",
        "rightBorderColor": "0",
        "topBorderColor": "0",
        "dataFormat": "General",
        "fillBackgroundColor": null,
        "fillForegroundColor": null,
        "fillPattern": "NO_FILL",
        "font": {
          "bold": "false",
          "charSet": "0",
          "xssfColor": null,
          "themeColor": "0",
          "fontHeight": "220",
          "fontHeightInPoints": "11",
          "fontName": "Calibri",
          "italic": "false",
          "strikeout": "false",
          "typeOffset": "0",
          "underline": "0"
        },
        "hidden": "false",
        "indention": "0",
        "locked": "true",
        "rotation": "0",
        "verticalAlignment": "BOTTOM"
      },
      {
        "cellRange": "B1",
        "value": "ァンプル",
        "alignment": "GENERAL",
        "borderBottom": "NONE",
        "borderLeft": "NONE",
        "borderRight": "NONE",
        "borderTop": "NONE",
        "bottomBorderColor": "8",
        "leftBorderColor": "8",
        "rightBorderColor": "8",
        "topBorderColor": "8",
        "dataFormat": "General",
        "fillBackgroundColor": "[-1, -1, 0]",
        "fillForegroundColor": "[-1, -1, 0]",
        "fillPattern": "SOLID_FOREGROUND",
        "font": {
          "bold": "false",
          "charSet": "0",
          "xssfColor": null,
          "themeColor": "0",
          "fontHeight": "220",
          "fontHeightInPoints": "11",
          "fontName": "Calibri",
          "italic": "false",
          "strikeout": "false",
          "typeOffset": "0",
          "underline": "0"
        },
        "hidden": "false",
        "indention": "0",
        "locked": "true",
        "rotation": "0",
        "verticalAlignment": "BOTTOM"
      },
      {
        "cellRange": "A2",
        "value": "Excel",
        "alignment": "GENERAL",
        "borderBottom": "NONE",
        "borderLeft": "NONE",
        "borderRight": "NONE",
        "borderTop": "NONE",
        "bottomBorderColor": "8",
        "leftBorderColor": "8",
        "rightBorderColor": "8",
        "topBorderColor": "8",
        "dataFormat": "General",
        "fillBackgroundColor": null,
        "fillForegroundColor": null,
        "fillPattern": "NO_FILL",
        "font": {
          "bold": "false",
          "charSet": "0",
          "xssfColor": "[0, 0, 0]",
          "themeColor": "1",
          "fontHeight": "220",
          "fontHeightInPoints": "11",
          "fontName": "Arial",
          "italic": "false",
          "strikeout": "false",
          "typeOffset": "0",
          "underline": "0"
        },
        "hidden": "false",
        "indention": "0",
        "locked": "true",
        "rotation": "0",
        "verticalAlignment": "BOTTOM"
      },
      {
        "cellRange": "B3",
        "value": "",
        "alignment": "GENERAL",
        "borderBottom": "NONE",
        "borderLeft": "NONE",
        "borderRight": "NONE",
        "borderTop": "NONE",
        "bottomBorderColor": "8",
        "leftBorderColor": "8",
        "rightBorderColor": "8",
        "topBorderColor": "8",
        "dataFormat": "m/d/yy",
        "fillBackgroundColor": null,
        "fillForegroundColor": null,
        "fillPattern": "NO_FILL",
        "font": {
          "bold": "false",
          "charSet": "0",
          "xssfColor": null,
          "themeColor": "0",
          "fontHeight": "220",
          "fontHeightInPoints": "11",
          "fontName": "Calibri",
          "italic": "false",
          "strikeout": "false",
          "typeOffset": "0",
          "underline": "0"
        },
        "hidden": "false",
        "indention": "0",
        "locked": "true",
        "rotation": "0",
        "verticalAlignment": "BOTTOM"
      }
    ]
  }
]

🎫 License

πŸ‘€ Author

io.github.no-dumps

no-dumps

This repository contains tools by me, for me.

Versions

Version
1.0