openxml Questions
4
Solved
I am using ClosedXML to generate spreadsheets from C# (asp.net-mvc) and it works great. I have one additional requirement so I wanted to get some feedback on how I could achieve this.
I want to sa...
Kinata asked 1/4, 2014 at 13:6
2
When inspecting a cell element in XLSX file, I find the following formula element:
<f t="shared" si="0"/>
What is the meaning of such a formula element?
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
2
I'm using OpenXml to generate excel files and after swimming in tons of different sample codes and SDK Productivity Tool, finally managed to get what I wanted. There's just one thing I can't get ar...
Collogue asked 27/2, 2012 at 11:43
5
Solved
I have the following (highly simplified) XML document that I am reading into my database using the OPENXML function:
<root>
<row>
<bar>123</bar>
</row>
<row>...
Cannula asked 20/5, 2010 at 21:22
7
Solved
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 pan...
3
Solved
I'm currently using something like this to insert inline string in a cell :
new Cell()
{
CellReference = "E2",
StyleIndex = (UInt32Value)4U,
DataType = CellValues.InlineString,
InlineStri...
Mcclurg asked 8/4, 2009 at 22:3
3
Solved
I've generated a .xlsx spreadsheet in C# using the OpenXML SDK, but can't figure out how to get cell styles working. I've been studying files produced by Excel, and can't quite figure out how it's ...
Ns asked 20/6, 2012 at 9:5
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
5
Solved
I read Excel files using OpenXml. all work fine but if the spreadsheet contains one cell that has an address mail and after it a space and another word, such as:
[email protected] abc
It ...
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
3
Solved
I using OpenXML to export Datagridview to Excel. If I export cells with CellValues.String evertyhing works fine without any errors in Excel file, but what I need is to properly convert all Date and...
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
8
Solved
How to convert
org.apache.poi.hssf.usermodel.HSSFWorkbook
to
org.apache.poi.xssf.usermodel.XSSFWorkbook
in Apache POI?
Environment :
JSE1.6
JBossAS 4.3.2
POI 3.7
Broncobuster asked 29/8, 2011 at 13:31
15
Solved
I'm receiving an error when opening my OpenXML created spreadsheet. The error is as follows.
Repaired Records: Cell information from /xl/worksheets/sheet.xml part
Repaired Records: Cell informatio...
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
3
Solved
My C# app uses OpenXML to create a MSWord doc with several tables in it already. The last part is to add a barchart. I can't find a good example of this case.
Thanks for your help!
I am creating ...
Kame asked 22/2, 2017 at 21:2
4
Solved
I have the following code:
using (var doc = WordprocessingDocument.Open(filename, true))
{
....
}
Where string filename is a valid path to a docx file.
But calling Open causes the following In...
4
Solved
I'm a teacher. I want a list of all the students who commented on the essay I assigned, and what they said. The Drive API stuff was too challenging for me, but I figured I could download them as a ...
Lanai asked 20/11, 2017 at 11:26
5
Solved
Using the OpenXML SDK, 2.0 CTP, I am trying to programmatically create a Word document. In my document I have to insert a bulleted list, an some of the elements of the list must be underlined. How ...
Donatist asked 21/12, 2009 at 15:57
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
1 Next >
© 2022 - 2024 — McMap. All rights reserved.