HI Sidheshwari,
This is a limitation of Excel itself: https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3 . There's a hard limit in both the .xls
and .xlsx
file formats of 32,767 characters. Normally you can check the source and see why there is a data more than 32k in a singe cell . Your best option would be switching the export to CSV .
Regards,
Harisanker
That is the maximum number of characters allowed in the excel cell value. Truncate the characters if it is more than 32676.
Check this link. https://support.microsoft.com/en-us/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3#ID0EDBD=Newer_versions