Applications - Recent Threads

How to exact value of Cell in Excel document with OpenXML ?

Javidan — Fri, 17 May 2013 08:55:34 GMT

As with using Microsoft.Interopt I can get cell value like this : Cell.Value . But with OpenXML I got confused. Sometimes it returns id of item in SharedStringTable sometimes it return string and etc. Is there some method like to get exact cell value in excel document?

How to add rows to ready table in Word document?

Javidan — Mon, 06 May 2013 13:21:22 GMT

Hi. I have to edit table data in Word document. As with LINQ I can found Table, and in loop I call function AppendChild to add rows, but nothing happens. Even I cannot deleta any row in table. What is the problem ?

There is problem when saving XmlDocument into OpenXmlPart

Javidan — Mon, 29 Apr 2013 10:23:02 GMT

Hi. I am using content written by Eric White : http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2011/05/12/148357.aspx about searching and replacing text in Word document. But I have problem with it, which i couldn't solve. At saving it had problem, then I analyzed code step by step, and found that it replace text in Word document, but when it goes to PutXmlDocument method, it doesn't do anything. And i get same document. The interesting part is that, couple weeks ago, it was working normally. P.S. again I had problem with saving: when i save and close WordprocessingDocument it returns the same document which i give as source. And my question is this: what is the problem? and is this problem related to source (document) ?

Doing manipulation in an Open Office document?

azfarhussain84 — Wed, 10 Apr 2013 08:57:49 GMT

Is it possible to extract text from a word document while a user types in? Is it possible with Open XML?

-- Azfar

I don't find any end list mark

rebustiano — Mon, 21 Jan 2013 11:17:42 GMT

Hi every one.

I am making a little application to show an docx document, I am developing in C++ using libopc.

I have no problem to identify the numbering style based on numId and ilvl values and print the correct bullet, number or another simbol, but I have a problem: I can't find in the document.xml a mark or an identifier in order to decide when a list is ended, then the first level is increasing the value every time:

Word:

- kk

o Second

- kk

<end>

1. Hola

A. ok

2. Hola

My App:

- kk

o Second

- kk

<end>

3. Hola

A. ok

4. Hola

Many thanks.

How do I know the font size (for example) of a specific piece of text in a word document?

toddscott — Sat, 12 Jan 2013 00:02:46 GMT

The idea is simple, but the answer may get complicated:

In fact, I can check the run properties for the font size.

If absent I need to check the style applied to the paragraph in order to find the run properties defined for the font size, then that style's paragraph run properties.

If not found I need to check everything again regarding the style which this style is based on.

If not found, I should check the following style going up in the style hierarchy, and go on till I reach the default style.

I also need to check if the previous paragraph has a style applied to it. In this case the applied style may define the style for the next paragraph that affects the text I'm working with.

If there is no style influencing my paragraph, then I need to look in the default run properties from the styles part. After that I should look to the default paragraph properties in the same part.

If nothing applies then the responsibility for the size defintion goes into the application that is working with the document.

Am I right?

Don't I have any help from OPenXML SDK and/or from OpenXmlPowerTools?

__________________________

Short Sale

How to write text in cells of creating excel sheet using openxml?

vikash kumar — Fri, 04 Jan 2013 10:13:09 GMT

Hi all,

Hope doing well,

sir i am using openxml to create the excel sheet now i want to add some text like some column name of my table that i want to add in the cells how to do that

thanks.

Create fillable form in microsoft word

rmollel — Fri, 21 Dec 2012 14:47:27 GMT

Is it possible to use OpenXML to do the following:

- Dynamically/Programatically build or embed a fillable form in microsoft word using OpenXML

- User should be able download the created word document with form in it

- User fill out the form created and upload it back to the server

- Use OpenXML to read and save to the database the answers provided by the user on the form

Is it possible to sign only macro in Office 2010 document using packagedigitalsignaturemanager.Sign() in c#?

Petr Kovanda — Thu, 08 Nov 2012 23:42:42 GMT

