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

Question

Hi all,&nbsp;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.&nbsp;I am using below code. Does anybody face such problem before and any resolution.&nbsp;&nbsp;

rraghvani · Answer

See&nbsp;Excel specifications and limits and note&nbsp;Arguments in a function is 255.
&nbsp;
See if using&nbsp;Working With Excel Files via COM resolves the issue.

Forum Discussion

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

Related Content

Previously working code w.r.t Sys.OleObject("Excel.Application") not working with 12.42

The property Sys.OleObject("Excel.Application") don't find a running Excel application.

=,& characters are replacing with special Character

DDT excel driver and Sys.OleObject("Excel.Application") are throwing exception

Sending special character

Recent Discussions

Problem with generated data table and keyword test

System checks for Object for every test

SE Tip : Drag-and-drop one object to another

Unable to re-cert TestComplete-Certification

Tech article will not submit