title: Does pandas .to_csv export cells properly (with no data loss) if it contains more than 32,767 characters?
body: <p>Before I say anything, please note that it is MANDATORY for me to use xlsx or csv as it's for a website import and the information in a cell CAN NOT be truncated or removed or shortened in any way. Please do not provide an answer to which says to use something else, because I can't. </p>
  
  <p>I'm exporting data to a spreadsheet which can either be csv or xlsx depending on what answer I find to this question, and over 10000 rows contain a cell which has MORE than 32,767 characters. (So the total characters would be 32767+ * 10000). for example: (89473 characters * 10000) </p>
  
  <p>I'm not sure whether or not the information retains once it has completed an export because in Excel it either cuts (removes) the data in cells at 32,767 characters for an xlsx, or for a csv export, it puts information in to the next rows and makes it look corrupted (even though it probably isn't). </p>
  
  <p>My main question is: Is the information retained after an export from pandas and just doesn't show the info in excel, but instead the raw file contains that info? Or does everything just get cut off after export no matter what?</p>
  
  <p>Also, is there any way to view the full amount of characters in the cells using a different program, because, obviously, Excel cuts it off or makes it look distorted.</p>
  
  <p>I have tried looking online for solutions and have had no luck. I am able to use these other formats (besides from csv and xlsx) for importing to the website: XLS, XML, or ZIP File. </p>
  
  <p><code>df.to_excel('File.xlsx') ##Using this to export the file.</code></p>