I wonder, is macro signable part of 2010 office document? Is it possible to sign with x509certificate using packagedigitalsignaturemanager c# class? I searched google and found only that is possible to sign any signable part of document. Thank you very much for answers.

Petr Kovanda

Looking for a high level review of my OpenXML project to see if I am on a path that can get me there, and if so, how?

sblalock — Tue, 02 Oct 2012 14:16:50 GMT

For the official moderators and those that like to play moderator, this post is looking for a high level review of my problem and how I am trying to use OpenXML to solve it(platform, technologies, techniques, etc), and possible solutions. It is looking for recomentations on code samples, technuqies, whitepapers, etc. It is concerning a project using VB.Net (or C#), ASP.Net, IIS, Windows Server, Visual Studio, HTML, OpenXML, OpenXML-SDK, and MS-Excel. I am willing to consider, "this should be in whatever, whatever" but please make it relevant and not just "let's get this out of our queue".

---------------------------------------------------------

This is a design problem / brain teaser for all the Architect minded folks in the community. For those that expend the time to at least read this document, I thank you. For those that read, consider and share their opinions, I am humble by your dedication to helping others and I am most appreciative.

I have a conversion project for a client that has painted me into a corner and I am hoping there is someone out there with the knowledge and expertise to help me.

Should you choose to accept this assignment.... <cue music>

The requirements are fixed, so the suggestion to just use a different language, web webserver, commercial component, etc will be considered, however will most likely be discounted as a no solution. Please do not misunderstand, I am open to new ideas and certainly open to any help you may be able to provide: code samples, white papers, articles, etc which relate, however part of the problem is meeting the clients requirements. Even I, the lowly programmer, most likely could solve this problem if I were allowed to change the requirements and the environment. Any changes to the requirements will need to be justified as "the only way to solve the problem."

Requirements/Goals:

* Native code/components. No commercial components please. Solutions using open source components will be considered.
* Thin Client / Browser based (IE is standard)
* IIS WebServer running on Windows Server.
* If submitting or referring to samples/solutions, VB.Net/Asp.Net preferred, however I can translate C#

Problem:

Convert a desktop vb6 client/server program using Office Automation to a ASP.Net thin client application. The program reads two Spreadsheets (one with static design elements, calculations and cells/text boxes which are populated with data from the DB and one with named ranges containing drawings) and merges all this onto a spreadsheet which is persisted to the Server HD for archive, and then needs to be displayed to the user. Of course in the client/server world, displaying was done with launching Excel, however in the websrver/browser world, the document needs to be rendered as HTML and sent back across the HTTP pipe to the clients browser (rendered as close to the spreadsheet as possible). EXCEL WILL NOT BE ON THE CLIENT MACHINE, so the output must come down to the browser as HTML.

Notes:

1). Excel is the preferred way of maintaining the templates with the design and calculations on it. Unless there is a significantly better option, Excel will continue to be used.

2). Excel is the preferred way of maintaining the drawings, HOWEVER, if there is a significantly better option, we can flatten these drawings making them JPEGs/etc and use them as Images rather than Drawings.

3). MS Web components 2010 ran out of support this year, so we wish to stay away from it. The notice on Technet says to use other technologies, however I did not see a suggestion as to what that may be.

4). MS and most of the forums strongly suggest that we do not use Office Automation on the server side, so we would like to adhere to that.

5). The information, samples, blogs, VCasts from Eric White is great stuff and he is working on great things to improve the area of OpenXML-SDK, however I do not think I have found any of his stuff which exacly helps me. I may be wrong. Along this vein, I have been working on these issues for a while. You doing a quick Google and pointing me to the first link in the top 10 that looks interesting, is not going to do it.

Progress:

Here is what I have done and here is where my problems have been:

Effort: I started going down the path of converting the spreadsheets to OpenXML and using the OpenXML-SDK to merge the spreadsheets and to pull the data from he DB and populate certain cells and text boxes. This went well however...

