Hub

16 results

Filter
Openpyxl
Python Excel KNIME Sheet Import Xlsx Extract File
  1. 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
  2. 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
  3. 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
  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
    KNIME - use openpyxl to set password on Excel
    Excel Password Knime
    +3
    KNIME - use openpyxl to set password on Excel There are limited ways to protect an Excel file using the Python package [ openpyxl…
    mlauber71 > Public > kn_example_python_excel_password_protection
    0
    mlauber71
  6. Workflow
    use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file. Then use the index numbers to import the files back
    KNIME Python Openpyxl
    +3
    use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file. Then use the index numbers to import the…
    mlauber71 > Public > kn_example_python_excel_sheet_index
    0
    mlauber71
  7. 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
  8. 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
  9. Workflow
    use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file - then move a sheet from one index position to a new one
    KNIME Python Openpyxl
    +5
    use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file - then move a sheet from one index positi…
    mlauber71 > Public > kn_example_python_excel_sheet_move_to_position
    0
    mlauber71
  10. 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
  11. 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
  12. Workflow
    Filter an Excel file using style elements like color of the cell extracted with the help of Python openpyxl
    Rgb Cell Color
    +4
    Filter an Excel file using style elements like color of the cell extracted with the help of Python openpyxl It is possible to do …
    mlauber71 > Public > forum > kn_forum_python_openpyxl_colour
    0
    mlauber71
  13. 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
  14. 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
  15. 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
  16. 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