Open XML reading XML

Question

0.00/5 (No votes)

See more:

I have a problem that I hope someone can assist me in. I have XML stored in a database and I need to render it on a report that is a word document (docx). All I can find in the run properties of open xml is Text. Does anyone know how to display xml through open xml?

Thanks
Jerry

Posted 14-Feb-13 1:33am

Member 9810595

Add a Solution

Comments

Sergey Alexandrovich Kryukov 14-Feb-13 13:43pm

I don't see a problem. You just need to load this document as docx in Word application. Your docx documents use Open XML format, that's all. What's the problem? Do you use Microsoft.Office.Interop? How would you normally load a document in Word? Or you need to display it in some other ways, not in Word?
—SA

Member 9810595 14-Feb-13 15:29pm

Sergey,
I am not using Microsoft.Office.Interop as I do not want to be dependant on word. When open xml adds the xml to the doc then it is added as a text instead of xml. When I open word, I see all of the xml tags. Any thoughts?????

Member 9810595 14-Feb-13 15:30pm

if you want I can send you a code snippit.

Sergey Alexandrovich Kryukov 14-Feb-13 15:40pm

At this moment, better look at my answer and see if some of my past answers are applicable to your code. They should be, because I refer to the standard and some cross-platform open-source projects working with those documents.

If you still want to discuss those possibilities, first tag your platform and language and only then provide some further detail; don't forget to explain your ultimate goals.
—SA

Sergey Alexandrovich Kryukov 14-Feb-13 16:30pm

Or, I see. As you use C#, maybe Solution 2 could be the best, but I never tried it. Look at it first...
—SA

Sergey Alexandrovich Kryukov 14-Feb-13 15:35pm

OK, I perfectly understand it. Yes, you can render the Open XML, but it will be a considerable work. What is your platform? application type or UI library? Language?
—SA

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-02-14T09:37:00

Solution 1

To start with, please see my past answers. Some part of them is devote to the cases when you want to work with Office documents directly. I did not do it (why?), but I know where to get some code. Please see:
Convert Office-Documents to PDF without interop[^],
Hi how can i display word file in windows application using c#.net[^],
Read a word file without using Interop.word dll...Do not want to install word in IIS..[^].

—SA

Posted 14-Feb-13 9:37am

Sergey Alexandrovich Kryukov

Comments

Maciej Los 14-Feb-13 15:54pm

Very good answer, as always. +5!

Sergey Alexandrovich Kryukov 14-Feb-13 16:21pm

Thank you very much, Maciej. "As always" is a huge exaggeration though :-)
—SA

Espen Harlinn 14-Feb-13 15:58pm

Nice links :-D

Sergey Alexandrovich Kryukov 14-Feb-13 16:21pm

Thank you, Espen.
—SA

Espen Harlinn · Answer 2 · 2013-02-14T09:58:00

Solution 2

You could try to use NPOI[^], it's a port of Apache POI to .Net.

Best regards
Espen Harlinn

Posted 14-Feb-13 9:58am

Espen Harlinn

Comments

Sergey Alexandrovich Kryukov 14-Feb-13 16:23pm

Interesting thing; I never heard of it. My 5. As I can see, this is a port, so it must be pure .NET, which is very good.
The only problem that OP still did not share what platform/language are to be used.
—SA

Espen Harlinn 14-Feb-13 16:25pm

Thank you Sergey :-D
>> The only problem that OP still did not share what platform/language are to be used.
It says c# 4.0 up at the top, so we can make an educated guess :-D

Sergey Alexandrovich Kryukov 14-Feb-13 16:29pm

Oh, I missed it; thank you. Then your solution must be the very best option. Did you try it?
—SA

Espen Harlinn 14-Feb-13 16:31pm

I've worked with the Apache java version, which worked well enough ...

Sergey Alexandrovich Kryukov 14-Feb-13 16:41pm

Good to know, I'll bookmark it. Thank you for sharing.
—SA