Roadblock: Copying the drawings from one spreadsheet to another using the OpenXML-SDK has turned into an issue which is out on 3-4 forums with no results. It is currently being considered my a MS Technician (for the last week) as a MSDN help ticket, but I do not have faith that this will go far as the technician has been very quiet so far. The OpenXML-SDK and the current sample code / articles in the community seems to be lacking when dealing with moving Drawing Components.

Roadblock: Using OpenXml-SDK to convert the OpenXML to HTML to be sent back though the web server to the users browser has become a roadblock. Of course in the world where Office Automation is available, HTML and PDF are available as SaveAs types, however so far I have found the OpenXML-SDK, Samples code, Articles all to be lacking in this area as well. The OpenXML is a structured multi file format with style, pictures, data all intermingled in a fair involved way. Simply "sending the XML" across the wire is not an option. The OpenXML Document needs to be rendered into HTML with structure, style and data all encoded in the markup. Since design and structure is handled in the Excel Document, we do not with to have to change style and layout on the client side though CSS.

Questions:

1). So, is there a better approach?

2). Am I missing some Components / Samples / Techniques / Articles which could help me get my current solution implemented (namely the copying of Drawings from one spreadsheet to another, AND the rendering of the OpenXML document as a HTML Document)?

3). How would you do this?

4). Am I the only one tired of American Politics and the election season?

If you ave made it this far, thank you. You are obviously not the kind of person looking to just drop the quick "You should be able to..." type comment. I do appreciate your effort so far, and if you can help, I will be even more appreciative.

Simple word document templates mapping fields accessing them with c# and printing

smstarks01 — Sat, 29 Sep 2012 18:45:40 GMT

Hello,

Fairly new to C# and totally new to OpenXML, trying to figure out where to start.

Here is what I am trying to accomplish.

Create word documents with fields in them that I can fill in, keep it simple at first, the dynamic data would be basically name and address.

I am hoping these documents can be created in 2010 Word by a non-programmer, and then using C#, I can pull my information from a SQL Database using C# .net, and populate these templates with the address, basically filling in these named fields. I plan on using C# to figure out what I am populating these forms with and then to print them, and save and archive the forms in either a word or pdf format.

Challenges I have

Would like it to be compatible with Word 2003-2010. (not a must, but want to know my options)

The documents I use for the template need to be manipulated by someone not real computer literate, and I would like to be able to change over time, without my code changing unless I need to add some new tags to fill in.

Don't want someone to write it for me, but would like suggestions on what I need to read to do this. Is OpenXML a reasonable way of doing this?

Thanks for all suggestions,

Steve

Could you help me to know how to run Macro from OPenxml office components

raman.p123 — Tue, 14 Aug 2012 13:24:35 GMT

Hi Team i am working on windows services with office interop ,as i come to know from blog there is no support of office automation on windows 7 machines. could you please help me, how run DDE commads from OPenXML. Please find the code which is working fine DDEmetod on button click on windows 7 machin and other windows OS

public void DDLExecuteMethod(string HPServicemgrstring)

{

var excelApp = new Excel.Application();

int nChannel; nChannel = excelApp.DDEInitiate("HP_Service_Manager", "Actions");

excelApp.DDEExecute(nChannel, "[SystemEvent(""ReceiveInteraction"", ""Caller Name"", ""xxxxxx"" ,""Authentication"", ""xxxx"" ,""LiveOpsID"", ""xxxx"" ,""CallVariable"", ""1"")]"); excelApp.DDETerminate(nChannel);

excelApp.Quit();

}

How to create office shape in clipboard

Dirk — Sun, 12 Aug 2012 01:25:05 GMT

I have an applicatin which need copy some shapes to office 2010. My solution about this feature is that convert my shapes to office's shapes, and copy them to clipboard. I would not like to use VSTO and want to try use Open XML. So I want to know how to create open xml package by office's shapes.

Thanks in advance for anyone who can tell me some advices.

Custom UI Generator deletes excel macros - excel 2007

After8eighT — Mon, 06 Aug 2012 14:21:11 GMT

