Leonidas-from-XIV / node-xml2js

XML to JavaScript object converter.
MIT License
4.84k stars 596 forks source link

XLM Excel conversion #706

Open raouln97 opened 1 month ago

raouln97 commented 1 month ago

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 commented 1 month ago

(Not the dev, just forked), but:

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 commented 3 weeks ago

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

08-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 #08-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