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

[Felipereis50]

Hi friends,

It’s possible to set all columns to string format in one click?

[ScottF]

Currently it’s not. Sorry about that!

[Asghar]

Hi,

Hope you are aware of - String Manipulation (Multi Column) - node > Convert Type > string(x) function

Regards

[Daniel_Weikert]

@Felipereis50
alternatively you read the data without headers in first row and then use row to column headers node and you got everything as string (if you untick auto type conversion)
br

[Felipereis50]

Ow…
Clever.

But, I imagine something more simple.
Thanks friend.

[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

[Felipereis50]

Hi
Great.
I’m sure I will use your component/metanode.

Thanks my friend. You’re awesome.