Questions tagged [openxml]

Questions regarding reading and writing of Microsoft Office Open XML files either through direct manipulation of the XML files contained in a zip package or through the Microsoft Office Open XML SDK.

Office Open XML File Formats Official Standard

http://www.ecma-international.org/publications/standards/Ecma-376.htm

Microsoft Office Open XML SDK 2.0

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C6E744E5-36E9-45F5-8D8C-331DF206E0D0&displaylang=en

3743 questions
7
votes
1 answer

Insert OpenXmlElement after word bookmark in Open XML SDK

I was able to access a bookmark in my word document using this code: var res = from bm in mainPart.Document.Body.Descendants() where bm.Name == "BookmarkName" select bm; Now…
akosch
  • 4,326
  • 7
  • 59
  • 80
7
votes
2 answers

how to create xlsx files using coldfusion

Disclaimer: I am new into coldfusion. I am trying to create an Excel 2010 document with images and multiple tabs. I have been able to get this to output into XLS, but I cannot get the image into the file. I have not been able to find a complete…
BTThomas
  • 151
  • 1
  • 2
  • 8
7
votes
2 answers

Problem using large binary segment in OOXML

System Description A plotting component that uses OOXML to generate a document. Plotting component consists of several parts. All parts are written in C++ as exe + dll's, with the exception of the interface to the OOXML document. The latter…
QBziZ
  • 3,170
  • 23
  • 24
7
votes
1 answer

Underlining and bolding text

how do I get the text to be underlined and bold? My text gets bold but does not get underlined. Here is some of my code, which is pretty straight forward uses run properties to bold and underline the given text. Run run_header =…
AustinT
  • 1,998
  • 8
  • 40
  • 63
7
votes
1 answer

Setting Excel spreadsheet column properties issue

I'm trying to set up default column width in Excel spreadsheet using OpenXML framework and as a result I've got broken file. Here is code private void initSpreadsheetDocument() { // Add a WorkbookPart to the spreadsheet document. …
Andriy Zakharko
  • 1,623
  • 2
  • 16
  • 37
7
votes
2 answers

How do I create a date-formatted cell using RubyXL?

I'm using RubyXL to dynamically generate a spreadsheet file that contains some dates. The documentation is kind of sparse so I've been looking at the source, and it appears the library only has special handling for Date and DateTime when you call…
benzado
  • 82,288
  • 22
  • 110
  • 138
7
votes
2 answers

XLSX- how to get rid of the default namespace prefix x:?

I'm generating XLSX spreadsheet using OOXML SDK, and I need to get rid of x: namespace prefix. How can I achieve this? using (SpreadsheetDocument doc = SpreadsheetDocument.Open("template.xlsx", true)) { //Save the shared…
user116884
  • 81
  • 1
  • 4
7
votes
1 answer

Open XML: Word - Getting all Paragraphs marked as "Heading1" style

Using Word I have created a Docx with the standard normal.dot as a test. Hello-world level complexity. I wish to get all the paragraphs which are styled with the "Heading1" style in Word. I can get all the paragraphs, but don't know how to filter…
Ian Vink
  • 66,960
  • 104
  • 341
  • 555
7
votes
8 answers

Excel found unreadable content in *.xlsx

I am working on generating an excel template from code. When I run the piece to create my WorkBook, I get no errors in code, however when I go to open the Excel document, I get an error indicating that the file is unreadable. I am able to click to…
Kobojunkie
  • 6,375
  • 31
  • 109
  • 164
6
votes
1 answer

.NET WinForms Editor Control that supports RTL\Hebrew and export to OOXML\PDF?

I'm interested in replacing an aging control we use in our project that is a simple HTML WYSIWYG editor. The main requirements i'm looking for are as follows: Support for RTL/Hebrew input. Support for custom numbering styles (not just 1. 2. 3., A.…
Ran Sagy
  • 610
  • 7
  • 17
6
votes
1 answer

PPTX - Finding out whether text is bulleted from OpenXML

I have not been able to find any indicator which could tell me whether text in txBody tag is bulleted or not, can you please me in identifying which indicator should I use to understand whether the text is bulleted or plain ? -Thank you
6
votes
2 answers

How do you use the OpenXML API to read a Table from an Excel spreadsheet?

I've read a bunch of stuff on the web about how to get at cell data using the OpenXML API. But there's really not much out there that's particularly straightforward. Most seems to be about writing to SpreadsheetML, not reading... but even that…
Todd McDermid
  • 1,650
  • 11
  • 12
6
votes
1 answer

Copy/Paste after creating an Excel file using OpenXml

I'm using OpenXml to generate excel files and after swimming in tons of different sample codes and SDK Productivity Tool, finally managed to get what I wanted. There's just one thing I can't get around. When I open my files using Excel and try to…
Mehdi Jalili
  • 61
  • 1
  • 3
6
votes
2 answers

How can I identify an OpenXml Paragraph as one I programmatically inserted?

I am programmatically adding an OpenXML paragraph to a Word Document and I need to be able to identify that paragraph as mine later on. Any ideas on how to do this? I have tried inserting an XML comment and extended attributes but when you save…
Stacy
  • 61
  • 1
  • 2
6
votes
2 answers

OpenXML Power Tools trouble compiling: 'OutputTypeAttribute' could not be found

I am using the OpenXMLSDK for some DOCX manipulation. I am trying to compile the OpenXML Power Tools source for help with this. I read that I needed to instal the MS Power Shell for this to compile (for its use of Cmdlets), so I downloaded it from…
Ian Herbert
  • 1,071
  • 2
  • 16
  • 35