Icon

kn_​example_​python_​excel_​xlsb

Read binary Excel Files (.xlsb) wit the help of Python package "pyxlsb"

Read binary Excel Files (.xlsb) wit the help of Python package "pyxlsb"

conda install -c conda-forge pyxlsb

Read binary Excel Files (.xlsb) wit the help of Python package "pyxlsb"https://forum.knime.com/t/read-xlsb-file/13790/7conda install -c conda-forge pyxlsb # Copy input to output############################################################################### https://pypi.org/project/pyxlsb/from pyxlsb import open_workbookimport osimport pandas as pdv_list = []var_workflow_path = flow_variables['context.workflow.absolute-path']print("var_workflow_path : ", var_workflow_path )var_path_excel_file = var_workflow_path + os.path.sep + "data" + os.path.sep + "data1.xlsb"print("var_path_excel_file : ", var_path_excel_file )# Create an new Excel file and add a worksheet.workbook = open_workbook(var_path_excel_file)worksheet = workbook.get_sheet('Sheet1')# https://github.com/wwwiiilll/pyxlsb/issues/12for row in worksheet.rows(): v_list.append([item.v for item in row])df = pd.DataFrame(v_list[1:], columns=v_list[0])output_table_1 = df.copy() import knime_io as knio# Copy input to output############################################################################### https://pypi.org/project/pyxlsb/from pyxlsb import open_workbookimport osimport pandas as pdv_list = []var_workflow_path = knio.flow_variables['context.workflow.absolute-path']print("var_workflow_path : ", var_workflow_path )var_path_excel_file = var_workflow_path + os.path.sep + "data" + os.path.sep + "data1.xlsb"print("var_path_excel_file : ", var_path_excel_file )# Create an new Excel file and add a worksheet.workbook = open_workbook(var_path_excel_file)worksheet = workbook.get_sheet('Sheet1')# https://github.com/wwwiiilll/pyxlsb/issues/12for row in worksheet.rows(): v_list.append([item.v for item in row])df = pd.DataFrame(v_list[1:], columns=v_list[0])knio.output_tables[0] = knio.write_table(df.copy()) use pyxlsbuse pyxlsbdetermine local path*pathdata1_1.tabledata1_2.tabledata1.xlsb=> able to read ExcelBinary Files (mostly) Python Script Python Script(Labs) Extract ContextProperties Variable toTable Row Table Writer Table Writer Excel Reader Read binary Excel Files (.xlsb) wit the help of Python package "pyxlsb"https://forum.knime.com/t/read-xlsb-file/13790/7conda install -c conda-forge pyxlsb # Copy input to output############################################################################### https://pypi.org/project/pyxlsb/from pyxlsb import open_workbookimport osimport pandas as pdv_list = []var_workflow_path = flow_variables['context.workflow.absolute-path']print("var_workflow_path : ", var_workflow_path )var_path_excel_file = var_workflow_path + os.path.sep + "data" + os.path.sep + "data1.xlsb"print("var_path_excel_file : ", var_path_excel_file )# Create an new Excel file and add a worksheet.workbook = open_workbook(var_path_excel_file)worksheet = workbook.get_sheet('Sheet1')# https://github.com/wwwiiilll/pyxlsb/issues/12for row in worksheet.rows(): v_list.append([item.v for item in row])df = pd.DataFrame(v_list[1:], columns=v_list[0])output_table_1 = df.copy() import knime_io as knio# Copy input to output############################################################################### https://pypi.org/project/pyxlsb/from pyxlsb import open_workbookimport osimport pandas as pdv_list = []var_workflow_path = knio.flow_variables['context.workflow.absolute-path']print("var_workflow_path : ", var_workflow_path )var_path_excel_file = var_workflow_path + os.path.sep + "data" + os.path.sep + "data1.xlsb"print("var_path_excel_file : ", var_path_excel_file )# Create an new Excel file and add a worksheet.workbook = open_workbook(var_path_excel_file)worksheet = workbook.get_sheet('Sheet1')# https://github.com/wwwiiilll/pyxlsb/issues/12for row in worksheet.rows(): v_list.append([item.v for item in row])df = pd.DataFrame(v_list[1:], columns=v_list[0])knio.output_tables[0] = knio.write_table(df.copy()) use pyxlsbuse pyxlsbdetermine local path*pathdata1_1.tabledata1_2.tabledata1.xlsb=> able to read ExcelBinary Files (mostly) Python Script Python Script(Labs) Extract ContextProperties Variable toTable Row Table Writer Table Writer Excel 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-11-23
On NodePit since: 2019-10-05
Last update: 2024-04-26
Created with KNIME version: v4.5.1
Tags: pythonexcelxlsbbinaryfileknime

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

Try NodePit Runner!