When converting Panda Dataframe to Excel, long strings in cells are getting truncated

Viewed 210

I have strings that exceed 255 characters, and they are getting cut off when I convert from panda to excel using:

sources.to_excel("sources.xlsx") 

How do I prevent this truncation?

1 Answers

The strings will be stored in a single column. Just expand the width of the column in excel to contain those strings in a single cell.

Related