Hub

26 results

Filter
Filter by tag
Openpyxl
Python
Excel Knime Sheet Header Xlsx Export
  1. 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
  2. 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
  3. Workflow
    KNIME and OpenPyxl - copy formats from one sheet to another
    ChatGPT Excel Python
    +3
    KNIME and OpenPyxl - copy formats from one sheet to another
    mlauber71 > Public > kn_example_python_excel_format_copy
    0
    mlauber71
  4. Workflow
    Excel file header format with KNIME and OpenPyxl
    Python Openpyxl Knime
    +2
    Excel file header format with KNIME and OpenPyxl Freeze the top row, autosize the columns and set a style
    mlauber71 > Public > kn_example_python_excel_format_header
    0
    mlauber71
  5. Workflow
    KNIME & Python Graphics -Grouped violinplots with split violins - also export PNG to Excel
    Knime Python Matplotlib
    +12
    KNIME & Python Graphics -Grouped violinplots with split violins - also export PNG to Excel adapted from: https://seaborn.pydata.o…
    mlauber71 > Public > kn_example_python_graphic_violinplots_grouped
    0
    mlauber71
  6. Workflow
    Excel file header format with KNIME and OpenPyxl (with bundled Python in KNIME 4.7) - zip Excle file and send Email
    Python Openpyxl Knime
    +2
    Excel file header format with KNIME and OpenPyxl (with bundled Python in KNIME 4.7) - zip Excle file and send Email Freeze the to…
    mlauber71 > Public > kn_example_python_excel_format_zip_send_mail
    0
    mlauber71
  7. 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
  8. Workflow
    Export Excel File with OpenPyxl (simple) from KNIME - also add some formats
    Excel Python Openpyxl
    +1
    Export Excel File with OpenPyxl (simple) from KNIME - also add some formats
    mlauber71 > Public > kn_example_python_excel_export_simple_file_openpyxl
    0
    mlauber71
  9. Workflow
    extract the formats of the first data row of an Excel file with KNIME and OpenPyxl
    Python Openpyxl Knime
    +2
    extract the formats of the first data row of an Excel file with KNIME and OpenPyxl https://forum.knime.com/t/could-self-defined-f…
    mlauber71 > Public > kn_example_python_excel_format_extract
    0
    mlauber71
  10. Workflow
    KNIME - use openpyxl to set password on Excel, read-protect a sheet, freeze a top row and add a filter (and hind and unhide your worksheet)
    Excel Password Knime
    +7
    KNIME - use openpyxl to set password on Excel, read-protect a sheet, freeze a top row and add a filter (and hind and unhide your …
    mlauber71 > Public > kn_example_python_excel_password_protection
    0
    mlauber71
  11. Workflow
    KNIME and Python's openpyxl to extract named tables (ranges) from Excel file (using the bundled KNIME Python version)
    Excel Openpyxl Import
    +5
    KNIME and Python's openpyxl to extract named tables (ranges) from Excel file (using the bundled KNIME Python version) https://for…
    mlauber71 > Public > kn_example_python_excel_table_object_read
    0
    mlauber71
  12. 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
  13. Workflow
    Import Excel File with OpenPyxl (simple)
    Excel Python Openpyxl
    Import Excel File with OpenPyxl (simple)
    mlauber71 > Public > kn_example_python_excel_import_simple_file_openpyxl
    0
    mlauber71
  14. 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
  15. Workflow
    KNIME and Python's openpyxl to define and name a Data area in Excel (using the bundled Python version)
    Openpyxl Excel Area
    +3
    KNIME and Python's openpyxl to define and name a Data area in Excel (using the bundled Python version) https://forum.knime.com/t/…
    mlauber71 > Public > kn_example_python_excel_table_object_filter
    0
    mlauber71
  16. 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
  17. 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
  18. Workflow
    use Python Pandas and Openpyxl to import and export Excel (sheets) and Export them back - also append to an existing Excel file
    Python Excel Import
    +5
    use Python Pandas and Openpyxl to import and export Excel (sheets) and Export them back - also append to an existing Excel file
    mlauber71 > Public > kn_example_python_excel_import_export_openpyxl
    0
    mlauber71
  19. Workflow
    Write excel data file with column with drop down list
    Python Openpyxl
    Write excel data file with column with drop down list
    mlauber71 > Public > kn_example_python_excel_drop_down
    0
    mlauber71
  20. 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