Hello all,

there's a wired thing: when I add new groups to my excel-file in the customUI.xml with the "Custom UI Editor for Microsoft Office" it deletes all existing VBA-macros within this excel-file.

Is this normal? it's quite anoying.....

Greetings from Hamburg,

After8eighT

OpenXML SDK - a link in MS Excel to open another MS Excel. how would the request be authenticated?

rijesh — Thu, 28 Jun 2012 05:35:12 GMT

I understand that it is possible for a link in MS Excel to open another MS Excel using OpenXML. Need to create Hyperlinks object and append it to Worksheet object. Now would like to know how we can manage authentication of the new document that is opened.

For Example: In web application, say one doc is already downloaded from server to browser, and user clicks on a link in that document which connects to another doc in the server.

How this clicking on link request will be authenticated? Will that be taken care by browser or should we create a new session cookie for that and authenticate? In OpenXML is there anyway if this can be managed easily without the end user knowing how this takes place.

Please share your thoughts on the request. Thanks alot for your help!

Regards,

Rijesh

Using the .Net Razor view engine with WordprocessingML

gineer — Wed, 13 Jun 2012 13:10:13 GMT

I am fairly new to OpenXML and as such went through the Eric White's videos. I was particularly interested by the Word ProcessingML Scenarios. In one of the examples (http://www.youtube.com/watch?feature=player_embedded&v=XXkYRCytbv0#t=248s) he is using a document that conains xPath expressions inside content controls. These xPath expressions are then used during a mail merge app to fill the document with data.

In one of our internal solutions we have written an application where XSL:FO is pushed through the .Net Razor engine to populate the data in the templates because this allows the full power of C# to be used in a clean syntax. I was wondering if anyone else has tried this or if anyone knows of some reason why this would not work.

Thanks

David

Edit/Modify.doc(x) fields from asp.net form?

raronovici — Wed, 18 Apr 2012 17:52:30 GMT

Hello everyone!

New to Open XML and I would like to know if this scenario is possible.

On a web form (asp.net 3.5 or 4.0), I would like users to type in their first name, last name, phone number and etc., and submit those input values from the to replace/edit a word .doc(x) template on the server. At the same time, I want the user to be prompted to be able to save the document (with new values) on their client-side.

Is such a thing possible?

Thanks!

Opening and editing word document in a browser through asp.net

jpxgen — Tue, 21 Feb 2012 11:34:03 GMT

I have a requirement to develop an asp.net web application that will open a word document in the browser and the user will be editing the document. On save of the document it should be pushed/uploaded to the server.

Is there a way we can achieve this scenario using open xml?

It will be great if anyone can throw few lights on how to achieve this.

Thanks,
J.Prakash

Read xml file based on combo box selections

WP50 — Wed, 15 Feb 2012 13:41:43 GMT

I am trying to customize the file tab(backstage) in word 2010 with a addin. My xml file creates the tab, adds 2 combo boxes with all items in the drop down and 1 button all in 1 group in 1 column. Can anyone tell me how I can tell the button, when clicked to read a specific xml file located on a network share, and return the values in the xml file in group 2 based upon the values selected from the combo boxes??
Here is my xml for the new tab

<?xml version="1.0" encoding="utf-8" ?>
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<backstage>
<tab id="customTab" label="S + A Templates" insertAfterMso="TabInfo" >
<firstColumn>
<group id="customGroup" label="S+A Templates">
<primaryItem>
<button id="btnButton" label="View Templates" imageMso="Folder" onAction="OnAction"/>
</primaryItem>
<topItems>
<layoutContainer id="layoutTwo" layoutChildren="horizontal">
<comboBox id="cboComboBox" label="Select City" >
<item id="item1" label="Toronto"/>

</comboBox>

</comboBox>

</layoutContainer>

</topItems>

</group>

</group>

</firstColumn>

</tab>

</backstage>

</customUI>

Adding a button with code to a new word 2007 document?

asaf_ok — Thu, 19 Jan 2012 13:25:03 GMT

