<classpathentry kind="lib" path="lib/ooxml-schemas-1.1.jar"/>
<classpathentry kind="lib" path="lib/poi-3.10-FINAL-20140208.jar"/>
<classpathentry kind="lib" path="lib/poi-ooxml-3.10-FINAL-20140208.jar"/>
- <classpathentry kind="lib" path="lib/slf4j-api-1.7.5.jar"/>
<classpathentry kind="lib" path="lib/commons-jexl-2.1.1.jar"/>
<classpathentry kind="lib" path="lib/commons-lang3-3.3.2.jar"/>
<classpathentry kind="lib" path="lib/xmlbeans-2.6.0.jar"/>
<attribute name="owner.project.facets" value="java"/>
</attributes>
</classpathentry>
- <classpathentry kind="output" path="bin"/>
+ <classpathentry kind="lib" path="lib/jsonic-1.3.5.jar"/>
+ <classpathentry kind="lib" path="lib/slf4j-api-1.7.7.jar"/>
+ <classpathentry kind="output" path="build"/>
</classpath>
--- /dev/null
+eclipse.preferences.version=1\r
+encoding//sample/bin/simple_EL_example.bat=ISO-8859-1\r
--- /dev/null
+eclipse.preferences.version=1\r
+org.eclipse.ltk.core.refactoring.enable.project.refactoring.history=false\r
--- /dev/null
+<?xml version="1.0" encoding="UTF-8"?>\r
+<project-modules id="moduleCoreId" project-version="1.5.0">\r
+ <wb-module deploy-name="Jaxcel">\r
+ <wb-resource deploy-path="/" source-path="/src"/>\r
+ <wb-resource deploy-path="/" source-path="/examples"/>\r
+ </wb-module>\r
+</project-modules>\r
--- /dev/null
+<?xml version="1.0" encoding="UTF-8"?>\r
+<faceted-project>\r
+ <runtime name="Apache Tomcat v7.0"/>\r
+ <fixed facet="jst.utility"/>\r
+ <fixed facet="java"/>\r
+ <installed facet="java" version="1.6"/>\r
+ <installed facet="jst.utility" version="1.0"/>\r
+</faceted-project>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>すべてのクラス</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">\r
</head>\r
<body>\r
<div class="indexContainer">\r
<ul>\r
<li><a href="org/hanei/jaxcel/report/ELManager.html" title="org.hanei.jaxcel.report内のクラス" target="classFrame">ELManager</a></li>\r
+<li><a href="org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス" target="classFrame">ExcelUtil</a></li>\r
<li><a href="org/hanei/jaxcel/report/JaxcelContext.html" title="org.hanei.jaxcel.report内のクラス" target="classFrame">JaxcelContext</a></li>\r
<li><a href="org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス" target="classFrame">JaxcelInputException</a></li>\r
<li><a href="org/hanei/jaxcel/exception/JaxcelOutputException.html" title="org.hanei.jaxcel.exception内のクラス" target="classFrame">JaxcelOutputException</a></li>\r
<li><a href="org/hanei/jaxcel/exception/JaxcelRuntimeException.html" title="org.hanei.jaxcel.exception内のクラス" target="classFrame">JaxcelRuntimeException</a></li>\r
-<li><a href="org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス" target="classFrame">JaxcelUtil</a></li>\r
+<li><a href="org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス" target="classFrame">MakeReportTool</a></li>\r
<li><a href="org/hanei/jaxcel/report/ReportMaker.html" title="org.hanei.jaxcel.report内のクラス" target="classFrame">ReportMaker</a></li>\r
<li><a href="org/hanei/jaxcel/report/TLParser.html" title="org.hanei.jaxcel.report内のクラス" target="classFrame">TLParser</a></li>\r
</ul>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>すべてのクラス</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">\r
</head>\r
<body>\r
<div class="indexContainer">\r
<ul>\r
<li><a href="org/hanei/jaxcel/report/ELManager.html" title="org.hanei.jaxcel.report内のクラス">ELManager</a></li>\r
+<li><a href="org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></li>\r
<li><a href="org/hanei/jaxcel/report/JaxcelContext.html" title="org.hanei.jaxcel.report内のクラス">JaxcelContext</a></li>\r
<li><a href="org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></li>\r
<li><a href="org/hanei/jaxcel/exception/JaxcelOutputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelOutputException</a></li>\r
<li><a href="org/hanei/jaxcel/exception/JaxcelRuntimeException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelRuntimeException</a></li>\r
-<li><a href="org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></li>\r
+<li><a href="org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス">MakeReportTool</a></li>\r
<li><a href="org/hanei/jaxcel/report/ReportMaker.html" title="org.hanei.jaxcel.report内のクラス">ReportMaker</a></li>\r
<li><a href="org/hanei/jaxcel/report/TLParser.html" title="org.hanei.jaxcel.report内のクラス">TLParser</a></li>\r
</ul>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>定数フィールド値</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">\r
</head>\r
<body>\r
<ul class="blockList">\r
<li class="blockList">\r
<table border="0" cellpadding="3" cellspacing="0" summary="定数フィールド値表、定数フィールドのリストおよび値">\r
-<caption><span>org.hanei.jaxcel.util.<a href="org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></span><span class="tabEnd"> </span></caption>\r
+<caption><span>org.hanei.jaxcel.util.<a href="org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></span><span class="tabEnd"> </span></caption>\r
<tr>\r
<th class="colFirst" scope="col">修飾子とタイプ</th>\r
<th scope="col">定数フィールド</th>\r
</tr>\r
<tbody>\r
<tr class="altColor">\r
-<td class="colFirst"><a name="org.hanei.jaxcel.util.JaxcelUtil.ENCLOSES">\r
+<td class="colFirst"><a name="org.hanei.jaxcel.util.ExcelUtil.ENCLOSES">\r
<!-- -->\r
</a><code>public static final java.lang.String</code></td>\r
-<td><code><a href="org/hanei/jaxcel/util/JaxcelUtil.html#ENCLOSES">ENCLOSES</a></code></td>\r
+<td><code><a href="org/hanei/jaxcel/util/ExcelUtil.html#ENCLOSES">ENCLOSES</a></code></td>\r
<td class="colLast"><code>"encloses"</code></td>\r
</tr>\r
<tr class="rowColor">\r
-<td class="colFirst"><a name="org.hanei.jaxcel.util.JaxcelUtil.INSIDE">\r
+<td class="colFirst"><a name="org.hanei.jaxcel.util.ExcelUtil.INSIDE">\r
<!-- -->\r
</a><code>public static final java.lang.String</code></td>\r
-<td><code><a href="org/hanei/jaxcel/util/JaxcelUtil.html#INSIDE">INSIDE</a></code></td>\r
+<td><code><a href="org/hanei/jaxcel/util/ExcelUtil.html#INSIDE">INSIDE</a></code></td>\r
<td class="colLast"><code>"inside"</code></td>\r
</tr>\r
<tr class="altColor">\r
-<td class="colFirst"><a name="org.hanei.jaxcel.util.JaxcelUtil.NO_INTERSECTION">\r
+<td class="colFirst"><a name="org.hanei.jaxcel.util.ExcelUtil.NO_INTERSECTION">\r
<!-- -->\r
</a><code>public static final java.lang.String</code></td>\r
-<td><code><a href="org/hanei/jaxcel/util/JaxcelUtil.html#NO_INTERSECTION">NO_INTERSECTION</a></code></td>\r
+<td><code><a href="org/hanei/jaxcel/util/ExcelUtil.html#NO_INTERSECTION">NO_INTERSECTION</a></code></td>\r
<td class="colLast"><code>"no_intersection"</code></td>\r
</tr>\r
<tr class="rowColor">\r
-<td class="colFirst"><a name="org.hanei.jaxcel.util.JaxcelUtil.OVERLAP">\r
+<td class="colFirst"><a name="org.hanei.jaxcel.util.ExcelUtil.OVERLAP">\r
<!-- -->\r
</a><code>public static final java.lang.String</code></td>\r
-<td><code><a href="org/hanei/jaxcel/util/JaxcelUtil.html#OVERLAP">OVERLAP</a></code></td>\r
+<td><code><a href="org/hanei/jaxcel/util/ExcelUtil.html#OVERLAP">OVERLAP</a></code></td>\r
<td class="colLast"><code>"overlap"</code></td>\r
</tr>\r
</tbody>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>非推奨APIのリスト</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>APIヘルプ</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Cの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
</a>\r
<h2 class="title">C</h2>\r
<dl>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#clearRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, boolean, boolean)">clearRange(Sheet, CellRangeAddress, boolean, boolean)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#clearRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, boolean, boolean)">clearRange(Sheet, CellRangeAddress, boolean, boolean)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">対象範囲をクリアする</div>\r
</dd>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Rの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Sの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<dd>\r
<div class="block">EL式解析で使用するオブジェクトをパラメータとしてセット</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#shift(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, java.lang.String, int)">shift(Sheet, CellRangeAddress, String, int)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#shift(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, java.lang.String, int)">shift(Sheet, CellRangeAddress, String, int)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">対象範囲をブロック指定でシフトする</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#shift(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, java.lang.String, int, boolean)">shift(Sheet, CellRangeAddress, String, int, boolean)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#shift(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, java.lang.String, int, boolean)">shift(Sheet, CellRangeAddress, String, int, boolean)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">対象範囲をシフトする</div>\r
</dd>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Tの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Vの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
</a>\r
<h2 class="title">V</h2>\r
<dl>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#validateColumn(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">validateColumn(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#validateColumn(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">validateColumn(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">範囲の列方向妥当性チェック</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#validateRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">validateRange(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#validateRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">validateRange(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">範囲の妥当性チェック</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#validateRow(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">validateRow(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#validateRow(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">validateRow(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">範囲の行方向妥当性チェック</div>\r
</dd>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Eの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<dd>\r
<div class="block">コンストラクタ</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#ENCLOSES">ENCLOSES</a></span> - クラス のstatic変数org.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#ENCLOSES">ENCLOSES</a></span> - クラス のstatic変数org.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd> </dd>\r
<dt><span class="strong"><a href="../org/hanei/jaxcel/report/ELManager.html#evaluate(java.lang.String)">evaluate(String)</a></span> - クラス のメソッドorg.hanei.jaxcel.report.<a href="../org/hanei/jaxcel/report/ELManager.html" title="org.hanei.jaxcel.report内のクラス">ELManager</a></dt>\r
<dd>\r
<div class="block">EL式を解析。</div>\r
</dd>\r
+<dt><a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">ExcelUtil</span></a> - <a href="../org/hanei/jaxcel/util/package-summary.html">org.hanei.jaxcel.util</a>のクラス</dt>\r
+<dd>\r
+<div class="block">Excelユーティリティクラス</div>\r
+</dd>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#ExcelUtil()">ExcelUtil()</a></span> - クラス のコンストラクタorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
+<dd> </dd>\r
</dl>\r
<a href="index-1.html">C</a> <a href="index-2.html">E</a> <a href="index-3.html">G</a> <a href="index-4.html">I</a> <a href="index-5.html">J</a> <a href="index-6.html">M</a> <a href="index-7.html">N</a> <a href="index-8.html">O</a> <a href="index-9.html">P</a> <a href="index-10.html">R</a> <a href="index-11.html">S</a> <a href="index-12.html">T</a> <a href="index-13.html">V</a> </div>\r
<!-- ======= START OF BOTTOM NAVBAR ====== -->\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Gの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<dd>\r
<div class="block">ELManagerオブジェクトを返却</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#getIntersectRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">getIntersectRange(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#getIntersectRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">getIntersectRange(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">指定された範囲がシートに収まらない場合、収まるサイズにリサイズした範囲を返却する</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#getIntersectRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.util.CellRangeAddress)">getIntersectRange(Sheet, CellRangeAddress, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#getIntersectRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.util.CellRangeAddress)">getIntersectRange(Sheet, CellRangeAddress, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">指定された範囲の交差する範囲を返却する<br></div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#getIntersectString(org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.util.CellRangeAddress)">getIntersectString(CellRangeAddress, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#getIntersectString(org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.util.CellRangeAddress)">getIntersectString(CellRangeAddress, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">指定された範囲の交差状態を定数文字列で返却する<br>
ブック、シートは意識しません。</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#getLastColNum(org.apache.poi.ss.usermodel.Sheet)">getLastColNum(Sheet)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#getLastColNum(org.apache.poi.ss.usermodel.Sheet)">getLastColNum(Sheet)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">シートの最大列数を返却</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#getLastColNum(org.apache.poi.ss.usermodel.Sheet, int, int)">getLastColNum(Sheet, int, int)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#getLastColNum(org.apache.poi.ss.usermodel.Sheet, int, int)">getLastColNum(Sheet, int, int)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">シート指定行範囲の最大列数を返却</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#getMaxColumnIndex(org.apache.poi.ss.usermodel.Sheet)">getMaxColumnIndex(Sheet)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#getMaxColumnIndex(org.apache.poi.ss.usermodel.Sheet)">getMaxColumnIndex(Sheet)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">シートの最大列数を返却</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#getMaxRowIndex(org.apache.poi.ss.usermodel.Sheet)">getMaxRowIndex(Sheet)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#getMaxRowIndex(org.apache.poi.ss.usermodel.Sheet)">getMaxRowIndex(Sheet)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">シートの最大行数を返却</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#getMoveFormula(org.apache.poi.ss.usermodel.Sheet, java.lang.String, int, int)">getMoveFormula(Sheet, String, int, int)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#getMoveFormula(org.apache.poi.ss.usermodel.Sheet, java.lang.String, int, int)">getMoveFormula(Sheet, String, int, int)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">数式に使用されている相対参照を指定距離で移動した結果を返却<br>
配列数式はPOIの制約上使用できません</div>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Iの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
</a>\r
<h2 class="title">I</h2>\r
<dl>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#INSIDE">INSIDE</a></span> - クラス のstatic変数org.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#INSIDE">INSIDE</a></span> - クラス のstatic変数org.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">範囲判定</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#isFullColumnRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">isFullColumnRange(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#isFullColumnRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">isFullColumnRange(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">列全体を指定している範囲であるかの判定</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#isFullRowRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">isFullRowRange(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#isFullRowRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">isFullRowRange(Sheet, CellRangeAddress)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">行全体を指定している範囲であるかの判定</div>\r
</dd>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Jの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<dd> </dd>\r
<dt><span class="strong"><a href="../org/hanei/jaxcel/exception/JaxcelRuntimeException.html#JaxcelRuntimeException(java.lang.String, java.lang.Throwable)">JaxcelRuntimeException(String, Throwable)</a></span> - 例外 のコンストラクタorg.hanei.jaxcel.exception.<a href="../org/hanei/jaxcel/exception/JaxcelRuntimeException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelRuntimeException</a></dt>\r
<dd> </dd>\r
-<dt><a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">JaxcelUtil</span></a> - <a href="../org/hanei/jaxcel/util/package-summary.html">org.hanei.jaxcel.util</a>のクラス</dt>\r
-<dd>\r
-<div class="block">Excelユーティリティクラス</div>\r
-</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#JaxcelUtil()">JaxcelUtil()</a></span> - クラス のコンストラクタorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
-<dd> </dd>\r
</dl>\r
<a href="index-1.html">C</a> <a href="index-2.html">E</a> <a href="index-3.html">G</a> <a href="index-4.html">I</a> <a href="index-5.html">J</a> <a href="index-6.html">M</a> <a href="index-7.html">N</a> <a href="index-8.html">O</a> <a href="index-9.html">P</a> <a href="index-10.html">R</a> <a href="index-11.html">S</a> <a href="index-12.html">T</a> <a href="index-13.html">V</a> </div>\r
<!-- ======= START OF BOTTOM NAVBAR ====== -->\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Mの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
</a>\r
<h2 class="title">M</h2>\r
<dl>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/MakeReportTool.html#main(java.lang.String[])">main(String[])</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス">MakeReportTool</a></dt>\r
+<dd>\r
+<div class="block">ExcelテンプレートファイルにJSONファイルのデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。</div>\r
+</dd>\r
<dt><span class="strong"><a href="../org/hanei/jaxcel/report/ReportMaker.html#makeReport(java.io.InputStream, java.util.Map)">makeReport(InputStream, Map<String, Object>)</a></span> - クラス のメソッドorg.hanei.jaxcel.report.<a href="../org/hanei/jaxcel/report/ReportMaker.html" title="org.hanei.jaxcel.report内のクラス">ReportMaker</a></dt>\r
<dd>\r
<div class="block">入力ストリームのExcelテンプレートファイルにデータを挿入することでExcel帳票を生成、Workbookオブジェクトを返却する。</div>\r
<dd>\r
<div class="block">入力ストリームのExcelテンプレートファイルにデータを挿入することでExcel帳票を生成、出力ストリームにExcel帳票を出力する。</div>\r
</dd>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/report/ReportMaker.html#makeReport(java.io.InputStream, java.util.Map, java.io.File)">makeReport(InputStream, Map<String, Object>, File)</a></span> - クラス のメソッドorg.hanei.jaxcel.report.<a href="../org/hanei/jaxcel/report/ReportMaker.html" title="org.hanei.jaxcel.report内のクラス">ReportMaker</a></dt>\r
+<dd>\r
+<div class="block">入力ストリームのExcelテンプレートファイルにデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。</div>\r
+</dd>\r
<dt><span class="strong"><a href="../org/hanei/jaxcel/report/ReportMaker.html#makeReport(java.io.File, java.util.Map)">makeReport(File, Map<String, Object>)</a></span> - クラス のメソッドorg.hanei.jaxcel.report.<a href="../org/hanei/jaxcel/report/ReportMaker.html" title="org.hanei.jaxcel.report内のクラス">ReportMaker</a></dt>\r
<dd>\r
<div class="block">Excelテンプレートファイルにデータを挿入することでExcel帳票を生成、Workbookオブジェクトを返却する。</div>\r
<dd>\r
<div class="block">Excelテンプレートファイルにデータを挿入することでExcel帳票を生成、出力ストリームにExcel帳票を出力する。</div>\r
</dd>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/report/ReportMaker.html#makeReport(java.io.File, java.util.Map, java.io.File)">makeReport(File, Map<String, Object>, File)</a></span> - クラス のメソッドorg.hanei.jaxcel.report.<a href="../org/hanei/jaxcel/report/ReportMaker.html" title="org.hanei.jaxcel.report内のクラス">ReportMaker</a></dt>\r
+<dd>\r
+<div class="block">Excelテンプレートファイルにデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。</div>\r
+</dd>\r
<dt><span class="strong"><a href="../org/hanei/jaxcel/report/ReportMaker.html#makeReport(org.apache.poi.ss.usermodel.Workbook, java.util.Map)">makeReport(Workbook, Map<String, Object>)</a></span> - クラス のメソッドorg.hanei.jaxcel.report.<a href="../org/hanei/jaxcel/report/ReportMaker.html" title="org.hanei.jaxcel.report内のクラス">ReportMaker</a></dt>\r
<dd>\r
<div class="block">ExcelテンプレートのWorkbookオブジェクトにデータを挿入することでExcel帳票を生成する。</div>\r
</dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#moveRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, int, int, boolean)">moveRange(Sheet, CellRangeAddress, int, int, boolean)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><a href="../org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">MakeReportTool</span></a> - <a href="../org/hanei/jaxcel/util/package-summary.html">org.hanei.jaxcel.util</a>のクラス</dt>\r
+<dd> </dd>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/MakeReportTool.html#MakeReportTool()">MakeReportTool()</a></span> - クラス のコンストラクタorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス">MakeReportTool</a></dt>\r
+<dd> </dd>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#moveRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, int, int, boolean)">moveRange(Sheet, CellRangeAddress, int, int, boolean)</a></span> - クラス のstaticメソッドorg.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd>\r
<div class="block">対象範囲を移動する</div>\r
</dd>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Nの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
</a>\r
<h2 class="title">N</h2>\r
<dl>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#NO_INTERSECTION">NO_INTERSECTION</a></span> - クラス のstatic変数org.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#NO_INTERSECTION">NO_INTERSECTION</a></span> - クラス のstatic変数org.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd> </dd>\r
</dl>\r
<a href="index-1.html">C</a> <a href="index-2.html">E</a> <a href="index-3.html">G</a> <a href="index-4.html">I</a> <a href="index-5.html">J</a> <a href="index-6.html">M</a> <a href="index-7.html">N</a> <a href="index-8.html">O</a> <a href="index-9.html">P</a> <a href="index-10.html">R</a> <a href="index-11.html">S</a> <a href="index-12.html">T</a> <a href="index-13.html">V</a> </div>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Oの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<dd> </dd>\r
<dt><a href="../org/hanei/jaxcel/util/package-summary.html">org.hanei.jaxcel.util</a> - パッケージ org.hanei.jaxcel.util</dt>\r
<dd> </dd>\r
-<dt><span class="strong"><a href="../org/hanei/jaxcel/util/JaxcelUtil.html#OVERLAP">OVERLAP</a></span> - クラス のstatic変数org.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></dt>\r
+<dt><span class="strong"><a href="../org/hanei/jaxcel/util/ExcelUtil.html#OVERLAP">OVERLAP</a></span> - クラス のstatic変数org.hanei.jaxcel.util.<a href="../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></dt>\r
<dd> </dd>\r
</dl>\r
<a href="index-1.html">C</a> <a href="index-2.html">E</a> <a href="index-3.html">G</a> <a href="index-4.html">I</a> <a href="index-5.html">J</a> <a href="index-6.html">M</a> <a href="index-7.html">N</a> <a href="index-8.html">O</a> <a href="index-9.html">P</a> <a href="index-10.html">R</a> <a href="index-11.html">S</a> <a href="index-12.html">T</a> <a href="index-13.html">V</a> </div>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>Pの索引</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>生成されたドキュメント(タイトルなし)</title>\r
<script type="text/javascript">\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:29 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>JaxcelInputException</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>JaxcelOutputException</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>JaxcelRuntimeException</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>クラス org.hanei.jaxcel.exception.JaxcelInputExceptionの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>クラス org.hanei.jaxcel.exception.JaxcelOutputExceptionの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>クラス org.hanei.jaxcel.exception.JaxcelRuntimeExceptionの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>org.hanei.jaxcel.exception</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>org.hanei.jaxcel.exception</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>org.hanei.jaxcel.exception クラス階層</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>パッケージ org.hanei.jaxcel.exceptionの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>ELManager</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>JaxcelContext</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>ReportMaker</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
</tr>\r
<tr class="altColor">\r
<td class="colFirst"><code>void</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/report/ReportMaker.html#makeReport(java.io.File, java.util.Map, java.io.File)">makeReport</a></strong>(java.io.File template,\r
+ java.util.Map<java.lang.String,java.lang.Object> parameter,\r
+ java.io.File output)</code>\r
+<div class="block">Excelテンプレートファイルにデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。</div>\r
+</td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>void</code></td>\r
<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/report/ReportMaker.html#makeReport(java.io.File, java.util.Map, java.io.OutputStream)">makeReport</a></strong>(java.io.File template,\r
java.util.Map<java.lang.String,java.lang.Object> parameter,\r
java.io.OutputStream output)</code>\r
<div class="block">Excelテンプレートファイルにデータを挿入することでExcel帳票を生成、出力ストリームにExcel帳票を出力する。</div>\r
</td>\r
</tr>\r
-<tr class="rowColor">\r
+<tr class="altColor">\r
<td class="colFirst"><code>org.apache.poi.ss.usermodel.Workbook</code></td>\r
<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/report/ReportMaker.html#makeReport(java.io.InputStream, java.util.Map)">makeReport</a></strong>(java.io.InputStream template,\r
java.util.Map<java.lang.String,java.lang.Object> parameter)</code>\r
<div class="block">入力ストリームのExcelテンプレートファイルにデータを挿入することでExcel帳票を生成、Workbookオブジェクトを返却する。</div>\r
</td>\r
</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>void</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/report/ReportMaker.html#makeReport(java.io.InputStream, java.util.Map, java.io.File)">makeReport</a></strong>(java.io.InputStream template,\r
+ java.util.Map<java.lang.String,java.lang.Object> parameter,\r
+ java.io.File output)</code>\r
+<div class="block">入力ストリームのExcelテンプレートファイルにデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。</div>\r
+</td>\r
+</tr>\r
<tr class="altColor">\r
<td class="colFirst"><code>void</code></td>\r
<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/report/ReportMaker.html#makeReport(java.io.InputStream, java.util.Map, java.io.OutputStream)">makeReport</a></strong>(java.io.InputStream template,\r
<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelOutputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelOutputException</a></code> - 出力例外発生時</dd></dl>\r
</li>\r
</ul>\r
+<a name="makeReport(java.io.InputStream, java.util.Map, java.io.File)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>makeReport</h4>\r
+<pre>public void makeReport(java.io.InputStream template,\r
+ java.util.Map<java.lang.String,java.lang.Object> parameter,\r
+ java.io.File output)</pre>\r
+<div class="block">入力ストリームのExcelテンプレートファイルにデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。<br>
+ 入力ストリームは別途クローズが必要。</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>template</code> - Excelテンプレートファイル入力ストリーム</dd><dd><code>parameter</code> - テンプレートに挿入するデータ</dd><dd><code>output</code> - Excel帳票出力ファイル</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelOutputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelOutputException</a></code> - 出力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
<a name="makeReport(java.io.File, java.util.Map)">\r
<!-- -->\r
</a>\r
<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelOutputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelOutputException</a></code> - 出力例外発生時</dd></dl>\r
</li>\r
</ul>\r
+<a name="makeReport(java.io.File, java.util.Map, java.io.File)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>makeReport</h4>\r
+<pre>public void makeReport(java.io.File template,\r
+ java.util.Map<java.lang.String,java.lang.Object> parameter,\r
+ java.io.File output)</pre>\r
+<div class="block">Excelテンプレートファイルにデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。<br></div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>template</code> - Excelテンプレートファイル</dd><dd><code>parameter</code> - テンプレートに挿入するデータ</dd><dd><code>output</code> - Excel帳票出力ファイル</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelOutputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelOutputException</a></code> - 出力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
<a name="makeReport(org.apache.poi.ss.usermodel.Workbook, java.util.Map)">\r
<!-- -->\r
</a>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>TLParser</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>クラス org.hanei.jaxcel.report.ELManagerの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>クラス org.hanei.jaxcel.report.JaxcelContextの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>クラス org.hanei.jaxcel.report.ReportMakerの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>クラス org.hanei.jaxcel.report.TLParserの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>org.hanei.jaxcel.report</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>org.hanei.jaxcel.report</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>org.hanei.jaxcel.report クラス階層</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>パッケージ org.hanei.jaxcel.reportの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
--- /dev/null
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r
+<!-- NewPage -->\r
+<html lang="ja">\r
+<head>\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
+<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
+<title>ExcelUtil</title>\r
+<meta name="date" content="2014-09-01">\r
+<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
+</head>\r
+<body>\r
+<script type="text/javascript"><!--\r
+ if (location.href.indexOf('is-external=true') == -1) {\r
+ parent.document.title="ExcelUtil";\r
+ }\r
+//-->\r
+</script>\r
+<noscript>\r
+<div>ブラウザのJavaScriptが無効になっています。</div>\r
+</noscript>\r
+<!-- ========= START OF TOP NAVBAR ======= -->\r
+<div class="topNav"><a name="navbar_top">\r
+<!-- -->\r
+</a><a href="#skip-navbar_top" title="ナビゲーション・リンクをスキップ"></a><a name="navbar_top_firstrow">\r
+<!-- -->\r
+</a>\r
+<ul class="navList" title="ナビゲーション">\r
+<li><a href="../../../../overview-summary.html">概要</a></li>\r
+<li><a href="package-summary.html">パッケージ</a></li>\r
+<li class="navBarCell1Rev">クラス</li>\r
+<li><a href="class-use/ExcelUtil.html">使用</a></li>\r
+<li><a href="package-tree.html">階層ツリー</a></li>\r
+<li><a href="../../../../deprecated-list.html">非推奨</a></li>\r
+<li><a href="../../../../index-files/index-1.html">索引</a></li>\r
+<li><a href="../../../../help-doc.html">ヘルプ</a></li>\r
+</ul>\r
+</div>\r
+<div class="subNav">\r
+<ul class="navList">\r
+<li>前のクラス</li>\r
+<li><a href="../../../../org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">次のクラス</span></a></li>\r
+</ul>\r
+<ul class="navList">\r
+<li><a href="../../../../index.html?org/hanei/jaxcel/util/ExcelUtil.html" target="_top">フレーム</a></li>\r
+<li><a href="ExcelUtil.html" target="_top">フレームなし</a></li>\r
+</ul>\r
+<ul class="navList" id="allclasses_navbar_top">\r
+<li><a href="../../../../allclasses-noframe.html">すべてのクラス</a></li>\r
+</ul>\r
+<div>\r
+<script type="text/javascript"><!--\r
+ allClassesLink = document.getElementById("allclasses_navbar_top");\r
+ if(window==top) {\r
+ allClassesLink.style.display = "block";\r
+ }\r
+ else {\r
+ allClassesLink.style.display = "none";\r
+ }\r
+ //-->\r
+</script>\r
+</div>\r
+<div>\r
+<ul class="subNavList">\r
+<li>概要: </li>\r
+<li>ネスト | </li>\r
+<li><a href="#field_summary">フィールド</a> | </li>\r
+<li><a href="#constructor_summary">コンストラクタ</a> | </li>\r
+<li><a href="#method_summary">メソッド</a></li>\r
+</ul>\r
+<ul class="subNavList">\r
+<li>詳細: </li>\r
+<li><a href="#field_detail">フィールド</a> | </li>\r
+<li><a href="#constructor_detail">コンストラクタ</a> | </li>\r
+<li><a href="#method_detail">メソッド</a></li>\r
+</ul>\r
+</div>\r
+<a name="skip-navbar_top">\r
+<!-- -->\r
+</a></div>\r
+<!-- ========= END OF TOP NAVBAR ========= -->\r
+<!-- ======== START OF CLASS DATA ======== -->\r
+<div class="header">\r
+<div class="subTitle">org.hanei.jaxcel.util</div>\r
+<h2 title="クラス ExcelUtil" class="title">クラス ExcelUtil</h2>\r
+</div>\r
+<div class="contentContainer">\r
+<ul class="inheritance">\r
+<li>java.lang.Object</li>\r
+<li>\r
+<ul class="inheritance">\r
+<li>org.hanei.jaxcel.util.ExcelUtil</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+<div class="description">\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<hr>\r
+<br>\r
+<pre>public class <span class="strong">ExcelUtil</span>\r
+extends java.lang.Object</pre>\r
+<div class="block">Excelユーティリティクラス</div>\r
+<dl><dt><span class="strong">バージョン:</span></dt>\r
+ <dd>1.00.00</dd>\r
+<dt><span class="strong">作成者:</span></dt>\r
+ <dd>Noboru Saito</dd></dl>\r
+</li>\r
+</ul>\r
+</div>\r
+<div class="summary">\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<!-- =========== FIELD SUMMARY =========== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="field_summary">\r
+<!-- -->\r
+</a>\r
+<h3>フィールドの概要</h3>\r
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="フィールドの概要表、フィールドのリストおよび説明">\r
+<caption><span>フィールド</span><span class="tabEnd"> </span></caption>\r
+<tr>\r
+<th class="colFirst" scope="col">修飾子とタイプ</th>\r
+<th class="colLast" scope="col">フィールドと説明</th>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static java.lang.String</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#ENCLOSES">ENCLOSES</a></strong></code> </td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static java.lang.String</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#INSIDE">INSIDE</a></strong></code>\r
+<div class="block">範囲判定</div>\r
+</td>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static java.lang.String</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#NO_INTERSECTION">NO_INTERSECTION</a></strong></code> </td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static java.lang.String</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#OVERLAP">OVERLAP</a></strong></code> </td>\r
+</tr>\r
+</table>\r
+</li>\r
+</ul>\r
+<!-- ======== CONSTRUCTOR SUMMARY ======== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="constructor_summary">\r
+<!-- -->\r
+</a>\r
+<h3>コンストラクタの概要</h3>\r
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="コンストラクタの概要表、コンストラクタのリストおよび説明">\r
+<caption><span>コンストラクタ</span><span class="tabEnd"> </span></caption>\r
+<tr>\r
+<th class="colOne" scope="col">コンストラクタと説明</th>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colOne"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#ExcelUtil()">ExcelUtil</a></strong>()</code> </td>\r
+</tr>\r
+</table>\r
+</li>\r
+</ul>\r
+<!-- ========== METHOD SUMMARY =========== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="method_summary">\r
+<!-- -->\r
+</a>\r
+<h3>メソッドの概要</h3>\r
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="メソッドの概要表、メソッドのリストおよび説明">\r
+<caption><span>メソッド</span><span class="tabEnd"> </span></caption>\r
+<tr>\r
+<th class="colFirst" scope="col">修飾子とタイプ</th>\r
+<th class="colLast" scope="col">メソッドと説明</th>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static void</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#clearRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, boolean, boolean)">clearRange</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range,\r
+ boolean clearStyle,\r
+ boolean clearMerge)</code>\r
+<div class="block">対象範囲をクリアする</div>\r
+</td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static org.apache.poi.ss.util.CellRangeAddress</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#getIntersectRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">getIntersectRange</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</code>\r
+<div class="block">指定された範囲がシートに収まらない場合、収まるサイズにリサイズした範囲を返却する</div>\r
+</td>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static org.apache.poi.ss.util.CellRangeAddress</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#getIntersectRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.util.CellRangeAddress)">getIntersectRange</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress rangeA,\r
+ org.apache.poi.ss.util.CellRangeAddress rangeB)</code>\r
+<div class="block">指定された範囲の交差する範囲を返却する<br></div>\r
+</td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static java.lang.String</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#getIntersectString(org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.util.CellRangeAddress)">getIntersectString</a></strong>(org.apache.poi.ss.util.CellRangeAddress rangeA,\r
+ org.apache.poi.ss.util.CellRangeAddress rangeB)</code>\r
+<div class="block">指定された範囲の交差状態を定数文字列で返却する<br>
+ ブック、シートは意識しません。</div>\r
+</td>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static int</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#getLastColNum(org.apache.poi.ss.usermodel.Sheet)">getLastColNum</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet)</code>\r
+<div class="block">シートの最大列数を返却</div>\r
+</td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static int</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#getLastColNum(org.apache.poi.ss.usermodel.Sheet, int, int)">getLastColNum</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ int firstRow,\r
+ int lastRow)</code>\r
+<div class="block">シート指定行範囲の最大列数を返却</div>\r
+</td>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static int</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#getMaxColumnIndex(org.apache.poi.ss.usermodel.Sheet)">getMaxColumnIndex</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet)</code>\r
+<div class="block">シートの最大列数を返却</div>\r
+</td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static int</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#getMaxRowIndex(org.apache.poi.ss.usermodel.Sheet)">getMaxRowIndex</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet)</code>\r
+<div class="block">シートの最大行数を返却</div>\r
+</td>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static java.lang.String</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#getMoveFormula(org.apache.poi.ss.usermodel.Sheet, java.lang.String, int, int)">getMoveFormula</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ java.lang.String formula,\r
+ int rowDistance,\r
+ int colDistance)</code>\r
+<div class="block">数式に使用されている相対参照を指定距離で移動した結果を返却<br>
+ 配列数式はPOIの制約上使用できません</div>\r
+</td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static boolean</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#isFullColumnRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">isFullColumnRange</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</code>\r
+<div class="block">列全体を指定している範囲であるかの判定</div>\r
+</td>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static boolean</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#isFullRowRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">isFullRowRange</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</code>\r
+<div class="block">行全体を指定している範囲であるかの判定</div>\r
+</td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static void</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#moveRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, int, int, boolean)">moveRange</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range,\r
+ int rowDistance,\r
+ int colDistance,\r
+ boolean block)</code>\r
+<div class="block">対象範囲を移動する</div>\r
+</td>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static void</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#shift(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, java.lang.String, int)">shift</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range,\r
+ java.lang.String direction,\r
+ int distance)</code>\r
+<div class="block">対象範囲をブロック指定でシフトする</div>\r
+</td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static void</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#shift(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, java.lang.String, int, boolean)">shift</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range,\r
+ java.lang.String direction,\r
+ int distance,\r
+ boolean block)</code>\r
+<div class="block">対象範囲をシフトする</div>\r
+</td>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static boolean</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#validateColumn(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">validateColumn</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</code>\r
+<div class="block">範囲の列方向妥当性チェック</div>\r
+</td>\r
+</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><code>static boolean</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#validateRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">validateRange</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</code>\r
+<div class="block">範囲の妥当性チェック</div>\r
+</td>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static boolean</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html#validateRow(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">validateRow</a></strong>(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</code>\r
+<div class="block">範囲の行方向妥当性チェック</div>\r
+</td>\r
+</tr>\r
+</table>\r
+<ul class="blockList">\r
+<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">\r
+<!-- -->\r
+</a>\r
+<h3>クラスから継承されたメソッド java.lang.Object</h3>\r
+<code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li>\r
+</ul>\r
+</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+</div>\r
+<div class="details">\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<!-- ============ FIELD DETAIL =========== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="field_detail">\r
+<!-- -->\r
+</a>\r
+<h3>フィールドの詳細</h3>\r
+<a name="INSIDE">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>INSIDE</h4>\r
+<pre>public static final java.lang.String INSIDE</pre>\r
+<div class="block">範囲判定</div>\r
+<dl><dt><span class="strong">関連項目:</span></dt><dd><a href="../../../../constant-values.html#org.hanei.jaxcel.util.ExcelUtil.INSIDE">定数フィールド値</a></dd></dl>\r
+</li>\r
+</ul>\r
+<a name="OVERLAP">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>OVERLAP</h4>\r
+<pre>public static final java.lang.String OVERLAP</pre>\r
+<dl><dt><span class="strong">関連項目:</span></dt><dd><a href="../../../../constant-values.html#org.hanei.jaxcel.util.ExcelUtil.OVERLAP">定数フィールド値</a></dd></dl>\r
+</li>\r
+</ul>\r
+<a name="ENCLOSES">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>ENCLOSES</h4>\r
+<pre>public static final java.lang.String ENCLOSES</pre>\r
+<dl><dt><span class="strong">関連項目:</span></dt><dd><a href="../../../../constant-values.html#org.hanei.jaxcel.util.ExcelUtil.ENCLOSES">定数フィールド値</a></dd></dl>\r
+</li>\r
+</ul>\r
+<a name="NO_INTERSECTION">\r
+<!-- -->\r
+</a>\r
+<ul class="blockListLast">\r
+<li class="blockList">\r
+<h4>NO_INTERSECTION</h4>\r
+<pre>public static final java.lang.String NO_INTERSECTION</pre>\r
+<dl><dt><span class="strong">関連項目:</span></dt><dd><a href="../../../../constant-values.html#org.hanei.jaxcel.util.ExcelUtil.NO_INTERSECTION">定数フィールド値</a></dd></dl>\r
+</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+<!-- ========= CONSTRUCTOR DETAIL ======== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="constructor_detail">\r
+<!-- -->\r
+</a>\r
+<h3>コンストラクタの詳細</h3>\r
+<a name="ExcelUtil()">\r
+<!-- -->\r
+</a>\r
+<ul class="blockListLast">\r
+<li class="blockList">\r
+<h4>ExcelUtil</h4>\r
+<pre>public ExcelUtil()</pre>\r
+</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+<!-- ============ METHOD DETAIL ========== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="method_detail">\r
+<!-- -->\r
+</a>\r
+<h3>メソッドの詳細</h3>\r
+<a name="getMaxRowIndex(org.apache.poi.ss.usermodel.Sheet)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>getMaxRowIndex</h4>\r
+<pre>public static int getMaxRowIndex(org.apache.poi.ss.usermodel.Sheet sheet)</pre>\r
+<div class="block">シートの最大行数を返却</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>シートの最大行数</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="getMaxColumnIndex(org.apache.poi.ss.usermodel.Sheet)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>getMaxColumnIndex</h4>\r
+<pre>public static int getMaxColumnIndex(org.apache.poi.ss.usermodel.Sheet sheet)</pre>\r
+<div class="block">シートの最大列数を返却</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>シートの最大行数</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="validateRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>validateRange</h4>\r
+<pre>public static boolean validateRange(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</pre>\r
+<div class="block">範囲の妥当性チェック</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - 対象範囲</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>判定結果</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="validateColumn(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>validateColumn</h4>\r
+<pre>public static boolean validateColumn(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</pre>\r
+<div class="block">範囲の列方向妥当性チェック</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - 対象範囲</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>判定結果</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="validateRow(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>validateRow</h4>\r
+<pre>public static boolean validateRow(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</pre>\r
+<div class="block">範囲の行方向妥当性チェック</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - 対象範囲</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>判定結果</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="isFullRowRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>isFullRowRange</h4>\r
+<pre>public static boolean isFullRowRange(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</pre>\r
+<div class="block">行全体を指定している範囲であるかの判定</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - 対象範囲</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>判定結果</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="isFullColumnRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>isFullColumnRange</h4>\r
+<pre>public static boolean isFullColumnRange(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</pre>\r
+<div class="block">列全体を指定している範囲であるかの判定</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - 対象範囲</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>判定結果</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="getLastColNum(org.apache.poi.ss.usermodel.Sheet)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>getLastColNum</h4>\r
+<pre>public static int getLastColNum(org.apache.poi.ss.usermodel.Sheet sheet)</pre>\r
+<div class="block">シートの最大列数を返却</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>シートの最大列数。<br>
+ sheetに行データが存在しない場合、または、すべての行にセルが存在しない場合は -1</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="getLastColNum(org.apache.poi.ss.usermodel.Sheet, int, int)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>getLastColNum</h4>\r
+<pre>public static int getLastColNum(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ int firstRow,\r
+ int lastRow)</pre>\r
+<div class="block">シート指定行範囲の最大列数を返却</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>firstRow</code> - 範囲始点行番号（０起点）</dd><dd><code>lastRow</code> - 範囲終点行番号（０起点）</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>シート指定列範囲の最大列数。<br>
+ sheetの指定範囲に行データが存在しない場合は -1
+ sheetの指定範囲に行データが存在しない場合、または、指定範囲のすべての行にセルが存在しない場合は -1</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="shift(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, java.lang.String, int)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>shift</h4>\r
+<pre>public static void shift(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range,\r
+ java.lang.String direction,\r
+ int distance)</pre>\r
+<div class="block">対象範囲をブロック指定でシフトする</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - シフト対象範囲</dd><dd><code>direction</code> - シフト方向。row：行方向(デフォルト) col：列方向</dd><dd><code>distance</code> - シフト距離。正数：右・下 負数：左・上</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="shift(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, java.lang.String, int, boolean)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>shift</h4>\r
+<pre>public static void shift(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range,\r
+ java.lang.String direction,\r
+ int distance,\r
+ boolean block)</pre>\r
+<div class="block">対象範囲をシフトする</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - シフト対象範囲</dd><dd><code>direction</code> - シフト方向。row：行方向(デフォルト) col：列方向</dd><dd><code>distance</code> - シフト距離。正数：右・下 負数：左・上</dd><dd><code>block</code> - ブロック指定。true：ブロック指定 false：列・行単位指定</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="getMoveFormula(org.apache.poi.ss.usermodel.Sheet, java.lang.String, int, int)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>getMoveFormula</h4>\r
+<pre>public static java.lang.String getMoveFormula(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ java.lang.String formula,\r
+ int rowDistance,\r
+ int colDistance)</pre>\r
+<div class="block">数式に使用されている相対参照を指定距離で移動した結果を返却<br>
+ 配列数式はPOIの制約上使用できません</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>formula</code> - 数式</dd><dd><code>rowDistance</code> - 行方向移動距離。正数：下 負数：上</dd><dd><code>colDistance</code> - 列方向移動距離。正数：右 負数：左</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>相対参照を指定距離で移動した結果の数式<br>
+ 移動した結果、数式内の参照がシート範囲外を指定したとしてもワークシートとしては異常とならない為、移動距離の妥当性チェックは行わない<br>
+ 配列数式等、POIの制約上解析不可能な数式の場合は引数のまま返却する</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="clearRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, boolean, boolean)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>clearRange</h4>\r
+<pre>public static void clearRange(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range,\r
+ boolean clearStyle,\r
+ boolean clearMerge)</pre>\r
+<div class="block">対象範囲をクリアする</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - 移動対象範囲</dd><dd><code>clearStyle</code> - セルスタイルのクリア指定。trueでスタイルをクリアする</dd><dd><code>clearMerge</code> - セル結合のクリア指定。trueで結合をクリアする</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="getIntersectString(org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.util.CellRangeAddress)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>getIntersectString</h4>\r
+<pre>public static java.lang.String getIntersectString(org.apache.poi.ss.util.CellRangeAddress rangeA,\r
+ org.apache.poi.ss.util.CellRangeAddress rangeB)</pre>\r
+<div class="block">指定された範囲の交差状態を定数文字列で返却する<br>
+ ブック、シートは意識しません。</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>rangeA</code> - 対象範囲Ａ</dd><dd><code>rangeB</code> - 対象範囲Ｂ</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>ExcelUtil.INSIDE：対象範囲Ａに対象範囲Ｂが含まれている<br>
+ ExcelUtil.OVERLAP：対象範囲Ａに対象範囲Ｂの一部が交差している<br>
+ ExcelUtil.ENCLOSES：対象範囲Ｂに対象範囲Ａが含まれている<br>
+ ExcelUtil.NO_INTERSECTION：対象範囲Ａに対象範囲Ｂは一部の含まれていない</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="getIntersectRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>getIntersectRange</h4>\r
+<pre>public static org.apache.poi.ss.util.CellRangeAddress getIntersectRange(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range)</pre>\r
+<div class="block">指定された範囲がシートに収まらない場合、収まるサイズにリサイズした範囲を返却する</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - 対象範囲</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>シートに収まる範囲<br>
+ シートに収まる範囲が存在しない場合はnull</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="getIntersectRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, org.apache.poi.ss.util.CellRangeAddress)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<h4>getIntersectRange</h4>\r
+<pre>public static org.apache.poi.ss.util.CellRangeAddress getIntersectRange(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress rangeA,\r
+ org.apache.poi.ss.util.CellRangeAddress rangeB)</pre>\r
+<div class="block">指定された範囲の交差する範囲を返却する<br></div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>rangeA</code> - 対象範囲Ａ</dd><dd><code>rangeB</code> - 対象範囲Ｂ</dd>\r
+<dt><span class="strong">戻り値:</span></dt><dd>交差する範囲<br>
+ 交差する範囲が存在しない場合はnull</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+<a name="moveRange(org.apache.poi.ss.usermodel.Sheet, org.apache.poi.ss.util.CellRangeAddress, int, int, boolean)">\r
+<!-- -->\r
+</a>\r
+<ul class="blockListLast">\r
+<li class="blockList">\r
+<h4>moveRange</h4>\r
+<pre>public static void moveRange(org.apache.poi.ss.usermodel.Sheet sheet,\r
+ org.apache.poi.ss.util.CellRangeAddress range,\r
+ int rowDistance,\r
+ int colDistance,\r
+ boolean block)</pre>\r
+<div class="block">対象範囲を移動する</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>sheet</code> - Worksheetオブジェクト</dd><dd><code>range</code> - 移動対象範囲</dd><dd><code>rowDistance</code> - 行方向移動距離。正数：下 負数：上</dd><dd><code>colDistance</code> - 列方向移動距離。正数：右 負数：左</dd><dd><code>block</code> - ブロック指定。true：ブロック指定 false：列・行単位指定</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code><a href="../../../../org/hanei/jaxcel/exception/JaxcelInputException.html" title="org.hanei.jaxcel.exception内のクラス">JaxcelInputException</a></code> - 入力例外発生時</dd></dl>\r
+</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+</div>\r
+</div>\r
+<!-- ========= END OF CLASS DATA ========= -->\r
+<!-- ======= START OF BOTTOM NAVBAR ====== -->\r
+<div class="bottomNav"><a name="navbar_bottom">\r
+<!-- -->\r
+</a><a href="#skip-navbar_bottom" title="ナビゲーション・リンクをスキップ"></a><a name="navbar_bottom_firstrow">\r
+<!-- -->\r
+</a>\r
+<ul class="navList" title="ナビゲーション">\r
+<li><a href="../../../../overview-summary.html">概要</a></li>\r
+<li><a href="package-summary.html">パッケージ</a></li>\r
+<li class="navBarCell1Rev">クラス</li>\r
+<li><a href="class-use/ExcelUtil.html">使用</a></li>\r
+<li><a href="package-tree.html">階層ツリー</a></li>\r
+<li><a href="../../../../deprecated-list.html">非推奨</a></li>\r
+<li><a href="../../../../index-files/index-1.html">索引</a></li>\r
+<li><a href="../../../../help-doc.html">ヘルプ</a></li>\r
+</ul>\r
+</div>\r
+<div class="subNav">\r
+<ul class="navList">\r
+<li>前のクラス</li>\r
+<li><a href="../../../../org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">次のクラス</span></a></li>\r
+</ul>\r
+<ul class="navList">\r
+<li><a href="../../../../index.html?org/hanei/jaxcel/util/ExcelUtil.html" target="_top">フレーム</a></li>\r
+<li><a href="ExcelUtil.html" target="_top">フレームなし</a></li>\r
+</ul>\r
+<ul class="navList" id="allclasses_navbar_bottom">\r
+<li><a href="../../../../allclasses-noframe.html">すべてのクラス</a></li>\r
+</ul>\r
+<div>\r
+<script type="text/javascript"><!--\r
+ allClassesLink = document.getElementById("allclasses_navbar_bottom");\r
+ if(window==top) {\r
+ allClassesLink.style.display = "block";\r
+ }\r
+ else {\r
+ allClassesLink.style.display = "none";\r
+ }\r
+ //-->\r
+</script>\r
+</div>\r
+<div>\r
+<ul class="subNavList">\r
+<li>概要: </li>\r
+<li>ネスト | </li>\r
+<li><a href="#field_summary">フィールド</a> | </li>\r
+<li><a href="#constructor_summary">コンストラクタ</a> | </li>\r
+<li><a href="#method_summary">メソッド</a></li>\r
+</ul>\r
+<ul class="subNavList">\r
+<li>詳細: </li>\r
+<li><a href="#field_detail">フィールド</a> | </li>\r
+<li><a href="#constructor_detail">コンストラクタ</a> | </li>\r
+<li><a href="#method_detail">メソッド</a></li>\r
+</ul>\r
+</div>\r
+<a name="skip-navbar_bottom">\r
+<!-- -->\r
+</a></div>\r
+<!-- ======== END OF BOTTOM NAVBAR ======= -->\r
+</body>\r
+</html>\r
--- /dev/null
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r
+<!-- NewPage -->\r
+<html lang="ja">\r
+<head>\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
+<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
+<title>MakeReportTool</title>\r
+<meta name="date" content="2014-09-01">\r
+<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
+</head>\r
+<body>\r
+<script type="text/javascript"><!--\r
+ if (location.href.indexOf('is-external=true') == -1) {\r
+ parent.document.title="MakeReportTool";\r
+ }\r
+//-->\r
+</script>\r
+<noscript>\r
+<div>ブラウザのJavaScriptが無効になっています。</div>\r
+</noscript>\r
+<!-- ========= START OF TOP NAVBAR ======= -->\r
+<div class="topNav"><a name="navbar_top">\r
+<!-- -->\r
+</a><a href="#skip-navbar_top" title="ナビゲーション・リンクをスキップ"></a><a name="navbar_top_firstrow">\r
+<!-- -->\r
+</a>\r
+<ul class="navList" title="ナビゲーション">\r
+<li><a href="../../../../overview-summary.html">概要</a></li>\r
+<li><a href="package-summary.html">パッケージ</a></li>\r
+<li class="navBarCell1Rev">クラス</li>\r
+<li><a href="class-use/MakeReportTool.html">使用</a></li>\r
+<li><a href="package-tree.html">階層ツリー</a></li>\r
+<li><a href="../../../../deprecated-list.html">非推奨</a></li>\r
+<li><a href="../../../../index-files/index-1.html">索引</a></li>\r
+<li><a href="../../../../help-doc.html">ヘルプ</a></li>\r
+</ul>\r
+</div>\r
+<div class="subNav">\r
+<ul class="navList">\r
+<li><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">前のクラス</span></a></li>\r
+<li>次のクラス</li>\r
+</ul>\r
+<ul class="navList">\r
+<li><a href="../../../../index.html?org/hanei/jaxcel/util/MakeReportTool.html" target="_top">フレーム</a></li>\r
+<li><a href="MakeReportTool.html" target="_top">フレームなし</a></li>\r
+</ul>\r
+<ul class="navList" id="allclasses_navbar_top">\r
+<li><a href="../../../../allclasses-noframe.html">すべてのクラス</a></li>\r
+</ul>\r
+<div>\r
+<script type="text/javascript"><!--\r
+ allClassesLink = document.getElementById("allclasses_navbar_top");\r
+ if(window==top) {\r
+ allClassesLink.style.display = "block";\r
+ }\r
+ else {\r
+ allClassesLink.style.display = "none";\r
+ }\r
+ //-->\r
+</script>\r
+</div>\r
+<div>\r
+<ul class="subNavList">\r
+<li>概要: </li>\r
+<li>ネスト | </li>\r
+<li>フィールド | </li>\r
+<li><a href="#constructor_summary">コンストラクタ</a> | </li>\r
+<li><a href="#method_summary">メソッド</a></li>\r
+</ul>\r
+<ul class="subNavList">\r
+<li>詳細: </li>\r
+<li>フィールド | </li>\r
+<li><a href="#constructor_detail">コンストラクタ</a> | </li>\r
+<li><a href="#method_detail">メソッド</a></li>\r
+</ul>\r
+</div>\r
+<a name="skip-navbar_top">\r
+<!-- -->\r
+</a></div>\r
+<!-- ========= END OF TOP NAVBAR ========= -->\r
+<!-- ======== START OF CLASS DATA ======== -->\r
+<div class="header">\r
+<div class="subTitle">org.hanei.jaxcel.util</div>\r
+<h2 title="クラス MakeReportTool" class="title">クラス MakeReportTool</h2>\r
+</div>\r
+<div class="contentContainer">\r
+<ul class="inheritance">\r
+<li>java.lang.Object</li>\r
+<li>\r
+<ul class="inheritance">\r
+<li>org.hanei.jaxcel.util.MakeReportTool</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+<div class="description">\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<hr>\r
+<br>\r
+<pre>public class <span class="strong">MakeReportTool</span>\r
+extends java.lang.Object</pre>\r
+</li>\r
+</ul>\r
+</div>\r
+<div class="summary">\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<!-- ======== CONSTRUCTOR SUMMARY ======== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="constructor_summary">\r
+<!-- -->\r
+</a>\r
+<h3>コンストラクタの概要</h3>\r
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="コンストラクタの概要表、コンストラクタのリストおよび説明">\r
+<caption><span>コンストラクタ</span><span class="tabEnd"> </span></caption>\r
+<tr>\r
+<th class="colOne" scope="col">コンストラクタと説明</th>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colOne"><code><strong><a href="../../../../org/hanei/jaxcel/util/MakeReportTool.html#MakeReportTool()">MakeReportTool</a></strong>()</code> </td>\r
+</tr>\r
+</table>\r
+</li>\r
+</ul>\r
+<!-- ========== METHOD SUMMARY =========== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="method_summary">\r
+<!-- -->\r
+</a>\r
+<h3>メソッドの概要</h3>\r
+<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="メソッドの概要表、メソッドのリストおよび説明">\r
+<caption><span>メソッド</span><span class="tabEnd"> </span></caption>\r
+<tr>\r
+<th class="colFirst" scope="col">修飾子とタイプ</th>\r
+<th class="colLast" scope="col">メソッドと説明</th>\r
+</tr>\r
+<tr class="altColor">\r
+<td class="colFirst"><code>static void</code></td>\r
+<td class="colLast"><code><strong><a href="../../../../org/hanei/jaxcel/util/MakeReportTool.html#main(java.lang.String[])">main</a></strong>(java.lang.String[] args)</code>\r
+<div class="block">ExcelテンプレートファイルにJSONファイルのデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。</div>\r
+</td>\r
+</tr>\r
+</table>\r
+<ul class="blockList">\r
+<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">\r
+<!-- -->\r
+</a>\r
+<h3>クラスから継承されたメソッド java.lang.Object</h3>\r
+<code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li>\r
+</ul>\r
+</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+</div>\r
+<div class="details">\r
+<ul class="blockList">\r
+<li class="blockList">\r
+<!-- ========= CONSTRUCTOR DETAIL ======== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="constructor_detail">\r
+<!-- -->\r
+</a>\r
+<h3>コンストラクタの詳細</h3>\r
+<a name="MakeReportTool()">\r
+<!-- -->\r
+</a>\r
+<ul class="blockListLast">\r
+<li class="blockList">\r
+<h4>MakeReportTool</h4>\r
+<pre>public MakeReportTool()</pre>\r
+</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+<!-- ============ METHOD DETAIL ========== -->\r
+<ul class="blockList">\r
+<li class="blockList"><a name="method_detail">\r
+<!-- -->\r
+</a>\r
+<h3>メソッドの詳細</h3>\r
+<a name="main(java.lang.String[])">\r
+<!-- -->\r
+</a>\r
+<ul class="blockListLast">\r
+<li class="blockList">\r
+<h4>main</h4>\r
+<pre>public static void main(java.lang.String[] args)\r
+ throws java.lang.Exception</pre>\r
+<div class="block">ExcelテンプレートファイルにJSONファイルのデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。</div>\r
+<dl><dt><span class="strong">パラメータ:</span></dt><dd><code>args</code> - arg1: Excelテンプレートファイルパス<br>
+ arg2: パラメータJSONファイルパス<br>
+ arg3: Excel帳票出力ファイルパス</dd>\r
+<dt><span class="strong">例外:</span></dt>\r
+<dd><code>java.lang.Exception</code></dd></dl>\r
+</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+</li>\r
+</ul>\r
+</div>\r
+</div>\r
+<!-- ========= END OF CLASS DATA ========= -->\r
+<!-- ======= START OF BOTTOM NAVBAR ====== -->\r
+<div class="bottomNav"><a name="navbar_bottom">\r
+<!-- -->\r
+</a><a href="#skip-navbar_bottom" title="ナビゲーション・リンクをスキップ"></a><a name="navbar_bottom_firstrow">\r
+<!-- -->\r
+</a>\r
+<ul class="navList" title="ナビゲーション">\r
+<li><a href="../../../../overview-summary.html">概要</a></li>\r
+<li><a href="package-summary.html">パッケージ</a></li>\r
+<li class="navBarCell1Rev">クラス</li>\r
+<li><a href="class-use/MakeReportTool.html">使用</a></li>\r
+<li><a href="package-tree.html">階層ツリー</a></li>\r
+<li><a href="../../../../deprecated-list.html">非推奨</a></li>\r
+<li><a href="../../../../index-files/index-1.html">索引</a></li>\r
+<li><a href="../../../../help-doc.html">ヘルプ</a></li>\r
+</ul>\r
+</div>\r
+<div class="subNav">\r
+<ul class="navList">\r
+<li><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">前のクラス</span></a></li>\r
+<li>次のクラス</li>\r
+</ul>\r
+<ul class="navList">\r
+<li><a href="../../../../index.html?org/hanei/jaxcel/util/MakeReportTool.html" target="_top">フレーム</a></li>\r
+<li><a href="MakeReportTool.html" target="_top">フレームなし</a></li>\r
+</ul>\r
+<ul class="navList" id="allclasses_navbar_bottom">\r
+<li><a href="../../../../allclasses-noframe.html">すべてのクラス</a></li>\r
+</ul>\r
+<div>\r
+<script type="text/javascript"><!--\r
+ allClassesLink = document.getElementById("allclasses_navbar_bottom");\r
+ if(window==top) {\r
+ allClassesLink.style.display = "block";\r
+ }\r
+ else {\r
+ allClassesLink.style.display = "none";\r
+ }\r
+ //-->\r
+</script>\r
+</div>\r
+<div>\r
+<ul class="subNavList">\r
+<li>概要: </li>\r
+<li>ネスト | </li>\r
+<li>フィールド | </li>\r
+<li><a href="#constructor_summary">コンストラクタ</a> | </li>\r
+<li><a href="#method_summary">メソッド</a></li>\r
+</ul>\r
+<ul class="subNavList">\r
+<li>詳細: </li>\r
+<li>フィールド | </li>\r
+<li><a href="#constructor_detail">コンストラクタ</a> | </li>\r
+<li><a href="#method_detail">メソッド</a></li>\r
+</ul>\r
+</div>\r
+<a name="skip-navbar_bottom">\r
+<!-- -->\r
+</a></div>\r
+<!-- ======== END OF BOTTOM NAVBAR ======= -->\r
+</body>\r
+</html>\r
--- /dev/null
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r
+<!-- NewPage -->\r
+<html lang="ja">\r
+<head>\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
+<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
+<title>クラス org.hanei.jaxcel.util.ExcelUtilの使用</title>\r
+<meta name="date" content="2014-09-01">\r
+<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">\r
+</head>\r
+<body>\r
+<script type="text/javascript"><!--\r
+ if (location.href.indexOf('is-external=true') == -1) {\r
+ parent.document.title="クラス org.hanei.jaxcel.util.ExcelUtilの使用";\r
+ }\r
+//-->\r
+</script>\r
+<noscript>\r
+<div>ブラウザのJavaScriptが無効になっています。</div>\r
+</noscript>\r
+<!-- ========= START OF TOP NAVBAR ======= -->\r
+<div class="topNav"><a name="navbar_top">\r
+<!-- -->\r
+</a><a href="#skip-navbar_top" title="ナビゲーション・リンクをスキップ"></a><a name="navbar_top_firstrow">\r
+<!-- -->\r
+</a>\r
+<ul class="navList" title="ナビゲーション">\r
+<li><a href="../../../../../overview-summary.html">概要</a></li>\r
+<li><a href="../package-summary.html">パッケージ</a></li>\r
+<li><a href="../../../../../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">クラス</a></li>\r
+<li class="navBarCell1Rev">使用</li>\r
+<li><a href="../package-tree.html">階層ツリー</a></li>\r
+<li><a href="../../../../../deprecated-list.html">非推奨</a></li>\r
+<li><a href="../../../../../index-files/index-1.html">索引</a></li>\r
+<li><a href="../../../../../help-doc.html">ヘルプ</a></li>\r
+</ul>\r
+</div>\r
+<div class="subNav">\r
+<ul class="navList">\r
+<li>前</li>\r
+<li>次</li>\r
+</ul>\r
+<ul class="navList">\r
+<li><a href="../../../../../index.html?org/hanei/jaxcel/util/class-use/ExcelUtil.html" target="_top">フレーム</a></li>\r
+<li><a href="ExcelUtil.html" target="_top">フレームなし</a></li>\r
+</ul>\r
+<ul class="navList" id="allclasses_navbar_top">\r
+<li><a href="../../../../../allclasses-noframe.html">すべてのクラス</a></li>\r
+</ul>\r
+<div>\r
+<script type="text/javascript"><!--\r
+ allClassesLink = document.getElementById("allclasses_navbar_top");\r
+ if(window==top) {\r
+ allClassesLink.style.display = "block";\r
+ }\r
+ else {\r
+ allClassesLink.style.display = "none";\r
+ }\r
+ //-->\r
+</script>\r
+</div>\r
+<a name="skip-navbar_top">\r
+<!-- -->\r
+</a></div>\r
+<!-- ========= END OF TOP NAVBAR ========= -->\r
+<div class="header">\r
+<h2 title="クラス org.hanei.jaxcel.util.ExcelUtilの使用" class="title">クラス<br>org.hanei.jaxcel.util.ExcelUtilの使用</h2>\r
+</div>\r
+<div class="classUseContainer">org.hanei.jaxcel.util.ExcelUtilはどこからも使用されていません</div>\r
+<!-- ======= START OF BOTTOM NAVBAR ====== -->\r
+<div class="bottomNav"><a name="navbar_bottom">\r
+<!-- -->\r
+</a><a href="#skip-navbar_bottom" title="ナビゲーション・リンクをスキップ"></a><a name="navbar_bottom_firstrow">\r
+<!-- -->\r
+</a>\r
+<ul class="navList" title="ナビゲーション">\r
+<li><a href="../../../../../overview-summary.html">概要</a></li>\r
+<li><a href="../package-summary.html">パッケージ</a></li>\r
+<li><a href="../../../../../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">クラス</a></li>\r
+<li class="navBarCell1Rev">使用</li>\r
+<li><a href="../package-tree.html">階層ツリー</a></li>\r
+<li><a href="../../../../../deprecated-list.html">非推奨</a></li>\r
+<li><a href="../../../../../index-files/index-1.html">索引</a></li>\r
+<li><a href="../../../../../help-doc.html">ヘルプ</a></li>\r
+</ul>\r
+</div>\r
+<div class="subNav">\r
+<ul class="navList">\r
+<li>前</li>\r
+<li>次</li>\r
+</ul>\r
+<ul class="navList">\r
+<li><a href="../../../../../index.html?org/hanei/jaxcel/util/class-use/ExcelUtil.html" target="_top">フレーム</a></li>\r
+<li><a href="ExcelUtil.html" target="_top">フレームなし</a></li>\r
+</ul>\r
+<ul class="navList" id="allclasses_navbar_bottom">\r
+<li><a href="../../../../../allclasses-noframe.html">すべてのクラス</a></li>\r
+</ul>\r
+<div>\r
+<script type="text/javascript"><!--\r
+ allClassesLink = document.getElementById("allclasses_navbar_bottom");\r
+ if(window==top) {\r
+ allClassesLink.style.display = "block";\r
+ }\r
+ else {\r
+ allClassesLink.style.display = "none";\r
+ }\r
+ //-->\r
+</script>\r
+</div>\r
+<a name="skip-navbar_bottom">\r
+<!-- -->\r
+</a></div>\r
+<!-- ======== END OF BOTTOM NAVBAR ======= -->\r
+</body>\r
+</html>\r
--- /dev/null
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">\r
+<!-- NewPage -->\r
+<html lang="ja">\r
+<head>\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
+<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
+<title>クラス org.hanei.jaxcel.util.MakeReportToolの使用</title>\r
+<meta name="date" content="2014-09-01">\r
+<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">\r
+</head>\r
+<body>\r
+<script type="text/javascript"><!--\r
+ if (location.href.indexOf('is-external=true') == -1) {\r
+ parent.document.title="クラス org.hanei.jaxcel.util.MakeReportToolの使用";\r
+ }\r
+//-->\r
+</script>\r
+<noscript>\r
+<div>ブラウザのJavaScriptが無効になっています。</div>\r
+</noscript>\r
+<!-- ========= START OF TOP NAVBAR ======= -->\r
+<div class="topNav"><a name="navbar_top">\r
+<!-- -->\r
+</a><a href="#skip-navbar_top" title="ナビゲーション・リンクをスキップ"></a><a name="navbar_top_firstrow">\r
+<!-- -->\r
+</a>\r
+<ul class="navList" title="ナビゲーション">\r
+<li><a href="../../../../../overview-summary.html">概要</a></li>\r
+<li><a href="../package-summary.html">パッケージ</a></li>\r
+<li><a href="../../../../../org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス">クラス</a></li>\r
+<li class="navBarCell1Rev">使用</li>\r
+<li><a href="../package-tree.html">階層ツリー</a></li>\r
+<li><a href="../../../../../deprecated-list.html">非推奨</a></li>\r
+<li><a href="../../../../../index-files/index-1.html">索引</a></li>\r
+<li><a href="../../../../../help-doc.html">ヘルプ</a></li>\r
+</ul>\r
+</div>\r
+<div class="subNav">\r
+<ul class="navList">\r
+<li>前</li>\r
+<li>次</li>\r
+</ul>\r
+<ul class="navList">\r
+<li><a href="../../../../../index.html?org/hanei/jaxcel/util/class-use/MakeReportTool.html" target="_top">フレーム</a></li>\r
+<li><a href="MakeReportTool.html" target="_top">フレームなし</a></li>\r
+</ul>\r
+<ul class="navList" id="allclasses_navbar_top">\r
+<li><a href="../../../../../allclasses-noframe.html">すべてのクラス</a></li>\r
+</ul>\r
+<div>\r
+<script type="text/javascript"><!--\r
+ allClassesLink = document.getElementById("allclasses_navbar_top");\r
+ if(window==top) {\r
+ allClassesLink.style.display = "block";\r
+ }\r
+ else {\r
+ allClassesLink.style.display = "none";\r
+ }\r
+ //-->\r
+</script>\r
+</div>\r
+<a name="skip-navbar_top">\r
+<!-- -->\r
+</a></div>\r
+<!-- ========= END OF TOP NAVBAR ========= -->\r
+<div class="header">\r
+<h2 title="クラス org.hanei.jaxcel.util.MakeReportToolの使用" class="title">クラス<br>org.hanei.jaxcel.util.MakeReportToolの使用</h2>\r
+</div>\r
+<div class="classUseContainer">org.hanei.jaxcel.util.MakeReportToolはどこからも使用されていません</div>\r
+<!-- ======= START OF BOTTOM NAVBAR ====== -->\r
+<div class="bottomNav"><a name="navbar_bottom">\r
+<!-- -->\r
+</a><a href="#skip-navbar_bottom" title="ナビゲーション・リンクをスキップ"></a><a name="navbar_bottom_firstrow">\r
+<!-- -->\r
+</a>\r
+<ul class="navList" title="ナビゲーション">\r
+<li><a href="../../../../../overview-summary.html">概要</a></li>\r
+<li><a href="../package-summary.html">パッケージ</a></li>\r
+<li><a href="../../../../../org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス">クラス</a></li>\r
+<li class="navBarCell1Rev">使用</li>\r
+<li><a href="../package-tree.html">階層ツリー</a></li>\r
+<li><a href="../../../../../deprecated-list.html">非推奨</a></li>\r
+<li><a href="../../../../../index-files/index-1.html">索引</a></li>\r
+<li><a href="../../../../../help-doc.html">ヘルプ</a></li>\r
+</ul>\r
+</div>\r
+<div class="subNav">\r
+<ul class="navList">\r
+<li>前</li>\r
+<li>次</li>\r
+</ul>\r
+<ul class="navList">\r
+<li><a href="../../../../../index.html?org/hanei/jaxcel/util/class-use/MakeReportTool.html" target="_top">フレーム</a></li>\r
+<li><a href="MakeReportTool.html" target="_top">フレームなし</a></li>\r
+</ul>\r
+<ul class="navList" id="allclasses_navbar_bottom">\r
+<li><a href="../../../../../allclasses-noframe.html">すべてのクラス</a></li>\r
+</ul>\r
+<div>\r
+<script type="text/javascript"><!--\r
+ allClassesLink = document.getElementById("allclasses_navbar_bottom");\r
+ if(window==top) {\r
+ allClassesLink.style.display = "block";\r
+ }\r
+ else {\r
+ allClassesLink.style.display = "none";\r
+ }\r
+ //-->\r
+</script>\r
+</div>\r
+<a name="skip-navbar_bottom">\r
+<!-- -->\r
+</a></div>\r
+<!-- ======== END OF BOTTOM NAVBAR ======= -->\r
+</body>\r
+</html>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>org.hanei.jaxcel.util</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<div class="indexContainer">\r
<h2 title="クラス">クラス</h2>\r
<ul title="クラス">\r
-<li><a href="JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス" target="classFrame">JaxcelUtil</a></li>\r
+<li><a href="ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス" target="classFrame">ExcelUtil</a></li>\r
+<li><a href="MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス" target="classFrame">MakeReportTool</a></li>\r
</ul>\r
</div>\r
</body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>org.hanei.jaxcel.util</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
</tr>\r
<tbody>\r
<tr class="altColor">\r
-<td class="colFirst"><a href="../../../../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス">JaxcelUtil</a></td>\r
+<td class="colFirst"><a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス">ExcelUtil</a></td>\r
<td class="colLast">\r
<div class="block">Excelユーティリティクラス</div>\r
</td>\r
</tr>\r
+<tr class="rowColor">\r
+<td class="colFirst"><a href="../../../../org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス">MakeReportTool</a></td>\r
+<td class="colLast"> </td>\r
+</tr>\r
</tbody>\r
</table>\r
</li>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>org.hanei.jaxcel.util クラス階層</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<ul>\r
<li type="circle">java.lang.Object\r
<ul>\r
-<li type="circle">org.hanei.jaxcel.util.<a href="../../../../org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">JaxcelUtil</span></a></li>\r
+<li type="circle">org.hanei.jaxcel.util.<a href="../../../../org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">ExcelUtil</span></a></li>\r
+<li type="circle">org.hanei.jaxcel.util.<a href="../../../../org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">MakeReportTool</span></a></li>\r
</ul>\r
</li>\r
</ul>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>パッケージ org.hanei.jaxcel.utilの使用</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>概要リスト</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>概要</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">\r
</head>\r
<body>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:36 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>クラス階層</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">\r
</head>\r
<body>\r
<li type="circle">java.lang.Object\r
<ul>\r
<li type="circle">org.hanei.jaxcel.report.<a href="org/hanei/jaxcel/report/ELManager.html" title="org.hanei.jaxcel.report内のクラス"><span class="strong">ELManager</span></a></li>\r
+<li type="circle">org.hanei.jaxcel.util.<a href="org/hanei/jaxcel/util/ExcelUtil.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">ExcelUtil</span></a></li>\r
<li type="circle">org.hanei.jaxcel.report.<a href="org/hanei/jaxcel/report/JaxcelContext.html" title="org.hanei.jaxcel.report内のクラス"><span class="strong">JaxcelContext</span></a></li>\r
-<li type="circle">org.hanei.jaxcel.util.<a href="org/hanei/jaxcel/util/JaxcelUtil.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">JaxcelUtil</span></a></li>\r
+<li type="circle">org.hanei.jaxcel.util.<a href="org/hanei/jaxcel/util/MakeReportTool.html" title="org.hanei.jaxcel.util内のクラス"><span class="strong">MakeReportTool</span></a></li>\r
<li type="circle">org.hanei.jaxcel.report.<a href="org/hanei/jaxcel/report/ReportMaker.html" title="org.hanei.jaxcel.report内のクラス"><span class="strong">ReportMaker</span></a></li>\r
<li type="circle">java.lang.Throwable (implements java.io.Serializable)\r
<ul>\r
<!-- NewPage -->\r
<html lang="ja">\r
<head>\r
-<!-- Generated by javadoc (version 1.7.0_25) on Mon Aug 11 01:10:35 JST 2014 -->\r
+<!-- Generated by javadoc (version 1.7.0_25) on Mon Sep 01 02:16:30 JST 2014 -->\r
<meta http-equiv="Content-Type" content="text/html" charset="utf-8">\r
<title>直列化された形式</title>\r
-<meta name="date" content="2014-08-11">\r
+<meta name="date" content="2014-09-01">\r
<link rel="stylesheet" type="text/css" href="stylesheet.css" title="Style">\r
</head>\r
<body>\r
+++ /dev/null
-{
- "hello1": "hello jaxcel!",
- "hello2": "hello hello jaxcel!"
-}
\ No newline at end of file
--- /dev/null
+java -classpath ..\..\build;..\..\lib\* org.hanei.jaxcel.util.MakeReportTool "../resources/array_example.xlsx" "../resources/array_example.json" "../output/array_example_result.xlsx"
+pause
+EXIT /b 0
--- /dev/null
+java -classpath ..\..\build;..\..\lib\* org.hanei.jaxcel.util.MakeReportTool "../resources/map_example.xlsx" "../resources/map_example.json" "../output/map_example_result.xlsx"
+pause
+EXIT /b 0
--- /dev/null
+java -classpath ..\..\build;..\..\lib\* org.hanei.jaxcel.util.MakeReportTool "../resources/simple_EL_example.xlsx" "../resources/simple_EL_example.json" "../output/simple_EL_example_result.xlsx"
+pause
+EXIT /b 0
--- /dev/null
+java -classpath ..\..\build;..\..\lib\* org.hanei.jaxcel.util.MakeReportTool "../resources/simple_EL_example.xls" "../resources/simple_EL_example.json" "../output/simple_EL_example_result.xls"
+pause
+EXIT /b 0
--- /dev/null
+java -classpath ..\..\build;..\..\lib\* org.hanei.jaxcel.util.MakeReportTool "../resources/simple_EL_example.xlsx" "../resources/simple_EL_example.json" "../output/simple_EL_example_result.xlsx"
+pause
+EXIT /b 0
--- /dev/null
+java -classpath ..\..\build;..\..\lib\* org.hanei.jaxcel.util.MakeReportTool "../resources/simple_table_example.xlsx" "../resources/simple_table_example.json" "../output/simple_table_example_result.xlsx"
+pause
+EXIT /b 0
--- /dev/null
+{
+ "arrayData": ["HELLO", "JAXCEL!!", 100, 200, 300, 400, 500]
+}
\ No newline at end of file
--- /dev/null
+{
+ "mapData": {
+ "dataA": "HELLO",
+ "dataB": "JAXCEL!!",
+ "dataC": 100,
+ "dataD": 200,
+ "dataE": 300,
+ "dataF": 400,
+ "dataG": "日本語"
+ }
+}
\ No newline at end of file
--- /dev/null
+{
+ "data1": "hello",
+ "data2": "jaxcel!"
+}
\ No newline at end of file
--- /dev/null
+{
+ "tableData": [
+ {"data1": "aaa", "data2": 1, "data3": "2014-01-01", "data4": "00:00", "data5": "2014-01-01 00:00"},
+ {"data1": "bbb", "data2": 2, "data3": "2014-01-02", "data4": "01:10", "data5": "2014-02-03 01:15"},
+ {"data1": "ccc", "data2": 3, "data3": "2014-02-01", "data4": "04:30", "data5": "2014-03-11 06:30"},
+ {"data1": "ddd", "data2": 4, "data3": "2014-02-10", "data4": "20:00", "data5": "2014-06-21 12:00"},
+ {"data1": "日本語", "data2": 5, "data3": "2014-03-20", "data4": "23:59", "data5": "2014-12-31 15:35"}
+ ]
+}
\ No newline at end of file
--- /dev/null
+<?xml version="1.0" encoding="UTF-8"?>
+<Configuration status="WARN">
+ <Appenders>
+ <File name="File" fileName="../log/jaxcel.log">
+ <PatternLayout>
+ <Pattern>%d [%-5p] (%-15.15c{1}:%-15.15M:%5.5L) %m%n</Pattern>
+ </PatternLayout>
+ </File>
+ </Appenders>
+
+ <Loggers>
+ <Root level="debug">
+ <AppenderRef ref="File"/>
+ </Root>
+ </Loggers>
+</Configuration>
\ No newline at end of file
package org.hanei.jaxcel.report;\r
\r
import java.io.File;\r
+import java.io.FileOutputStream;\r
import java.io.IOException;\r
import java.io.InputStream;\r
import java.io.OutputStream;\r
\r
log.trace("makeReport end");\r
}\r
+\r
+ /**\r
+ * 入力ストリームのExcelテンプレートファイルにデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。<br>\r
+ * 入力ストリームは別途クローズが必要。\r
+ * \r
+ * @param template Excelテンプレートファイル入力ストリーム\r
+ * @param parameter テンプレートに挿入するデータ\r
+ * @param output Excel帳票出力ファイル\r
+ *\r
+ * @throws JaxcelInputException 入力例外発生時\r
+ * @throws JaxcelOutputException 出力例外発生時\r
+ */\r
+ public void makeReport(InputStream template, Map<String, Object> parameter, File output) {\r
+ log.trace("makeReport start");\r
+ \r
+ // Excel帳票生成\r
+ Workbook book = makeReport(template, parameter);\r
+ \r
+ // 出力ストリーム\r
+ FileOutputStream _output;\r
+ try {\r
+ _output = new FileOutputStream(output);\r
+ }\r
+ catch(Exception e) {\r
+ log.error("output file open error: {}", e.getMessage(), e);\r
+ throw new JaxcelOutputException("output file open error");\r
+ }\r
+\r
+ // 出力\r
+ outputReport(book, _output);\r
+ try {\r
+ _output.close();\r
+ } catch (IOException e) {\r
+ log.error("output file close error: {}", e.getMessage(), e);\r
+ throw new JaxcelOutputException("output file close error");\r
+ }\r
+\r
+ // テンプレートファイルクローズ\r
+ close();\r
+\r
+ log.trace("makeReport end");\r
+ }\r
\r
/**\r
* Excelテンプレートファイルにデータを挿入することでExcel帳票を生成、Workbookオブジェクトを返却する。<br>\r
\r
log.trace("makeReport end");\r
}\r
+\r
+ /**\r
+ * Excelテンプレートファイルにデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。<br>\r
+ * \r
+ * @param template Excelテンプレートファイル\r
+ * @param parameter テンプレートに挿入するデータ\r
+ * @param output Excel帳票出力ファイル\r
+ * \r
+ * @throws JaxcelInputException 入力例外発生時\r
+ * @throws JaxcelOutputException 出力例外発生時\r
+ */\r
+ public void makeReport(File template, Map<String, Object> parameter, File output) {\r
+ log.trace("makeReport start");\r
+\r
+ // Workbook生成\r
+ Workbook book = makeReport(template, parameter);\r
+\r
+ // 出力ストリーム\r
+ FileOutputStream _output;\r
+ try {\r
+ _output = new FileOutputStream(output);\r
+ }\r
+ catch(Exception e) {\r
+ log.error("output file open error: {}", e.getMessage(), e);\r
+ throw new JaxcelOutputException("output file open error");\r
+ }\r
+\r
+ // 出力\r
+ outputReport(book, _output);\r
+ try {\r
+ _output.close();\r
+ } catch (IOException e) {\r
+ log.error("output file close error: {}", e.getMessage(), e);\r
+ throw new JaxcelOutputException("output file close error");\r
+ }\r
+ \r
+ // テンプレートファイルクローズ\r
+ close();\r
+\r
+ log.trace("makeReport end");\r
+ }\r
\r
/**\r
* ExcelテンプレートのWorkbookオブジェクトにデータを挿入することでExcel帳票を生成する。<br>\r
import java.text.ParseException;
import java.util.ArrayList;
+import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import org.apache.poi.xssf.usermodel.XSSFDrawing;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.hanei.jaxcel.exception.JaxcelInputException;
-import org.hanei.jaxcel.util.JaxcelUtil;
+import org.hanei.jaxcel.util.ExcelUtil;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTDrawing;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTMarker;
import org.openxmlformats.schemas.drawingml.x2006.spreadsheetDrawing.CTTwoCellAnchor;
}
}
}
- // newCellValが空白なら
+ // newCellValが空白
else {
+ cell.setCellType(Cell.CELL_TYPE_BLANK);
// 再パースフラグクリア
reParseFlg = false;
}
Cell cell, toCell;
Object evalObject;
Object listObject;
+ Object[] mapKeys = null;
int listSize;
ArrayList<CellRangeAddress> rangeList = new ArrayList<>();
CellRangeAddress fromRange, toRange, tmpBfRange, tmpAfRange;
}
log.debug("list class: {}", listObject.getClass().getName());
+ // listObject Mapならキー取得
+ if(listObject instanceof Map) {
+ mapKeys = ((Map<?, ?>)listObject).keySet().toArray();
+ }
+
// listのサイズ取得
evalObject = elMgr.evaluate("size(" + list + ")");
// evalした結果がintでなければリスト不可なオブジェクトと判断
}
// 繰返し方向縦（行）の場合
else {
- fromRange = new CellRangeAddress(startRowIdx, startRowIdx + rowSpan - 1, 0, JaxcelUtil.getLastColNum(sheet));
+ fromRange = new CellRangeAddress(startRowIdx, startRowIdx + rowSpan - 1, 0, ExcelUtil.getLastColNum(sheet));
}
}
else {
fromRange = new CellRangeAddress(startRowIdx, startRowIdx + rowSpan - 1, startColIdx, startColIdx + colSpan - 1);
}
// シートに収まる範囲にリサイズ
- fromRange = JaxcelUtil.getIntersectRange(sheet, fromRange);
+ fromRange = ExcelUtil.getIntersectRange(sheet, fromRange);
// 繰返しコピー回数１以上なら
if(startIdx != endIdx) {
if(COL.equalsIgnoreCase(direction)) {
distance *= colSpan;
// 繰返し範囲以降をずらす
- JaxcelUtil.shift(sheet, new CellRangeAddress(fromRange.getFirstRow(), fromRange.getLastRow(), fromRange.getLastColumn() + 1, fromRange.getLastColumn() + 1), COL, distance, block);
+ ExcelUtil.shift(sheet, new CellRangeAddress(fromRange.getFirstRow(), fromRange.getLastRow(), fromRange.getLastColumn() + 1, fromRange.getLastColumn() + 1), COL, distance, block);
}
// 繰返し方向縦（行）の場合
else {
distance *= rowSpan;
// 繰返し範囲以降をずらす
- JaxcelUtil.shift(sheet, new CellRangeAddress(fromRange.getLastRow() + 1, fromRange.getLastRow() + 1, fromRange.getFirstColumn(), fromRange.getLastColumn()), ROW, distance, block);
+ ExcelUtil.shift(sheet, new CellRangeAddress(fromRange.getLastRow() + 1, fromRange.getLastRow() + 1, fromRange.getFirstColumn(), fromRange.getLastColumn()), ROW, distance, block);
}
}
// shift:falseの場合、コピー先範囲をクリア
else {
- JaxcelUtil.clearRange(sheet, toRange, COPY.equalsIgnoreCase(style), true);
+ ExcelUtil.clearRange(sheet, toRange, COPY.equalsIgnoreCase(style), true);
}
// style:copyの場合、コピー元範囲の結合保持・解除
if(COPY.equalsIgnoreCase(style)) {
}
// コピー元範囲を繰返しコピー
- int cpCount = 0;
- boolean contFlag;
// 範囲行でループ
for(int r = fromRange.getFirstRow(); r <= fromRange.getLastRow(); r++) {
row = sheet.getRow(r);
}
// 繰返し回数でループ
- cpCount = 0; // コピー実施回数のクリア
- for(int i = startIdx; (startIdx <= endIdx && i <= endIdx || startIdx > endIdx && i >= endIdx); i = (startIdx <= endIdx ? i + 1 : i - 1)) {
- contFlag = false;
-
+ for(int i = startIdx, cpCount = 0; (startIdx <= endIdx && i <= endIdx || startIdx > endIdx && i >= endIdx); i = (startIdx <= endIdx ? i + 1 : i - 1), cpCount++) {
// 繰返し方向横（列）（行がデフォルト）
if(COL.equalsIgnoreCase(direction)) {
// 範囲チェック
- if(c + colSpan * cpCount < 0 || c + colSpan * cpCount > JaxcelUtil.getMaxColumnIndex(sheet)) {
+ if(c + colSpan * cpCount < 0 || c + colSpan * cpCount > ExcelUtil.getMaxColumnIndex(sheet)) {
log.warn("to cell outside sheet");
break;
}
else {
log.debug("continue. from cell [{}] and to cell [{}] is null", (new CellReference(r, c)).formatAsString(), (new CellReference(r, c + colSpan * cpCount)).formatAsString());
}
- contFlag = true;
+ continue;
}
else {
if(toCell == null) toCell = row.createCell(c + colSpan * cpCount);
// 繰返し方向縦（行）の場合
else {
// 範囲チェック
- if(r + rowSpan * cpCount < 0 || r + rowSpan * cpCount > JaxcelUtil.getMaxRowIndex(sheet)) {
+ if(r + rowSpan * cpCount < 0 || r + rowSpan * cpCount > ExcelUtil.getMaxRowIndex(sheet)) {
log.warn("to row outside sheet");
break;
}
else {
log.debug("continue. from and to row is null");
}
- contFlag = true;
+ continue;
}
else {
if(toRow == null) toRow = sheet.createRow(r + rowSpan * cpCount);
else {
log.debug("continue. from cell [{}] and to cell [{}] is null", (new CellReference(r, c)).formatAsString(), (new CellReference(r + rowSpan * cpCount, c)).formatAsString());
}
- contFlag = true;
+ continue;
}
else {
if(toCell == null) toCell = toRow.createCell(c);
}
}
}
- if(!contFlag) {
- // スタイルコピーなら
- if(cpCount > 0 && COPY.equalsIgnoreCase(style)) {
- // スタイルのコピー
- toCell.setCellStyle(cell.getCellStyle());
- }
- // 値
- switch(cell.getCellType()) {
- case Cell.CELL_TYPE_BLANK:
- toCell.setCellType(Cell.CELL_TYPE_BLANK);
- break;
- case Cell.CELL_TYPE_BOOLEAN:
- toCell.setCellType(Cell.CELL_TYPE_BOOLEAN);
- toCell.setCellValue(cell.getBooleanCellValue());
- break;
- case Cell.CELL_TYPE_ERROR:
- toCell.setCellType(Cell.CELL_TYPE_ERROR);
- toCell.setCellErrorValue(cell.getErrorCellValue());
- break;
- case Cell.CELL_TYPE_FORMULA:
- toCell.setCellType(Cell.CELL_TYPE_FORMULA);
- // 数式のパース・移動先に合わせる
- toCell.setCellFormula(
- JaxcelUtil.getMoveFormula(
- sheet,
- cell.getCellFormula().replace((i == startIdx ? object : list + "[" + (startIdx - 1) + "]"), list + "[" + (i - 1) + "]"),
- toCell.getRowIndex() - cell.getRowIndex(),
- toCell.getColumnIndex() - cell.getColumnIndex()
- )
- );
- break;
- case Cell.CELL_TYPE_NUMERIC:
- toCell.setCellType(Cell.CELL_TYPE_NUMERIC);
- toCell.setCellValue(cell.getNumericCellValue());
- break;
- case Cell.CELL_TYPE_STRING:
- toCell.setCellType(Cell.CELL_TYPE_STRING);
- toCell.setCellValue(cell.getStringCellValue().replace((i == startIdx ? object : list + "[" + (startIdx - 1) + "]"), list + "[" + (i - 1) + "]"));
- break;
- }
+
+ // スタイルコピーなら
+ if(cpCount > 0 && COPY.equalsIgnoreCase(style)) {
+ // スタイルのコピー
+ toCell.setCellStyle(cell.getCellStyle());
+ }
+ // 値のコピー
+ switch(cell.getCellType()) {
+ case Cell.CELL_TYPE_BLANK:
+ toCell.setCellType(Cell.CELL_TYPE_BLANK);
+ break;
+ case Cell.CELL_TYPE_BOOLEAN:
+ toCell.setCellType(Cell.CELL_TYPE_BOOLEAN);
+ toCell.setCellValue(cell.getBooleanCellValue());
+ break;
+ case Cell.CELL_TYPE_ERROR:
+ toCell.setCellType(Cell.CELL_TYPE_ERROR);
+ toCell.setCellErrorValue(cell.getErrorCellValue());
+ break;
+ case Cell.CELL_TYPE_FORMULA:
+ toCell.setCellType(Cell.CELL_TYPE_FORMULA);
+ // 数式のパース・移動先に合わせる
+ toCell.setCellFormula(
+ ExcelUtil.getMoveFormula(
+ sheet,
+ cell.getCellFormula().replace(
+ (i == startIdx ? object : list + "[" + (mapKeys == null ? (startIdx - 1) : "'" + mapKeys[startIdx - 1] + "'") + "]"), list + "[" + (mapKeys == null ? (i - 1) : "'" + mapKeys[i - 1] + "'") + "]"),
+ toCell.getRowIndex() - cell.getRowIndex(),
+ toCell.getColumnIndex() - cell.getColumnIndex()
+ )
+ );
+ log.debug("to cell Formula: {}", toCell.getCellFormula());
+ break;
+ case Cell.CELL_TYPE_NUMERIC:
+ toCell.setCellType(Cell.CELL_TYPE_NUMERIC);
+ toCell.setCellValue(cell.getNumericCellValue());
+ break;
+ case Cell.CELL_TYPE_STRING:
+ toCell.setCellType(Cell.CELL_TYPE_STRING);
+ toCell.setCellValue(cell.getStringCellValue().replace((i == startIdx ? object : list + "[" + (mapKeys == null ? (startIdx - 1) : "'" + mapKeys[startIdx - 1] + "'") + "]"), list + "[" + (mapKeys == null ? (i - 1) : "'" + mapKeys[i - 1] + "'") + "]"));
+ log.debug("to cell string: {}", toCell.getStringCellValue());
+ break;
}
- cpCount++;
}
}
}
for(int c = 0; c < rangeList.size(); c++) {
tmpBfRange = rangeList.get(c);
// 繰返し回数でループ
- cpCount = 1; // コピー実施回数のクリア
- for(int i = startIdx; (startIdx <= endIdx && i <= endIdx || startIdx > endIdx && i >= endIdx); i = (startIdx <= endIdx ? i + 1 : i - 1)) {
+ for(int i = startIdx, cpCount = 1; (startIdx <= endIdx && i <= endIdx || startIdx > endIdx && i >= endIdx); i = (startIdx <= endIdx ? i + 1 : i - 1), cpCount++) {
// 初回はコピーしない（コピー元だから）
if(i == startIdx) continue;
// コピー先レンジ
tmpBfRange.getLastColumn() + (addCol * cpCount));
sheet.addMergedRegion(tmpAfRange);
log.debug("mergedRegion copy. from: [{}] to: [{}]", tmpBfRange.formatAsString(), tmpAfRange.formatAsString());
- cpCount++;
}
}
}
case CellRangeUtil.INSIDE:
case CellRangeUtil.OVERLAP:
// 繰返し回数でループ
- cpCount = 1; // コピー実施回数のクリア
- for(int j = startIdx; (startIdx <= endIdx && j <= endIdx || startIdx > endIdx && j >= endIdx); j = (startIdx <= endIdx ? j + 1 : j - 1)) {
+ ; // コピー実施回数のクリア
+ for(int j = startIdx, cpCount = 1; (startIdx <= endIdx && j <= endIdx || startIdx > endIdx && j >= endIdx); j = (startIdx <= endIdx ? j + 1 : j - 1), cpCount++) {
// 初回はコピーしない（コピー元だから）
if(j == startIdx) continue;
// TODO これでオブジェクト（アンカー）のコピーができる！！
tmpAfRange = new CellRangeAddress(from.getRow(), to.getRow(), from.getCol(), to.getCol());
log.debug("object copy from: [{}] to: [{}]", tmpBfRange.formatAsString(), tmpAfRange.formatAsString());
}
- cpCount++;
}
}
}
switch(delete) {
// クリア
case CLEAR:
- JaxcelUtil.clearRange(sheet, (new CellRangeAddress(startRowIdx, startRowIdx + rowSpan - 1, startColIdx, startColIdx + colSpan - 1)), true, true);
+ ExcelUtil.clearRange(sheet, (new CellRangeAddress(startRowIdx, startRowIdx + rowSpan - 1, startColIdx, startColIdx + colSpan - 1)), true, true);
break;
// 左詰め
case LEFT:
// IF範囲以降をずらす
- JaxcelUtil.shift(sheet, new CellRangeAddress(startRowIdx, startRowIdx + rowSpan - 1, startColIdx + colSpan, startColIdx + colSpan), COL, -colSpan, block);
+ ExcelUtil.shift(sheet, new CellRangeAddress(startRowIdx, startRowIdx + rowSpan - 1, startColIdx + colSpan, startColIdx + colSpan), COL, -colSpan, block);
break;
// 上詰め
case UP:
// IF範囲以降をずらす
- JaxcelUtil.shift(sheet, new CellRangeAddress(startRowIdx + rowSpan, startRowIdx + rowSpan, startColIdx, startColIdx + colSpan - 1), ROW, -rowSpan, block);
+ ExcelUtil.shift(sheet, new CellRangeAddress(startRowIdx + rowSpan, startRowIdx + rowSpan, startColIdx, startColIdx + colSpan - 1), ROW, -rowSpan, block);
}
}
log.trace("parseIf end");
* @version 1.00.00
* @author Noboru Saito
*/
-public class JaxcelUtil {
+public class ExcelUtil {
- private static final Logger log = LoggerFactory.getLogger(JaxcelUtil.class);
+ private static final Logger log = LoggerFactory.getLogger(ExcelUtil.class);
/** 範囲判定 */
public static final String INSIDE = "inside";
* @param rangeA 対象範囲Ａ
* @param rangeB 対象範囲Ｂ
*
- * @return JaxcelUtil.INSIDE：対象範囲Ａに対象範囲Ｂが含まれている<br>
- * JaxcelUtil.OVERLAP：対象範囲Ａに対象範囲Ｂの一部が交差している<br>
- * JaxcelUtil.ENCLOSES：対象範囲Ｂに対象範囲Ａが含まれている<br>
- * JaxcelUtil.NO_INTERSECTION：対象範囲Ａに対象範囲Ｂは一部の含まれていない
+ * @return ExcelUtil.INSIDE：対象範囲Ａに対象範囲Ｂが含まれている<br>
+ * ExcelUtil.OVERLAP：対象範囲Ａに対象範囲Ｂの一部が交差している<br>
+ * ExcelUtil.ENCLOSES：対象範囲Ｂに対象範囲Ａが含まれている<br>
+ * ExcelUtil.NO_INTERSECTION：対象範囲Ａに対象範囲Ｂは一部の含まれていない
*/
public static String getIntersectString(CellRangeAddress rangeA, CellRangeAddress rangeB) {
// 範囲内に含まれている or 掛かっている テーブルクリア
--- /dev/null
+package org.hanei.jaxcel.util;
+
+import java.io.File;
+import java.io.FileInputStream;
+import java.io.InputStreamReader;
+import java.util.HashMap;
+import net.arnx.jsonic.JSON;
+import org.hanei.jaxcel.report.ReportMaker;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+
+public class MakeReportTool {
+
+ private static final Logger log = LoggerFactory.getLogger(MakeReportTool.class);
+
+ /**
+ * ExcelテンプレートファイルにJSONファイルのデータを挿入することでExcel帳票を生成、Excel帳票ファイルを出力する。
+ *
+ * @param args arg1: Excelテンプレートファイルパス<br>
+ * arg2: パラメータJSONファイルパス<br>
+ * arg3: Excel帳票出力ファイルパス
+ *
+ * @throws Exception
+ */
+ public static void main(String[] args) throws Exception {
+
+ if(args.length != 3) {
+ System.out.println("illegal arguments.");
+ System.out.println("arg1: template excel file path");
+ System.out.println("arg2: parameters json file path");
+ System.out.println("arg3: output excel file path");
+ System.out.println("...relative path from the build root. or absolute path");
+ System.exit(0);
+ }
+ // data load
+ HashMap<String, Object> parameter = JSON.decode(new InputStreamReader(new FileInputStream(new File(args[1])),"UTF-8"));
+
+ ReportMaker maker = new ReportMaker();
+ log.info("====== makeReport Start ======");
+ maker.makeReport(new File(args[0]), parameter, new File(args[2]));
+ System.out.println("output complate " + args[2]);
+ System.out.println("see debug log ../log/jaxcel.log");
+ log.info("====== makeReport End ======");
+ }
+
+}
OSDN Git Service
