XLM Excel conversion

[raouln97]

Hey there!
i'm trying to convert an excel to xlm and then replace certain PII information with labels. These labels should be colored red and then finally all the content is converted back to excel
this flow majorly works but i have issues when trying to inject color into the labels

would appreciate any assistance here please :)

[Progressandfortuna]

(Not the dev, just forked), but:

• what do the errors return? given that it's the main function.
• these PIIs, are they Values, names, or integers? If they're integers, you might need to thoroughly re-read the doc:

From the XML Builder to ALL options here.

Since this just seems like a vanillaJS inline code issue to me; HOWEVER I will assume that you NEED data authenticity and integrity with this .xlsx (I assume) file.

[raouln97]

There weren't any errors actually, i tried to set the font color of the required text but instead it gave me something like this:

BR Law Corporation

9 PLACES-899 Place

#8-03 PLACES-901 Plaza

Singapore 048619

Tel: 65-63881717

Fax: 65-63947398

Email: siva@brlawcorp.com

^ these were the contents of one cell

the initial structure of an xml cell i was trying to redact was something like this:

There weren't any errors actually, i tried to set the font color of the required text but instead it gave me something like this:

---

BR Law Corporation

9 Monk Place

#8-03 Century Plaza

Singapore 048619

Tel: 65-63881717

Fax: 65-63947398

Email: siva@brlawcorp.com

i'm assuming that i would have to split the text into different tags and subsequently add colour in there for the identified words to redact