Write Excel: string and number within the same column
I’d like to export my data to an Excel file. My table contains columns (string type) with numbers (treated as strings) and string data types. After using the Write Excel node, I end up with an xlsx file that displays warnings in the cells stating “numbers are stored as text.” I’m trying to prevent this issue but haven’t been successful so far. I’ve attempted to create a new column with an unspecified data type in the Excel Write node, but that didn’t work. Any assistance in resolving this would be greatly appreciated in advance!