Hub
ComponentComponent

Excel Resize Columns (JSON)

ajackson profile image
Draft Latest edits on 
Drag & drop
Like
Use or download
2025-02-07 Andrew Jackson. Prevent input to columns in Excel

Based on https://hub.knime.com/tommy/spaces/Public/Excel%20Table%20Writer~EnxXLRACyo7A_tGI/current-state
Python code was modified to suit.

Component details

  • Additional Padding (all visible columns)

    This overrides the requested amount to make up for differences between Excel and openpyxl. Default is 0.78. This may be font dependant.

  • File name of existing Excel sheet (accepts string, not Path)

  • Existing Excel file sheet name

Used extensions & nodes

This component does not have nodes, extensions, nested components and related workflows