Hi,

I've created a new document using OpenXml in c# .net from visual studio 2010,

i've used a code samples i got from opening an existing docx in the OpenXml SDK v2 and then use the "reflect code"

option.

after it worked i did the same thing with a docm document that had a Button with VBA code attached to it that shows a Msg popup.

the creation went well but i couldn't open the new docm file for some resone...i can guess it code issues related.

i have to say that a Onclick event i did was to duplicate an existing docm with a button and not create it from scratch.

my final objective is to create a docx/m document with a build-in Button that Onclick save the Active document to an sql server db.

what code do i need to use in the OpenXml code to insert the button so the End user will be able to open it and use the Button ??

Exporting worksheet to XML with Mapping Info

udi — Wed, 16 Nov 2011 21:50:34 GMT

I have a need to extract data from a spreadsheet to XML. I can easily do this manually in Office 2007 using the given Schema Map and Export functionality it provides, but how do I do this Export programmatically?

Please assume I already have a sample workbook with some data, which includes my schema and the mapping of the columns already established. Now I now want to Export this data to an xml file or even better to an xml document in my code.

I am currently opening the file with the following statement:

string xlFile = @"C:\data\sample_alreadymapped.xlsx"
DocumentFormat.OpenXml.Packaging.SpreadsheetDocument spreadSheetDocument = DocumentFormat.OpenXml.Packaging.SpreadsheetDocument.Open(xlFile, true)

Any help would be appreciated..... Thanks

Web RichTextEditor to create oxml-format

matthias_back — Tue, 18 Oct 2011 14:50:52 GMT

Hi,

we are using a web application in which we want to manage our quotes and our boiler plates (text modules) and the facts and figures of the quote.

For printing we would create a word document based on a template.

We need a rich text editor, like the one of this forum, which creates no rich-text or xhtml, but ooxml!

The functionality of the rich text editor is only:

- Font

- FontSize

- Color

- Bold, Italic, Underlined

- Images

Does anybody know such a webcomponent? Or any Idea to develop this?

Thanks for any hints!

regards Matthias

Excel becomes unreadable

Ruy.C — Tue, 18 Oct 2011 08:31:54 GMT

Hi there,

i'm trying to create an application to create excel files and insert data into it (in .Net with xml SDK 2.9). I've an a huge amount of data and so, when i insert data beyond cell Z (for example AA1) the file becomes unreadable.

Did anyone have this problem before or knows how to solve it?

Tkx in advance!

Document assembly project

17ColBarber — Wed, 21 Sep 2011 06:31:25 GMT

Hi,

I've just joined, but I've been reading this forum for a while. I've learned a lot about OpenXML, but I feel I've only scratched the surface. I'm not really a coder, which is why I could use some help.

For anyone who is interested, I have a project for a generic document assembly tool, which should be able to do the following:

    Retrieve data from SQL via LINQ and write this data to Excel
    Write data from Excel back to SQL
    Retrieve custom XML from Excel and write it to Word
    Retrieve charts from Excel and write them to Word
    Retrieve custom XML from Word and write it to an XML file
    Remove comments and personal information from Word documents (clean-up)
    Concatenate Word documents using DocumentBuilder 2.0
    Generate a PDF from a Word document
    SFTP documents to a webserver

I have drafted a detailed spec and also found bits of code for most of these tasks, thanks to Eric White, Brian Jones & Zeyad Rajabi, and others. I've even made a start with a project, but I really don't know enough C# to make it all come together. I’m therefore looking for someone with experience in C#, OpenXML, LINQ and ideally Sharepoint/ECS to put it all together properly.

I've posted the project on vWorker, but feel free to send me a message here if you're interested.

Regards,

Using OpenXML to export to Word from SharePoint 2010

arc95 — Sun, 18 Sep 2011 08:45:25 GMT

Hi.I need to add the ability in SharePoint 2010's lists to export to Word 2010 using the OpenXML technologies.

Can you point me to an article that explain this scenario or similar situation? Thanks.