It’s possible to set all columns to string format in one click?
Currently it’s not. Sorry about that!
Hope you are aware of - String Manipulation (Multi Column) - node > Convert Type > string(x) function
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)
But, I imagine something more simple.
@Felipereis50 I once proposed this solution:
Also you could try and force the types later. Using a sample table:
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')