openxml-sdk Questions
5
Solved
I want to apply the % (percentage) number format using open XML C#
I have numeric value 3.6 that I want to display that number in excel as `3.6%.
How do I achieve that?
Ileum asked 24/10, 2011 at 6:47
5
Solved
I want to implement openXml sdk 2.5 into my project. I do everything in this link
using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
us...
Rubellite asked 16/4, 2014 at 6:48
5
Solved
Task
Import data from excel to DataTable
Problem
The cell that doesnot contain any data are getting skipped and the very next cell that has data in the row is used as the value of the empty colu...
Cimex asked 19/3, 2016 at 9:23
3
Solved
Using C#, is there a good way to find and replace a text string in a docx file without having word installed on that machine?
Ailis asked 30/7, 2010 at 22:26
17
Solved
I am using the accepted solution here to convert an excel sheet into a datatable. This works fine if I have "perfect" data but if I have a blank cell in the middle of my data it seems to put the wr...
Maraca asked 1/10, 2010 at 9:35
4
Solved
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 firs...
Twirl asked 22/3, 2016 at 21:31
2
Solved
i have try to make bold the specific text using
Bold fbld = new Bold();
but it will make bold hall cell.
Here in above image there is some bold text into the cell.
How can I do this in Open...
Triste asked 4/10, 2016 at 12:59
9
Solved
I'm using Visual Studio 2008 and I need create a DataTable from a Excel Sheet using the Open XML SDK 2.0. I need to create it with the DataTable columns with the first row of the sheet and complete...
Expertize asked 23/7, 2010 at 18:9
4
When creating an Excel spreadsheet using the Open XML SDK v2.0, our Excel output initially worked successfully for a number of months. Recently Excel (all versions) began to complain about "Excel f...
Erudite asked 30/4, 2011 at 14:6
3
Solved
I am doing some string replacement within a Word Docx file using OpenXML Power Tools and it is working as expected. However things break when I have invalid characters in the substitution such as a...
Gwynethgwynne asked 29/3, 2015 at 1:16
2
We have a master docx with the header and footer in and nothing else (formatted with images). We have 100s of word documents with body content but no header and footer and we want to be able to pro...
Brader asked 4/10, 2017 at 8:25
3
Solved
I am parsing some Openxml word documents using the .Net OpenXml SDK 2.0. I need to replace certain sentences with other sentences as part of the processing. While iterating over the paragraphs, I k...
Snowflake asked 25/11, 2010 at 10:35
8
I know that there are different ways to read an Excel file:
Iterop
Oledb
Open Xml SDK
Compatibility is not a question because the program will be executed in a controlled environment.
My Requi...
Baste asked 21/10, 2012 at 8:36
2
Solved
I have created a Word template that I am then processing via the OpenXML SDK to replace some of the content of the document with data from a database query.
The template consists of some basic tex...
Flatways asked 28/11, 2011 at 16:16
12
Solved
I assume v2.0 is better... they have some nice "how to:..." examples but bookmarks don't seem to act as obviously as say a Table... a bookmark is defined by two XML elements BookmarkStart & Boo...
Mcglynn asked 22/7, 2010 at 11:27
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
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
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
3
Solved
I am trying to get the backgroundcolor of a cell in a excel-spreadsheet. I am using Open XML 2.0 SDK and I am able to open the *.xlsx-file and to get cell-values for example. My code for getting th...
Epact asked 25/5, 2012 at 14:27
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
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
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
3
Solved
I have a Word table with 2 columns. I am trying to get Word not to squeeze column1 when column2 has long text that wraps.
here is the intended layout:
column1 Column2
------- -------
1. Lon...
Dermatoglyphics asked 25/3, 2015 at 3:33
1 Next >
© 2022 - 2024 — McMap. All rights reserved.