Hub

14 results

Filter
Openpyxl
Excel
Python Knime Import Xlsx Sheet Data File Pandas
  1. Workflow
    Import EXCEL - a meta workflow trying to answer questions about importing data from Excel files
    Excel Import Sheet
    +17
    Import EXCEL - This workflow will act as a meta workflow trying to answer questions about importing data from Excel files One of …
    mlauber71 > Public > kn_example_excel_import_meta_workflow
    1
    mlauber71
  2. Workflow
    KNIME - openpyxl and xlsxwriter to add formulas to excel files
    Xlsxwriter Excel Python
    +1
    use python package openpyxl to add formulas to excel files
    mlauber71 > Public > kn_example_python_excel_enter_formula
    1
    mlauber71
  3. Workflow
    Extract images from an Excel file with the help of Python / OpenPyxl
    Python Knime Openpyxl
    +5
    Extract images from an Excel file with the help of Python / OpenPyxl there is a Jupyter notebook to experiment with under /data/k…
    mlauber71 > Public > kn_example_python_excel_image_extract
    0
    mlauber71
  4. Workflow
    Extract meta information from Excel file (with the help of Python)
    Excel File Meta
    +4
    Extract meta information from Excel file (with the help of Python)
    mlauber71 > Public > kn_example_python_excel_meta_information_files
    0
    mlauber71
  5. Workflow
    Append data to an existing Excel file with the help of Python Pandas and OpenPyxl
    Excel File Sheet
    +5
    Append data to an existing Excel file with the help of Python Pandas and OpenPyxl
    mlauber71 > Public > forum > kn_forum_29528_python_excel_append_to_existing_sheet
    0
    mlauber71
  6. Workflow
    Manipulate Excel files in KNIME with Python openPyXL
    Python Openpyxl Excel
    Demonstrates several Python based manipulations for Excel
    mlauber71 > Public > kn_example_python_excel_manipulate > kn_python_excel_manipulate
    0
    mlauber71
  7. Workflow
    use Python package openpyxl to remove an existing worksheet from an Excel file
    Excel Load Write
    +5
    use Python package openpyxl to remove an existing worksheet from an Excel file
    mlauber71 > Public > kn_example_python_excel_remove_sheet
    0
    mlauber71
  8. Workflow
    KNIME - openpyxl and xlsxwriter to add formulas to excel files
    Excel Python Openpyxl
    use python package openpyxl to add formulas to excel files
    mlauber71 > Public > kn_example_python_excel_enter_formula_openpyxl
    0
    mlauber71
  9. Workflow
    KNIME - use openpyxl to set password on Excel
    Excel Password Knime
    +3
    KNIME - use openpyxl to set password on Excel
    mlauber71 > Public > kn_example_python_excel_password_protection
    0
    mlauber71
  10. Workflow
    KNIME - use Pandas and OpenPyxl to import a protected and formatted excel sheet - where import is otherwise slow
    Knime Python Openpyxl
    +3
    KNIME - use Pandas and OpenPyxl to import a protected and formatted excel sheet - where import is otherwise slow
    mlauber71 > Public > kn_example_python_excel_import_knime
    0
    mlauber71
  11. Workflow
    KNIME and Python's openpyxl to extract named tables (ranges) from Excel file
    Excel Openpyxl Import
    KNIME and Python's openpyxl to extract named tables (ranges) from Excel file conda install -c conda-forge openpyxl
    mlauber71 > Public > kn_example_python_excel_table_object_read
    0
    mlauber71
  12. Workflow
    try to find a workaround to re-calculate Excel formulas on sheets other than the one being imported
    Excel Openpyxl Python
    +2
    try to find a workaround to re-calculate Excel formulas on sheets other than the one being imported (which is possible in the Exc…
    mlauber71 > Forum > 2021 > kn_forum_38380_excel_re_evaluate_formulas
    0
    mlauber71
  13. Workflow
    KNIME and Python's openpyxl to define and name a Data area in Excel (using the bundled Python version)
    Openpyxl Excel Area
    +2
    KNIME and Python's openpyxl to define and name a Data area in Excel (using the bundled Python version)
    mlauber71 > Public > kn_example_python_excel_table_object_filter
    0
    mlauber71
  14. Workflow
    use Python Pandas and Openpyxl to import and export Excel (sheets) and Export them back
    Python Excel Import
    +4
    use Python Pandas and Openpyxl to import and export Excel (sheets) and Export them back
    mlauber71 > Public > kn_example_python_excel_import_export_openpyxl
    0
    mlauber71