Several different colors in one single cell

[zajjoseph]

Hi,

I'm using this great powerful library. Now what I need is to write several words in different colors in one single cell. Could that be possible?

Any help will be appreciated, thanks!

[pietersv]

That's an interesting one. That's not a feature right now. What you can do is

• create two simple workbooks, one with multiple colors, one without
• save it to a new directory
• unzip it (e.g. jar -xvf wb.xlsx)
• open the worksheet and styles .xml files for each in a dev IDE
• reformat the code to be pretty
• difference them and see what changed
• hack the code to add that capability however crudely to the xlsx code
• remember that the xlsx.js file at the top is generated from the bits/*.js files
• you can test changes in xlsx.js for speed, later re-implement in the bits/ directory

[zajjoseph]

Thanks a lot for the answer. I'll try as you said :)