Icon

kn_​example_​python_​ods_​calc_​read_​write

Read and write ODS (Libre Office) calc sheets with Python and KNIME

Read and write ODS (Libre Office) calc sheets with Python and KNIME


# conda env create -f="/Users/m_lauber/Dropbox/knime-workspace/hub/kn_example_python_ods_calc_read_write/data/py39_knime_ods.yml"# conda update -n py39_knime_ods --all# conda env update --name py39_knime_ods --file "/Users/m_lauber/Dropbox/knime-workspace/hub/kn_example_python_ods_calc_read_write/data/py39_knime_ods.yml" --prune# conda env update --name py39_knime_ods --file "/Users/m_lauber/Dropbox/knime-workspace/hub/kn_example_python_ods_calc_read_write/data/py39_knime_ods.yml"# conda update -n base conda# conda install -c conda-forge aiohttp # file: py39_knime_ods.yml with some modifications# edit FEB-2023 - new meta package https://anaconda.org/knime# THX Carsten Haubold (https://hub.knime.com/carstenhaubold) for thisname: py39_knime_ods # Name of the created environmentchannels: # Repositories to search for packages# - defaults # edit: removed to just use conda-forge# - anaconda # edit: removed to just use conda-forge- conda-forge- knime # conda search knime-python-base -c knime --infodependencies: # List of packages that should be installed- python=3.9 # Python- knime-python-base # dependencies of KNIME - Python integration# - knime-python-scripting # to also build Python packages for KNIME- cairo # SVG support- pillow # Image inputs/outputs- matplotlib # Plotting- IPython # Notebook support- nbformat # Notebook support- scipy # Notebook support- jpype1 # A Python to Java bridge- jupyter # Jupyter Notebook- odfpy # ODS Reader- pyexcel-ods3 # conda install -c conda-forge pyexcel-ods3 - pip # Python installer- pip: # install additional packages via pip# - vtreat # additional packages that would to be available in conda-forge conda install -c conda-forge odfpyconda install -c conda-forge pyexcel-ods3 Read and write ODS (Libre Office) calc sheets with Python and KNIME import knime.scripting.io as knioimport pandas as pdvar_ods_file = knio.flow_variables['v_import_file']df = pd.read_excel(var_ods_file, sheet_name="cars", engine='odf')knio.output_tables[0] = knio.Table.from_pandas(df) KNIME and Python — Setting up and managing Conda environmentshttps://medium.com/p/2ac217792539 locate and create/data/ folderwith absolute pathsv_import_filewritetest_data.odspy39_knime_odstest_data.odstest_data.odstest_data.odsv_import_filereadtest_data.odsreadcars.odsNode 3805 Collect LocalMetadata Java EditVariable (simple) Python Script Conda EnvironmentPropagation Test Data Generator Column Filter Merge Variables Column Filter Java EditVariable (simple) Python Script Python Script Row Filter # conda env create -f="/Users/m_lauber/Dropbox/knime-workspace/hub/kn_example_python_ods_calc_read_write/data/py39_knime_ods.yml"# conda update -n py39_knime_ods --all# conda env update --name py39_knime_ods --file "/Users/m_lauber/Dropbox/knime-workspace/hub/kn_example_python_ods_calc_read_write/data/py39_knime_ods.yml" --prune# conda env update --name py39_knime_ods --file "/Users/m_lauber/Dropbox/knime-workspace/hub/kn_example_python_ods_calc_read_write/data/py39_knime_ods.yml"# conda update -n base conda# conda install -c conda-forge aiohttp # file: py39_knime_ods.yml with some modifications# edit FEB-2023 - new meta package https://anaconda.org/knime# THX Carsten Haubold (https://hub.knime.com/carstenhaubold) for thisname: py39_knime_ods # Name of the created environmentchannels: # Repositories to search for packages# - defaults # edit: removed to just use conda-forge# - anaconda # edit: removed to just use conda-forge- conda-forge- knime # conda search knime-python-base -c knime --infodependencies: # List of packages that should be installed- python=3.9 # Python- knime-python-base # dependencies of KNIME - Python integration# - knime-python-scripting # to also build Python packages for KNIME- cairo # SVG support- pillow # Image inputs/outputs- matplotlib # Plotting- IPython # Notebook support- nbformat # Notebook support- scipy # Notebook support- jpype1 # A Python to Java bridge- jupyter # Jupyter Notebook- odfpy # ODS Reader- pyexcel-ods3 # conda install -c conda-forge pyexcel-ods3 - pip # Python installer- pip: # install additional packages via pip# - vtreat # additional packages that would to be available in conda-forge conda install -c conda-forge odfpyconda install -c conda-forge pyexcel-ods3 Read and write ODS (Libre Office) calc sheets with Python and KNIME import knime.scripting.io as knioimport pandas as pdvar_ods_file = knio.flow_variables['v_import_file']df = pd.read_excel(var_ods_file, sheet_name="cars", engine='odf')knio.output_tables[0] = knio.Table.from_pandas(df) KNIME and Python — Setting up and managing Conda environmentshttps://medium.com/p/2ac217792539 locate and create/data/ folderwith absolute pathsv_import_filewritetest_data.odspy39_knime_odstest_data.odstest_data.odstest_data.odsv_import_filereadtest_data.odsreadcars.odsNode 3805Collect LocalMetadata Java EditVariable (simple) Python Script Conda EnvironmentPropagation Test Data Generator Column Filter Merge Variables Column Filter Java EditVariable (simple) Python Script Python Script Row Filter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2018-06-11
On NodePit since: 2022-07-13
Last update: 2024-04-27
Created with KNIME version: v4.7.7
Tags: KNIMEODSOpen DocumentExcelImportcalclibreofficepythonodfpypyexcel-ods3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!