Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

XLM Excel conversion #706

Open
raouln97 opened this issue Jun 5, 2024 · 2 comments
Open

XLM Excel conversion #706

raouln97 opened this issue Jun 5, 2024 · 2 comments

Comments

@raouln97
Copy link

raouln97 commented Jun 5, 2024

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
Copy link

(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
Copy link
Author

raouln97 commented Jun 10, 2024

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: [email protected]

^ 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: [email protected]

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants