The nice thing about the Office OpenXML is that it’s the language of Microsoft Office — if you live your “office life” in Word and Excel (2007 and later), that’s the format you want. Can you “save” OpenXML directly to PDF? No, it needs to be rendered by some third-party component. If you’re doing document … Read more
Although the documentation for OpenXML isn’t great, there is an excellent tool that you can use to see how existing Word documents are built. If you install the OpenXml SDK it comes with the DocumentReflector.exe tool under the Open XML Format SDK\V2.0\tools directory. Images in Word documents consist of the image data and an ID … Read more
The sizes, in EMUs (English Metric Unit — read this for a good explanation), are set in the Extents (the Cx and Cy). In order to get a pic into a DocX I usually do it like so: Get the image’s dimensions and resolution Compute the image’s width in EMUs: wEmu = imgWidthPixels / imgHorizontalDpi … Read more
You can create a page break within a Run element using the <w:br> element. In raw OpenXML, it would look something like: <w:p> <w:r> <w:br w:type=”page” /> </w:r> </w:p> If you’re using the OpenXml SDK, you can use new Paragraph( new Run( new Break(){ Type = BreakValues.Page })); EDIT: If you just want to specify … Read more
Open XML stores dates as the number of days from 1 Jan 1900. Well, skipping the incorrect 29 Feb 1900 as a valid day. You should be able to find out algorithms to help you calculate the correct value. I believe some developers use DateTime.FromOADate() as a helper. Also, the Cell class has the DataType … Read more
If you are adding a string to a cell rather than a number (or a string that can be converted to a number) then you should use an inline string or a shared string instead of the CellValue. You can only use CellValue if the value is numeric. The XML generated when using CellValue looks … Read more
After reading your post above, I made a 100% native Python docx module to solve this specific problem. # Import the module from docx import document, opendocx # Open the .docx file document = opendocx(‘A document.docx’) # Search returns true if found search(document,’your search string’) The docx module is at https://python-docx.readthedocs.org/en/latest/
I wrote this quick example. It works for me. I only tested it with one dataset with one table inside, but I guess that may be enough for you. Take into consideration that I treated all cells as String (not even SharedStrings). If you want to use SharedStrings you might need to tweak my sample … Read more
I think this should do what you’re asking. The other function is there just to deal with if you have shared strings, which I assume you do in your column headers. Not sure this is perfect, but I hope it helps. static void Main(string[] args) { DataTable dt = new DataTable(); using (SpreadsheetDocument spreadSheetDocument = … Read more
The s attribute references a style xf entry in styles.xml. The style xf in turn references a number format mask. To identify a cell that contains a date, you need to perform the style xf -> numberformat lookup, then identify whether that numberformat mask is a date/time numberformat mask (rather than, for example, a percentage … Read more