質問編集履歴

createメソッドを使用するように変更

2024/03/27 06:59

投稿

kentosushi

スコア1

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -18,38 +18,29 @@
 ### 該当のソースコード
 ```java
+public class Main  {
-public static void main(String[] args) throws Exception {
+    public static void main(String[] args) {
-        System.out.print("start: main\r\n");
+        System.out.println("start: main");
-        excelOpenXlsxPassword("C://GCS/template.xlsx", "abc");
-        System.out.print("end: main\r\n");
-    }
- /**
-     * パスワード付きExcelファイルの読み込み＆書き込み。
-     * @param filePath Excelファイルのフルパス
-     * @param password パスワード
-     * @throws IOException
-     */
-    public static void excelOpenXlsxPassword(String filePath, String password) throws  EncryptedDocumentException, IOException {
-        FileInputStream fi = null;
+        FileInputStream in = null;
-        POIFSFileSystem fileSystem = null;
-        InputStream is = null;
-        Workbook wb = null;
+        Workbook tempbook = null;
         try {
-            fi = new FileInputStream(filePath);
+            in = new FileInputStream("test.xlsx");
+            tempbook = WorkbookFactory.create(in, "abc");
+        } catch (IOException e) {
-            fileSystem = new POIFSFileSystem(fi);
+            System.out.print(e.toString());
-            EncryptionInfo info = new EncryptionInfo(fileSystem);
+        } finally {
-            Decryptor d = Decryptor.getInstance(info);
+            try {
-            if (d.verifyPassword(password) == false) {
+                if (tempbook != null) {
+                    tempbook.close();
+                }
+            } catch (IOException e) {
-                System.out.println("パスワードを解除出来ませんでした。");
+                System.out.print("終了処理で入出力例外が発生！");
-                return;
-            }else{
-                System.out.println("解除成功");
             }
+        }
-            is = d.getDataStream(fileSystem);
+        System.out.println("読込完了");
-            wb = new XSSFWorkbook(is);
+    }
+}
 ```
 ### 試したこと

Java Excel

バージョン追記

2024/03/27 00:08

投稿

kentosushi

スコア1

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -58,4 +58,7 @@
 US_export_policy.jar
 local_policy.jar
+### 補足情報
+java 1.8.0_381
+apache poi 5.2.3
+jce_policy 8

Java Excel

不要なコードを削除

2024/03/26 11:11

投稿

kentosushi

スコア1

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -21,21 +21,8 @@
 public static void main(String[] args) throws Exception {
         System.out.print("start: main\r\n");
-        Workbook tempbook = null;
-        try {
-            excelOpenXlsxPassword("C://GCS/template.xlsx", "abc");
+        excelOpenXlsxPassword("C://GCS/template.xlsx", "abc");
-        } catch (IOException e) {
-            System.out.print("入出力例外が発生！");
-        } finally {
-            //--- テンプレートをクローズ --//
-            try {
-                if (tempbook != null) {
-                    tempbook.close();
-                }
-            } catch (IOException e) {
-                System.out.print("終了処理で入出力例外が発生！");
-            }
-        }
         System.out.print("end: main\r\n");
     }

Java Excel