Numeric Rank to Alphabetical Rank

I’m using the xls formatting nodes from Continental and I’m trying to automatically detect the last column in a file, so that I only select the header as “a1:d1” for example. I know how many columns I have in the file (4 in this example) but I don’t know if there’s an automatic way of transforming 4 into D, or 5 in E and so on.

Is there a node or other simple solution solution than a local dictionary?

Hi @lucian.cristian, it is quite tricky, but luckily Jerry T already solved this question in R, see here: https://stackoverflow.com/a/52214227

I attached a short example how to implement it in KNIME: Number to Excel Column Name.knwf (7.2 KB)

Best regards,
agaunt

4 Likes

thanks! it works perfect.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.