Open XML SDK tool - Does it retains formatting for Rich Text Area field.

Kirti Rastogi 0 Reputation points
2024-09-20T04:55:05.1433333+00:00

I wanted to inquire about the tool – Open XML SDK for office, used for text processing.

We are using this tool with our import data feature. Below is the use case for the same:

·        We will be importing the word/PDF docs into a Rich Text Area field in Salesforce. The data in the Rich text area field should be displayed with all the formatting/images etc. intact from the word/PDF docs – However, Open XML SDK office tool is not allowing us to retain the formatting in this case.

Please advise us over this if there is any limitation for the tool or you could suggest us the workaround for the same?

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,634 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,900 questions
Office Open Specifications
Office Open Specifications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
138 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,147 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
923 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Tom Jebo 1,996 Reputation points Microsoft Employee
    2024-09-20T17:26:47.8533333+00:00

    Hi Kirti Rastogi,

    Because this question is specifically about the Open XML SDK library, questions should be directed to the repo for this library and not here on Q&A. Here is the issue list: https://github.com/dotnet/Open-XML-SDK/issues

    I can tell you that the Open XML SDK library does not do any conversion of PDF or WordprocessingML to Rich Text. While it can consume and allow manipulation of WordprocessingML (.docx packages) it does not contain Rich Text capabilities. You might find another library or tool to help with that but the Open XML SDK won't be able to do it.

    You might also post your question to https://stackoverflow.com/questions/tagged/openxml-sdk or just Stack Overflow in general and ask if anyone knows of a programmatic tool for Rich Edit conversion.

    Best regards,
    Tom Jebo
    Microsoft Open Specifications Support

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.