Edit File app excel options

minjk-bl · minjk-bl · commit 9125d1d63855 · 2023-08-22T18:26:22.000+09:00
diff --git a/visualpython/data/m_library/pandasLibrary.js b/visualpython/data/m_library/pandasLibrary.js
@@ -6556,7 +6556,7 @@ define([
         "name": "Read Excel",
         "library": "pandas",
         "description": "excel to pandas object",
-        "code": "${o0} = pd.read_excel(${i0}${sheet_name}${index_col}${etc})",
+        "code": "${o0} = pd.read_excel(${i0}${sheet_name}${header}${index_col}${etc})",
         "options": [
           {
             "name": "i0",
@@ -6582,6 +6582,11 @@ define([
             "type": "text",
             "usePair": true
           },
+          {
+            "name": "header",
+            "label": "Header",
+            "usePair": true
+          },
           {
             "name": "index_col",
             "label": "Column To Use As Index",
@@ -6598,7 +6603,7 @@ define([
           "openpyxl"
         ],
         "description": "DataFrame to excel file",
-        "code": "${i0}.to_excel(${i1}${sheet_name}${etc})",
+        "code": "${i0}.to_excel(${i1}${sheet_name}${header}${index}${etc})",
         "options": [
           {
             "name": "i0",
@@ -6626,6 +6631,21 @@ define([
             "label": "Sheet Name",
             "type": "text",
             "usePair": true
+          },
+          {
+            "name": "header",
+            "label": "Header",
+            "usePair": true
+          },
+          {
+            "name": "index",
+            "label": "Index",
+            "type": "text",
+            "component": [
+              "bool_select"
+            ],
+            "default": "True",
+            "usePair": true
           }
         ]
       },
