Browse by Tags

Hi, Can someone tell me if it is possible to group excel rows using open xml? I tried to search for the same on the web but couldn't find anything. If it's not possible to group using open xml then I might look for other tools to automate excel on the serverside. Any help on this will be appreciated...

Hi, I developed an application to automatically update an embedded Excel Spreadsheet in a Word document using Open XML SDK 2.0. The problem is I cannot update the “Word view” of the embedded spreadsheet. I need double click on the embedded Excel spreadsheet to update the “Word view”...

Hi I Have opened the already existing ExcelFile and Updated it with OpenXml , i was done, but when iam trying to open my ExcelFile it is saying that "We found some problem with some content in doc1.xlsx fileDo you want to try to recover as much as we can?Press if Yes" If i press yes iam getting...

Hi, i have been trying to insert data to multiple sheets.For my excel i have two sheets which is "charts" sheet and "ChartData" sheet, i'm able to update the data to the sheet2 i.e chartdata sheet but i'm unable to insert data to the sheet1.Here is the below code which i have...

Hi i am trying to insert data into the sheet which will have data in it. To insert data i create a row and then i create cells and add that cells to row. Rows are appended to sheet data. After populating when i open excel file,it is showing Why it giving error?? i found many examples creating excel sheet...

I have created a ribbon toolbar button using custom ui editor tool following the link http://stackoverflow.com/a/8852767/649524 I need to do further customization. Where can i find the documentation? I have downloaded ECMA 376 ( http://www.ecma-international.org/publications/standards/Ecma-376.htm )...

I have been given the following task: unzip an xlsx file, creating a directory structure of xml files, and then read one or more of those xml files back into Excel. The result should be the same as if I directly opened the xlsx file. The XML file that seems to hold the data is sharedStrings.xml, but...

Hi all, i'm new to this forum but i sure i'm in the right place to ask my question. Could some tell me if it's possible to insert content in SpreadsheetDocument as in WordDocument and change thier value at runtime. Actually i have an excel template and woul like to open the file in runtime...

Hello, I created this spreadsheet which is quite simple but when I open it, a part of my calcChain and the formula is deleted. The two first line were in a template, I only added the C3 cell. On the other hand I did the same thing manually, excel opens it and when I open it with the SDK productivity...

Can any 1 provide me with me with working example of 'How to add comments in a spreadsheet" programmatically. I have tried this and have ran into issues , everytime i get an error when i open the excel file , Excel repairs the sheet by removing the drawing element. I dont know how to proceed...

I got the error while opening some OOXML results with Excel 2007. But if I unzip the file then re-zip it, there will be no erros while opening it with Excel 2007, does anyone meet similar problem before? I can provide the file... Thanks.

OpenXML SDK from my understanding fits better for manipulating documents with content controls, not ActiveX controls. See whether this page help you get around your issue or not: http://mytechworld.officeacuity.com/?p=719