Excel - Python - Identify Pivot Tables - KNIME Forum (80353)
<p>Excel - try to identify which Excel sheets do contain Pivot tables with Python</p><p>The Python code will open Excel in the background using "xlwings" and check if there is an Excel file there</p>
URL: Get the Excel Pivot sample file here https://contextures.com/excelpivottableccomments.html
URL: xlwings - Make Excel fly with Python! https://github.com/xlwings/xlwings
URL: KNIME Forum (80353) https://forum.knime.com/t/identify-pivot-data-from-excel-tabs/80353/6?u=mlauber71
URL: Medium: KNIME and Python — Setting up and managing Conda environments https://medium.com/low-code-for-advanced-data-science/knime-and-python-setting-up-and-managing-conda-environments-2ac217792539
Nodes
- Constant Value Column2 ×
- Conda Environment Propagation1 ×
- List Files/Folders1 ×
- Loop End1 ×
- Path to URI1 ×
- Python Script1 ×
- Table Row to Variable Loop Start1 ×
- Table Writer1 ×
- URL to File Path1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Basic File System Connectors
- FeatureKNIME Conda Integration
- FeatureKNIME Python Integration
Links
- No links available