Forum Discussion

kanishkatyagi11's avatar
kanishkatyagi11
Regular Visitor
10 months ago

Unable to write more than 255 characters in excel cell using Sys.OleObject["Excel.Application"]

Hi all,

 

I have a variable that has more than 255 characters and I 'm trying to write its value to a cell in Excel. But I am able to write only 255 characters, above that gets truncated.

 

I am using below code. Does anybody face such problem before and any resolution.