openxml Questions
3
Solved
What are the measurement units used to specify sizes or X,Y cordinates in OpenXML? (Presentation).
Does it makes sense to match those with pixels, if so how can be those converted to pixels?
gr...
Jea asked 25/11, 2013 at 13:32
3
I am trying to create named ranges in Excel with OpenXML. I am able to add a DefinedName in the DefinedNames collection, but that does not seem to do anything. I noticed a place in the ExtendedFile...
2
Solved
I am trying to remove all formulas from a sheet using openxml. This what I am trying:
internal static void ReplaceFormulaWithValue()
{
var res = _worksheetPart.Worksheet.GetFirstChild<SheetDat...
Heid asked 25/4, 2017 at 10:2
2
Solved
Below given is a merge function which is intended to merge all docx files in a folder and produce the merged file.
public void Merge()
{
try
{
string sid = Request.QueryString["studid"];
st...
5
Solved
I have around 10 word documents which I generate using open xml and other stuff.
Now I would like to create another word document and one by one I would like to join them into this newly created do...
Dustidustie asked 21/8, 2013 at 7:55
2
Solved
I am creating a table in OpenXml with C# in a Word file. I used some code mentioned in this question to set the fontsize of the text in the cells. It works fine for the cells that contain text, but...
Tamarin asked 26/7, 2018 at 10:5
3
Solved
How to set the background of several cells within a row (or of a whole row) in OpenXml?
Having read several articles:
Coloring cells in excel sheet using openXML in C#
Advanced styling in Excel ...
2
I am using Open XML SDK for creating excel files.
I want to protect them with a password.
Do you know anyway to protect excel file with a password by using Open XML SDK?
I know "com" object way...
Oversight asked 1/3, 2013 at 22:35
5
Solved
I have a bit of code that will open a Word 2007 (docx) document and update the appropriate CustomXmlPart (thus updating the Content Controls in the document itself as they are mapped to the CustomX...
11
Solved
I've been looking around for a while now and cannot seem to find out how to do this.
I've got an excel sheet, which I'm reading using OpenXML. Now the normal thing would be to loop through the row...
6
Solved
I have a document that my asp.net page is creating and I need to align the text of certain columns to center. I have opened the document after manually center the columns in openXML SDK but the cod...
Columbary asked 20/3, 2012 at 13:24
2
Solved
I have to consume some xlsx documents. I've read Reading a date from xlsx using open xml sdk and http://www.dotnetperls.com/fromoadate. Most of my columns are texts (shared strings), but there are ...
Donnell asked 26/9, 2013 at 17:30
8
Solved
I have a date in format "4/5/2011" (month/day/year) in a xlsx file in one of the cells. Im trying to parse the file and load those data in some classes.
So far the part where I parse the ...
Agincourt asked 1/11, 2012 at 12:13
11
Solved
I have created a docx file from a word template, now I am accessing the copied docx file and want to replace certain text with some other data.
I am unable to get the hint as to how to access the t...
5
Solved
Using OpenXML, can I read the document content by page number?
wordDocument.MainDocumentPart.Document.Body gives content of full document.
public void OpenWordprocessingDocumentReadonly()
{
st...
Caldarium asked 12/10, 2016 at 7:29
6
Solved
I update some cells of an Excel spreadsheet through the Microsoft Office OpenXML SDK 2.0. Changing the values makes all cells containing formula that depend on the changed cells invalid. However, d...
Ebbarta asked 19/4, 2010 at 15:27
2
Solved
I am using Office Open XML and I have to add images at a specific points. On the document I have a 'tag' so I can locate it just fine. However, when I add more than one image, it corrupts the file....
5
Solved
I am trying to use openxml to produce automated excel files. One problem I am facing is to accomodate my object model with open xml object model for excel. I have to come to a point where I realise...
Helminthology asked 2/8, 2012 at 22:44
3
Solved
I have project about transforming Word DOCX XML (OOXML) files to HTML format.
I use XML Spy and XSLT, XPath, XML for this transformation.
Imagine a single Word file that I write a program in XSLT...
3
Solved
I am new to OpenXML (v. 2.5), and I can create rows and cells, but I need to be able to set the column width and I can not do that correctly for some reason.
Without this code:
Columns cols = ...
Chick asked 19/12, 2015 at 19:57
2
I'm using the OpenXml namespace in my application. I'm using this to read the XML within an Excel file. This works fine with certain excel files but on others I get a run time error saying
Inva...
Manmade asked 5/12, 2016 at 17:28
3
Solved
7
I have a column of data in an Excel sheet which has positive and negative values. What I want to be able to do is apply conditional formatting (a color gradient) from say dark green to light green ...
Ordain asked 25/11, 2015 at 20:33
6
Solved
About to go mad with this problem. I'm sure it's so simple I'm just missing it, but I cannot for the life of me find out how to change the content of a content control in Word 2007 with the OpenXml...
7
Solved
I'm reading an .xlsx file using the Office Open XML SDK and am confused about reading Date/Time values. One of my spreadsheets has this markup (generated by Excel 2010)
<x:row r="2" spans="1:22...
Ose asked 18/1, 2011 at 23:14
© 2022 - 2024 — McMap. All rights reserved.