Stack Overflow
Stack Overflow

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
5 answers

Freeze Panes in OpenXml SDK 2.0 for Excel document

I'm generating an Excel workbook using OpenXml and have been following the examples at http://msdn.microsoft.com/en-us/library/cc850837.aspx It would be really useful if I could freeze the top panes, but I can't find a way to do this. I realise that…
Adam
  • 619
  • 1
  • 4
  • 19
7
votes
1 answer

Why does my custom XML not carry over to a new version of a DOCX file when Word saves it?

I'm adding in some custom XML to a docx for tracking it inside an application I'm writing. I've manually done it via opening the Word Document via a ZIP library, and via the official Open XML SDK route. Both have the same outcome of my XML being…
John Mc
  • 444
  • 2
  • 15
7
votes
1 answer

Is the Rich Text Format deprecated?

From the Wikipedia page on Rich Text Format (http://en.wikipedia.org/wiki/Rich_Text_Format): As of March 2008, the current version is 1.9.1. According to Microsoft's Office 2010 resource kit documentation, Microsoft is discontinuing enhancements…
Brett
  • 4,066
  • 8
  • 36
  • 50
7
votes
1 answer

SXSSFWorkbook.write to FileOutputStream writes huge files

I'm trying to use SXSSFWorkbook to write an Excel spreadsheet from scratch. wb = SXSSFWorkbook(500) wb.isCompressTempFiles = true sh = streamingWorkbook.createSheet(t.getMessage("template.sheet.name")) All is fine but when I…
Mircea D.
  • 331
  • 4
  • 14
7
votes
2 answers

OpenXml Spreadsheet. Value filters, styles and unicode characters

because of small documentation i have problems with OpenXml SpreadSheetDocument in C#. How to make top row with filter? How to make colors to alternate? I want to put unicode characters in my SheetData, but when i oppen the excel it gives me an…
croisharp
  • 1,926
  • 5
  • 25
  • 40
7
votes
2 answers

Issue with find and replace apostrophe( ' ) in a Word Docx using OpenXML and Regex

Word seems to use a different apostrophe character than Visual Studio and it is causing problems with using Regex. I am trying to edit some Word documents in C# using OpenXML. I am basically replacing [[COMPANY]] with a company name. This has…
mfontaine
  • 75
  • 6
7
votes
2 answers

OpenXML file download without temporary file

Is there a way of providing a download in an ASP.Net Page for a freshly generated OpenXML (docx) file without saving it in a temporary folder? On MSDN I only found a tutorial for using a temp file but I thought about using the…
Kuepper
  • 992
  • 13
  • 39
7
votes
1 answer

Unable to append a sheet using OpenXml with F# (FSharp)

The CreateSpreadsheetWorkbook example method from the OpenXml documentation does translate directly to F#. The problem seems to be the Append method of the Sheets object. The code executes without error, but the resulting xlsx file is missing the…
Dan Buskirk
  • 73
  • 4
7
votes
2 answers

Word/OpenXML - How do I create a hidden bookmark?

I've not had any luck in either the OpenXML API or Word/VSTO API, finding a way to create or modify a bookmark's visibility. Even adding bookmarks manually in Word, there's no box to check to make the bookmark hidden. Although there is a checkbox in…
System.Cats.Lol
  • 1,620
  • 1
  • 26
  • 47
7
votes
1 answer

open xml to query excel cells

In the past, I have created a component to pass and retrieve values to/from excel using the excel libraries. The good thing is that once you have your workbook in memory and modify a cell (let's call it the origin cell) all the other cells with…
Jose3d
  • 9,149
  • 6
  • 33
  • 54
7
votes
1 answer

MemoryStream is empty for an OpenXML Excel document

I would normally use ClosedXML to generate Excel files. A Core project is forcing me to use only OpenXML. The resulting Excel file will be downloaded. I am having an issue where the memory stream given to the SpreadsheetDocument is empty. I have…
Darren Wainwright
  • 30,247
  • 21
  • 76
  • 127
7
votes
1 answer

OpenXML nested tables

I am trying to insert a Table into a TableCell, but when I try to open it in MS Word I get a message like: "a

is required before a ". When I open the file in compatibility mode the table formatting looks perfect but the table lines are…

flayn
  • 5,272
  • 4
  • 48
  • 69
7
votes
2 answers

How to fix this bullet issue

In my website, admin uploads a .docx file. I convert the file into xml using OpenXmlPowerTools Api. The issue is the document has some bullets in it. • This is my bullet 1 in the document. • This is my bullet 2 in the document. XElement html =…
Kgn-web
  • 7,047
  • 24
  • 95
  • 161
7
votes
1 answer

Office Open XML bullet list

I'm trying to create a office open xml document with a bullet list in it. But instead of showing the bullets, the document shows a numbered list. This is what I look for: Paragraph 1 Paragraph 2 And instead I get the following list: Paragraph…
chobin
  • 165
  • 1
  • 11
7
votes
4 answers

How to ensure that the OpenXml assembly doesn't cause a conflict with SpreadsheetLight?

I Nugot SpreadsheetLight. To subsequently use it, I need to add the following usings: using DocumentFormat.OpenXml; using DocumentFormat.OpenXml.Spreadsheet; using SpreadsheetLight; For the first two ("DocumentFormat") to be recognized, I needed to…
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
1 2 3
…
99 100