Excel Reader node - Transform tab - SET all columns to String

[mlauber71]

@Felipereis50 I once proposed this solution:

Excel Reader: Issue with data types of input columns

I once built this to force all columns from an excel file to be imported as strings … using R:

Also you could try and force the types later. Using a sample table:

Dynamically Convert All Columns / Data Types to String

Nevermind. I was able to accomplish it using the node below and constructing a dummy value table via the Extract Column Headers node. It is not a universal conversion solution, but it handles enough of them for my purposes.

Also you could try and use openpyxl to import the file and force strings

import pandas as pd

# Specify your file path and sheet name
file_path = 'your_file.xlsx'
sheet = 'YourSheetName'  # Replace with your sheet name

# Read the Excel file, specifying the sheet and forcing all columns to strings
df = pd.read_excel(file_path, sheet_name=sheet, dtype=str, engine='openpyxl')

Import Excel File with OpenPyxl (simple) – mlauber71