Icon

kn_​example_​excel_​old_​files_​import

use R package readxl to import older excel files

use R package readxl (was: gdata) to import older excel files

https://www.r-bloggers.com/read-excel-files-from-r/ https://forum.knime.com/t/xls-reader-old-xls-file-type/9410/4?u=mlauber71 use R package readxl (was: gdata) to import older excel files conda install -c conda-forge r-gdataconda install -c conda-forge r-readxl Alternative method tto get the file path # The Excel import has been removed from gdatarequire(gdata)xls_file_path <- paste0(knime.flow.in[["context.workflow.absolute-path"]],knime.flow.in[["separator"]],"data",knime.flow.in[["separator"]], knime.flow.in[["xsl_file_name"]])df = read.xls(c(xls_file_path), sheet = 1, header = TRUE)knime.out <- df Propagate R environmentfor KNIME on MacOS withMiniforge / Minicondaconfigure how to handle the environmentdefault = just check the namesimport with readxlxls_file_path <- paste0(knime.flow.in[["context.workflow.data-path"]], knime.flow.in[["xsl_file_name"]])pathxsl_file_namePropagate R environmentfor KNIME on Windows withMinicondaconfigure how to handle the environmentdefault = just check the namesdata.xlsxtblSRC_Data_Processed_small*absolute Pathfrom URIsheet = 1Propagate R environmentfor KNIME on MacOS with(Apple Scilicon)Miniforge / Minicondaconfigure how to handle the environmentdefault = just check the namesfor Apple silicon you might have to manuallyinstall "RServe" currentlylocate and create/data/ folderwith absolute paths knime_r_environment R Snippet ConstantValue Column Table Creator Table Creator knime_r_environment_windows Merge Variables Table Rowto Variable Excel Writer List Files/Folders Path to URI URL to File Path Table Rowto Variable R Source (Table) Merge Variables knime_r_environment_apple_silicon Collect LocalMetadata https://www.r-bloggers.com/read-excel-files-from-r/ https://forum.knime.com/t/xls-reader-old-xls-file-type/9410/4?u=mlauber71 use R package readxl (was: gdata) to import older excel files conda install -c conda-forge r-gdataconda install -c conda-forge r-readxl Alternative method tto get the file path # The Excel import has been removed from gdatarequire(gdata)xls_file_path <- paste0(knime.flow.in[["context.workflow.absolute-path"]],knime.flow.in[["separator"]],"data",knime.flow.in[["separator"]], knime.flow.in[["xsl_file_name"]])df = read.xls(c(xls_file_path), sheet = 1, header = TRUE)knime.out <- df Propagate R environmentfor KNIME on MacOS withMiniforge / Minicondaconfigure how to handle the environmentdefault = just check the namesimport with readxlxls_file_path <- paste0(knime.flow.in[["context.workflow.data-path"]], knime.flow.in[["xsl_file_name"]])pathxsl_file_namePropagate R environmentfor KNIME on Windows withMinicondaconfigure how to handle the environmentdefault = just check the namesdata.xlsxtblSRC_Data_Processed_small*absolute Pathfrom URIsheet = 1Propagate R environmentfor KNIME on MacOS with(Apple Scilicon)Miniforge / Minicondaconfigure how to handle the environmentdefault = just check the namesfor Apple silicon you might have to manuallyinstall "RServe" currentlylocate and create/data/ folderwith absolute pathsknime_r_environment R Snippet ConstantValue Column Table Creator Table Creator knime_r_environment_windows Merge Variables Table Rowto Variable Excel Writer List Files/Folders Path to URI URL to File Path Table Rowto Variable R Source (Table) Merge Variables knime_r_environment_apple_silicon Collect LocalMetadata

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-07-27
On NodePit since: 2019-10-12
Last update: 2024-04-20
Created with KNIME version: v4.7.8
Tags: RKNIMEExcelimport

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

Try NodePit Runner!