Skip to content
Advertisement

Tag: text-to-column

Text to Columns in Excel using Python using openpyxl

I am trying to do the “text-to-columns” feature from Excel through Python using openpyxl. The file I have is currently saved as a .xlsx. I cannot use the split() feature because my data is numbers not words. I have tried pandas but it does not work. I ran into the problem of having to download xldr but I cannot because

Advertisement