Category "openxml"

OpenXML to Excel: CellFormat Problem - Open Excel-Template and insert datatable to existing Excel-Table with formatted columns

I am getting some data as JSON via RESTful web api and transforming it into a datatable. Afterwards I want to open an "Excel template" (*.xlsx) with OpenXML and

Constructing an OpenXmlElement from bitmap picture to append into a Run instance

I have the following code: string replaceValueString = parameterValue.ToString(); Run replaceRun = new Run(); replaceRun.Append(new Text(replaceValueString)); c

How do I clone existed complicated rows to the work sheet using openxml

I need to clone exists rows to the work sheet dynamically. ex. I wanna copy row 28, 29 and insert into 30, 31, or 32,33, or more maybe, it depends on the data r

OpenXML how to make text bold

I use openXML to write a word document containing my text. Now I want to make a part of the text bold. I however fail to find a solution to make my text bold, s

How to set font size in empty cell of a Word table using the Open XML SDK?

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

Add Dropdown Validation to an entire Excel Column using OpenXML

In Excel, I am able to add validation rules to a range of cells and limit the accepted input to a list of values displayed in a dropdown. This is done using the