Icon

kn_​example_​r_​ods_​calc_​write

Export ODS (Libre Office) calc Sheets

Export ODS (Libre Office) calc Sheets

Export ODS (Libre Office) calc Sheetshttps://forum.knime.com/t/node-to-read-libreoffice-calc-and-db-files/18791 library(readODS)file_location <- knime.flow.in[["v_export_ods_file"]]write_ods( x=knime.in, path=file_location, sheet = "Sheet1", append = FALSE, update = FALSE, row_names = FALSE, col_names = TRUE, # verbose = FALSE, # overwrite = NULL)list_ods_sheets <-as.data.frame(ods_sheets(file_location))knime.out <- list_ods_sheets library(readODS)library(arrow)library(foreign)file_location <- knime.flow.in[["v_export_ods_file"]]knime.out <- read_ods(path = file_location, sheet = "Sheet1", col_names = TRUE,col_types = NULL, na = "", skip = 0, formula_as_formula = FALSE, range = NULL)# export as ARFF filevar_loc_arff <- paste0(knime.flow.in[["context.workflow.data-path"]], "sample.arff")write.arff(knime.out, var_loc_arff, eol = "\n")# export file as parquetvar_loc_parquet <- paste0(knime.flow.in[["context.workflow.data-path"]], "sample.parquet")write_parquet(knime.out, var_loc_parquet, compression = "gzip")knime.out <- as.data.frame(knime.out) locate and create/data/ folderwith absolute pathsexport datato ODSyyyy-MM-ddv_export_ods_filesample.odsimport ODSdummy datatodayyyyy-MM-dd HH:mm:sscurrent dayvar_nowvar_todayvar_nownowyyyy-MM-dd HH:mm:sstodaynowdata/sample_from_arff.tabledata/sample_from_parquet.tableknime://knime.workflow/data/cars.arffdata/sample_from_r_ods.tablesample.parquetpreserves the date and time ciolumns Collect LocalMetadata Date&Time to String Column Rename R Snippet String to Date&Time Java EditVariable (simple) R Snippet Data Generator ConstantValue Column Date&Time to String Create Date&TimeRange Table Rowto Variable Table Rowto Variable Column Rename Merge Variables ConstantValue Column String to Date&Time String to Date&Time String to Date&Time Table Writer Table Writer ARFF Reader Table Writer Parquet Reader Export ODS (Libre Office) calc Sheetshttps://forum.knime.com/t/node-to-read-libreoffice-calc-and-db-files/18791 library(readODS)file_location <- knime.flow.in[["v_export_ods_file"]]write_ods( x=knime.in, path=file_location, sheet = "Sheet1", append = FALSE, update = FALSE, row_names = FALSE, col_names = TRUE, # verbose = FALSE, # overwrite = NULL)list_ods_sheets <-as.data.frame(ods_sheets(file_location))knime.out <- list_ods_sheets library(readODS)library(arrow)library(foreign)file_location <- knime.flow.in[["v_export_ods_file"]]knime.out <- read_ods(path = file_location, sheet = "Sheet1", col_names = TRUE,col_types = NULL, na = "", skip = 0, formula_as_formula = FALSE, range = NULL)# export as ARFF filevar_loc_arff <- paste0(knime.flow.in[["context.workflow.data-path"]], "sample.arff")write.arff(knime.out, var_loc_arff, eol = "\n")# export file as parquetvar_loc_parquet <- paste0(knime.flow.in[["context.workflow.data-path"]], "sample.parquet")write_parquet(knime.out, var_loc_parquet, compression = "gzip")knime.out <- as.data.frame(knime.out) locate and create/data/ folderwith absolute pathsexport datato ODSyyyy-MM-ddv_export_ods_filesample.odsimport ODSdummy datatodayyyyy-MM-dd HH:mm:sscurrent dayvar_nowvar_todayvar_nownowyyyy-MM-dd HH:mm:sstodaynowdata/sample_from_arff.tabledata/sample_from_parquet.tableknime://knime.workflow/data/cars.arffdata/sample_from_r_ods.tablesample.parquetpreserves the date and time ciolumns Collect LocalMetadata Date&Time to String Column Rename R Snippet String to Date&Time Java EditVariable (simple) R Snippet Data Generator ConstantValue Column Date&Time to String Create Date&TimeRange Table Rowto Variable Table Rowto Variable Column Rename Merge Variables ConstantValue Column String to Date&Time String to Date&Time String to Date&Time Table Writer Table Writer ARFF Reader Table Writer Parquet Reader

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: 2020-08-30
Last update: 2024-11-21
Created with KNIME version: v4.7.7
Tags: KNIMEODSOpen DocumentExcelcalcexportwrite_ods

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

Try NodePit Runner!