Link to home
Start Free TrialLog in
Avatar of inzaghi
inzaghi

asked on

Problems with the < character in excell

I am writing data to excell settign the content type to <meta http-equiv="Content-Type" content="application/vnd.ms-excel; charset=UTF-8" />

if I have data such as 'Table <55' the data
'Table' gets printed in the cell but the remaining data <55 is ignored?

Any ideas?
ASKER CERTIFIED SOLUTION
Avatar of colr__
colr__

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of colr__
colr__

You'll have to apply replaceAll("<", "&lt;") and replaceAll(">", "&rt;") to your data set before writing it to the excel sheet (assuming its a string obejct youve got).

colr__
Apologies, its &gt; for the right tag.

colr__