I have Excel .xlsx document in which I need to import some values to cells with defined names. Few of those cells are formated as currency and values that I'm importing in those cells are of decimal type which I import in this manner: cell.CellValue = new CellValue(value.ToString().Replace(",", ".")); In the same spreadsheet there are...
I'm trying to use a docx read in via the OpenXML SDK as template in a .Net web app for form letters (essentially). I have a docx with the formatting I want, marked up with XML Schema tags defined from a xsd (whatever they're called, the help is exceedingly useless on this). The only thing similar I found on Google was what seemed to be ...
ALTER PROCEDURE GetSingersGenere (@SingerData ntext) AS BEGIN DECLARE @hDoc int exec sp_xml_preparedocument @hDoc OUTPUT,@SingerData IF OBject_id('SingerTable') IS NOT NULL BEGIN DROP TABLE SingerTable END CREATE TABLE SingerTable ( SingerName varchar(200) ) INSERT INTO SingerTab...
Hi. I am using the OpenXML libraries from C# to read Excel files. One of my requirements is to be able to show the exact formula for each cell that has one. The OpenXML encoded file uses "shared formulas" to reduce file size. Like this: D3 : <x:f t="shared" ref="D3:D6" si="1" >D2+C3</x:f><x:v >130</x:v> D4 : <x:f t="shared" si="1" />...
Hi, I am learning OpenXML. I have been looking for hours trying to find how to do a simple task: insert text into a content control in c#. I have a template document with two controls "Name" and "Age." I can find them well enough, but I just cannot add text in them. I've tried a number of things, all to no avail. byte[] tem...
I am using SQL Server 2005 to Extract XML data. I would appreciate some help extracting the following XML snippet? <ELEMENT_A> <CHILD_A _attribA="ABC"> <CHILD_B Type="1"> <CHILD_C> <CHILD_D Type="1" Date="2010-08-31"> <CHILD_E _attribB="M0"> <CHILD_F>-0.32295</CHILD_F>...
I have a bunch of employee names which need to be inserted in a table. Should I represent my data like this and use OpenXML to insert into the database:- <Employees> <Employee> Emp1 </Employee> <Employee> Emp2 </Employee> <Employee> Emp2 </Employee> </Employees> OR I should represent the Employee like Emp1,Emp2,Emp3, split the strin...
I have a basic XML file, which I need to add as an XML Map to an Excel 2010 Worksheet. How do I do this programmatically? I would prefer a solution which uses Microsoft OpenXML SDK. ...
I have the following code to open excel template file and save it as .xlsx file and I get the error below when I try to open the new file. Please help to resolve this. Excel cannot open the file ‘sa123.xlsx’ because the file format or the extension is not valid. Verify that the file has not been corrupted and that the file extension mat...
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 wrong data in each column. i think this is because in the below code: row.Descendants<Cell>().Count() is number of populated cells (not all...
I've been checking out what is possible with the Office Open XML specification for documents. I'm particularly interested in being able to add custom XML content to a document and binding it to content controls. I was wondering if it is possible to have a repeating content control type? For example, say I have some custom XML in my .d...
Hi.. I'm working on doing a online word processor, such as Google Docs, Zoho etc.. I want to create its front end using Tinymce editor, i.e front end of the editor will be done using Tinymce. But i want to convert this front end generated by tinymce into a word file[.doc] at the server end.. so, tell me how to convert this HTML represent...
Hi, I'm new to programming with the OpenXML SDK and I've tried excessively to locate and read text that is between two document fields, but never really succeeded. There are tons of samples and tutorials on the web about almost everything you can think of doing with the OpenXML SDK, from setting watermarks to doing merge mail, but not o...
is there any examples out there on how to update a powerpoint slide (by clearing the text in a certain textbox and updating it with new content). I have a monthly report to generate in powerpoint and i have all the data in a database. I am trying to determine if i can simply autogenerate the slides by having a blank powerpoint template...
Hello, I have an excel 2007 file (OpenXML format) with a connection to an xml file. This connection generates an excel table and pivot charts are using this table. I am trying to find a way with OpenXML SDK v2 to do the same as the "Refresh All" button in Excel. So that I could automatically update my file as soon as a new xml file is ...
I have started using a TDD approach to develop a small app that reads data from Excel files. Using a repository pattern type approach I have come to a hurdle which baffles me. In order to read the Excel files, I am using the OpenXml-SDK. Now typically reading from an Excel file using the SDK requires several if not more steps to actuall...
I hooked into the question located at "Replace image in word doc using OpenXML". I noticed that there are several ImagePartType types. Is there any easy "built in" way to determine which type a specific image should be other than going by it's extension? The ImagePartType enum is also used in PowerPoint as is alot of the WordProcessingML...
When processing an open xml document, colors can have various transformations applied to a base color to generate a relative color. For instance <a:satMod value="25000"> would modify the base colors saturation by 25%. There are two transforms I have been able to find very little information on and they are: <a:gamma> The docs say "Th...
I need to work in .net 2.0. So I can't use OpenXML. This is my source code and I have already Installed AccessDatabaseEngine.exe. But still getting the exception: "Could not find installable ISAM". I have also tried "Extended Properties=Excel 8.0" in the connection string. static void Main(string[] args) { DataSet dataSet = new D...
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 Excel" button on it. When the button is clicked, the page content is output to Excel as in this tutorial: http://aspalliance.com/articleView...