Tagged Questions
0
votes
0answers
10 views
Convert Word docx to Excel using OpenXML
Is there any way to convert Word document where I have some tables into Excel file?
It would be very helpful to convert tables.
Something like that:
Open Word document using OpenXML
Find all tables ...
0
votes
0answers
28 views
OpenXml Save Excel Embeded Object in Word c#
I am trying to open an excel table, which is embeded in an word document.
As it is stored in binary data i read it from stream and get it. In the excel table and in the word document are some values ...
-1
votes
3answers
180 views
looking for alternative to Excel spreadsheets as a data collection mean [closed]
Someone wants me to implement a server side data extraction service to extract data from Micorsoft Excel 2010 spreadsheet (xlsx). A spreadsheet must have data in the correct places in order for the ...
1
vote
2answers
24 views
Sending Excel file to User working with Chrome and IE but not firefox(Get file with no extension)
I am generating and excel file using the OpenXML library and sending it to the user.
It works very well with Chrome and IE but when i tried it with Firefox i came upon a problem.
When saving the file ...
1
vote
1answer
238 views
After updating a cell and save excel, formulas based on this cell doesnt recalculate
Hi,
Im using XML SDK to update some cells on an excel file.
This is the code that im using to update a cell for a given text (and its working fine).
WorksheetPart worksheetPart = ...
4
votes
1answer
92 views
OpenXML Spreadsheet: Excel gives an error, then mends it and it works. (C#)
I narrowed it down to:
//aantal auto's
Row aantalAutosRow = new Row();
aantalAutosRow.RowIndex = Convert.ToUInt32((tblXML.Rows.Count) + 2);
Cell aantalAutosCell = new ...
1
vote
1answer
579 views
OpenXML Sdk VML Set CheckBox Checked
ControlPropertiesPart c2 = util.getCheckBoxByLabel(worksheetPart, "ENV");
c2.FormControlProperties.Checked = DocumentFormat.OpenXml.Office2010.Excel.CheckedValues.Checked;
...
0
votes
0answers
102 views
Create Excel file containing HTML table, all done with Javascript (contains OpenXML). Need to be able to set a name for the file
Whats up folks,
my question is actually not how is such a thing done (cause I've already a code snippet) but my question is how do I set a name for the file which I create...
The code I have...
...
-1
votes
1answer
55 views
How to add Conditional Formatting to an XML / Excel file?
I'm generating an Excel file by writing the XML for it. I am almost done, but I can't get the conditional formatting to work the way I want.
I want to apply a condition to certain cells. E.g. for ...
-1
votes
0answers
24 views
Multi series chart in OpenXML [closed]
Does anyone knows how do I draw a chat in Excel using c# OpenXML?
For example I want to draw the following chart:
Name | Param1 | param2
A | 1 | 2
B | 3 | 4
Thank you!
0
votes
0answers
29 views
OpenXML 2.5 reading formatted cells issue
I am using OpenXML in my MVC 4 project to read an excel file and store its content in a table in the DB.
Excel file: http://oi33.tinypic.com/qosggz.jpg
Cells J5 and following are formatted using the ...
0
votes
0answers
38 views
How to copy Excel stylesheet in openxml
I am new to OpenXML.
I have a defined template. I want to use the same style defined in this template to create another sheet. I googled but didn't get it.
See the code below -
WorkbookPart ...
0
votes
1answer
106 views
how to convert xml to excel sheet of same name using c#.net
I use following code and its working. But every time it create an excel sheet with same name.
Can anybody tell me how export excel sheet with same name as XML sheet has???????
private void ...
0
votes
0answers
28 views
How to copy an Excel Template to another sheet in same Excel?
I am new to OpenXML. My concepts are not clear completely.
I am using following code -
Package package = Package.Open(newFile.FullName, FileMode.Open, FileAccess.ReadWrite);
excelDoc = ...
0
votes
0answers
34 views
Formula processing in OpenXML
I have an Excel workbook which has the template design with formatting,styles,required formula,named ranges.I have a template row with the appropriate cell formatting and cell formula.Using the ...
0
votes
0answers
77 views
Does anyone have full list of Excel cell styles?
I would like to recognize if cell value is hour or data. Some cells have StyleIndex set to 38, 39 etc. which - I believe - means it is a hour in cell.
Could anyone provide mi a full list of Excel ...
1
vote
1answer
78 views
OpenXML SDK - Combine multiple Excel Files
I have 2 files.
I have Test1.xlsx and Test2.xlsx that I need to combine it problematically.
What is the best way to do this? I am using C#, MVC 3.
I have seen mention of AltChunk but have seen it ...
3
votes
3answers
3k views
How to retrieve Tab names from excel sheet using OpenXML
I have a spreadsheet document that has 182 columns in it. I need to place the spreadsheet data into a data table, tab by tab, but i need to find out as im adding data from each tab, what is the tab ...
7
votes
1answer
556 views
open xml to query excel cells
In the past, I have created a component to pass and retrieve values to/from excel using the excel libraries. The good thing is that once you have your workbook in memory and modify a cell (let's call ...
0
votes
3answers
567 views
With C# is it possible to put an object on the clipboard that will paste into excel as data and formulas?
In a WPF application, I need to generate data that can be put on the clipboard and pasted into excel. I need to paste something that can carry over data and formulas.
I was attempting OpenXML... but ...
3
votes
6answers
5k views
Excel Open XML error: “found unreadable content” when creating simple example
I am getting the ambiguous "excel found unreadable content" error when I try to open the document created by the following code:
public void GenerateWorkbookFromDB()
{
//Make a copy of the ...
2
votes
1answer
100 views
programmable naming variables? [closed]
I have an Excel Automation project using Open XML SDK 2.0 in ASP.NET. I use Open XML SDK 2.0 Productivity Tool for generate code for my excel file. Сontains lines such as
row9.Append(cell1043);
...
1
vote
0answers
123 views
Opening excel file prompts a message box “content recovery of the workbook”
While I'm trying to open excel file a message box is prompting like "We found a problem with some content in file name. Do you want us to try to recover as much as we can? If you trust the source of ...
1
vote
1answer
143 views
Accessing row cell count in Excel Spreadsheet
I need to know how to get the count of cells in a Row object using OpenXML. Currently, I am using
row.Descendants<Cell>().Count<Cell>()
but this is not correct at all. Any ideas what ...
1
vote
1answer
62 views
Embed XML into Excel worksheet
I do have an XML file which contains several calculated values along with a list of items such as:
<?xml version="1.0" encoding="utf-8"?>
<XmlContent>
<Elements>
...
5
votes
3answers
7k views
Export DataTable to Excel with Open Xml SDK in c#
Sorry for my english please.
I'm new in open xml sdk.
My program have ability to export some data and DataTable to Excel file (template)
In the template I insert the data to some placeholders. It's ...
0
votes
0answers
151 views
Updating excel in different rows using OpenXML.Word
Am using OpenXML.Word for the creation and updation of the excel(.xlsx) file in Isolated Storage for windows phone . Ideally ,in this case the value should be fed in the next row of the excel file on ...
0
votes
1answer
301 views
Excel File Password Protection with Open XML SDK
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 to ...
2
votes
1answer
346 views
how to create xlsx files using coldfusion
Disclaimer: I am new into coldfusion.
I am trying to create an Excel 2010 document with images and multiple tabs.
I have been able to get this to output into XLS, but I cannot get the image into the ...
3
votes
3answers
2k views
How to get chart info from an Excel spreadsheet using Apache POI?
Is it possible to extract chart information from an Office 2007 (xlsx / OpenXML) spreadsheet using Apache POI? I've managed to read in the spreadsheet and even get the part that refers to the chart ...
0
votes
3answers
1k views
Reading data from an Excel document stored in Sharepoint?
How can I 'read' an excel 2003 document stored as a sharepoint spfile? I can retrieve the document from the library with no problems using the SPFile.OpenBinary() and then putting that into a ...
0
votes
0answers
294 views
How to get value from merged-cells in Excel document using OpenXML and C#
I have problem with merged cells. If I have value in first cell (B3) and this cell is merged with some others cells (for example C3, D3, E3, F3, F4) - in Excel document I can see only one value. This ...
0
votes
1answer
113 views
How do Excel recognize Date cells and how to do the same using OpenXml and C#
I have spent a few hours but still have no satisfying answer.
When I click cell in excel document it is marked as Date field. However, if I use OpenXml to investigate DateType - I will receive Cell ...
0
votes
0answers
83 views
Formatting cell values from OpenXML
I'm opening up xlsx files as a package and reading the contents of the xml files. I'm able to get the shared strings, borders, etc that I need and it's orders of magnitude faster than when I was using ...
0
votes
1answer
218 views
Embed Excel into Powerpoint 2007 using openxml and C#
Running into two problems that I'm hoping someone can assist.
I am trying to embed a excel 2007 file in relationship with a chart into pptx 2007 programmatically using openxml.
I manually created a ...
1
vote
3answers
306 views
How can I get WorkbookPart from WorkSheet?
I am trying to create Excel file using OpenXML SDK. I have one situation to get WorkBookPart from WorkSheet instance. How can I get it?
Thanks.
Ant.
0
votes
3answers
116 views
Does a good wrapper class and/or library for open xml Excel editing exist?
I'm looking for a nice library for editing and/or generating Excel documents on our Windows server. I feel that the open xml sdk is probably the way to go, but to me the learning curve seems steep ...
6
votes
8answers
7k views
reading Excel Open XML is ignoring blank cells
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 ...
11
votes
4answers
15k views
From Excel to DataTable in C# with Open XML
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 it ...
0
votes
1answer
241 views
Get Tables (workparts) of a sheet of excel by OpenXML SDK
I have 3 tables in a sheet of excel file,
and I use OpenXML SDK to read the Excel file, like this:
SpreadSheetDocument document = SpreadSheetDDocument.open(/*read it*/);
foreach(Sheet sheet in ...
0
votes
1answer
281 views
How to disable gridlines in Excel using open xml C#?
I want to disable GridLines in excel and put custom borders to excel cells using open xml in C#
I have tried with below code but is throwing exception when i open the excell,
the exception is ...
0
votes
1answer
220 views
OpenXML (SAX Method) - Adding row to existing tab
I am trying to create an Excel document using OpenXML (SAX method). When my method is called I want to check to see if a tab has already been created for a given key. If it is I would like to just ...
-1
votes
1answer
113 views
datagrid as excel editor in c#
I have a requirement to display data from excel document in a C# win form datagrid. Add formula functionality of excel and apply in the datagrid value. When saving datagrid values to a excel value ...
0
votes
1answer
37 views
Microsoft Open XML unsaved file
Is it possible, through VBA, to get the Open XML definition of the current, unsaved workbook (without saving it)?
Carlos
1
vote
1answer
2k views
Inserting WorkSheet with Open XML - “…unreadable content…”
When I follow this tutorial:
http://msdn.microsoft.com/en-us/library/cc881781.aspx
to open an Excel document and insert an empty worksheet the final result is a message telling "Excel found ...
2
votes
2answers
2k views
How to output an excel spreadsheet with images from ASP.net
Suppose I'm writing an ASP.net web application.
The original designer of the application was using "PopChart" to make some images appear in the web application. One of the pages had an "Export To ...
1
vote
1answer
297 views
How to set cells' background?
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 ...
5
votes
3answers
1k views
How to export a JQgrid data to Excel using c#?
I have made some research regarding this but most of the solutions are for MVC.. I am just using Asp.net 3.5 How could i achieve this on button click.. Should i include any library or anything else.. ...
2
votes
1answer
267 views
Round-tripping XML -> Excel -> XML
I'd like to use Excel's XML Map feature from server-side C# in a web app. XML maps enable you to associate an XML schema with a workbook and specify which cells map to which parts of the schema. From ...
0
votes
0answers
143 views
Changing a Cells Format with Open XML SDK 2.0
I've looked at other posts but I'm getting confused, so I thought I would ask. I have an Excel Spreadsheet that I have to apply a date format to 2 columns before I open/read it with an odbc ...
