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 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...

Hi. Im All new to excel and OpenXML, i ealier have done some Word projects in open XML. What i need to do is create a a excel document containing to things. 1) a Table with 3 coulms. UserID, ProductName, Price. 2) a Pivot table showing total for each user /Product Like show that we can see that user...

How to create programatically a macro enabled excel 2007 (XLSM) document from an existing macro enabled excel 2003(XLT)template using openxml

I have 2 tables on the same worksheet. The last row of each table has a cell that contains a comment and another cell that contains a button that runs a macro. I can insert a new row into each of the tables and adjust the row index and cell references of the rows that are below the newly added row and...

I have created an excel sheet that contains a chart. I update the data in an the excel file with OpenXML. The data gets updated and I am able to view the chart. However when I export the chart to Powerpoint the chart is empty. If I open this file in excel and if I save it the chart is updated properly...

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.

I am trying to generate an Excel spreadsheet programmatically and have been running into issues while trying to open the file in Excel. I get an error saying that the xl/worksheets/sheet1.xml is malformed and that Excel will correct is it. After correction the spreadsheet is displayed but will poor styling...

Hi Eric I just found one way of solving this problem. When i have cellValue ( "123" in this case) and formatCode ( "_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)" in this case), I can use the function WorksheetFunction.Text("Value"...

Eric Thanks again for your reply. Glad to know that you are planning to prepare some sample code on this matter, but before that, it would be grateful if you can provide me a hint/clue on how to proceed with this one as it is kind of urgent for me here. Is there any spreadsheetML specific API function...

Hi I am seeing avalue in my xlsx sheet as $123. I have to read it and display it as it is. I am finding just 123 in sheet1.xml and the style defined for it gives me a number format id which leads me to a format code "bla bla bla". I want to know how to apply this format code on 123 and get...

And the C# code for this is, private int GetNumberOfColumns() { var spreadSheetPackage = ZipPackage.Open(filename, FileMode.Open, FileAccess.Read, FileShare.Read); using (var spreadsheetDocument = SpreadsheetDocument.Open(spreadSheetPackage)) { var sheet = spreadsheetDocument.WorkbookPart.Workbook.GetFirstChild<Sheets>...

Hi I wondered how to figure out number of used columns in a work sheet. After some research on the spreadsheetML, i found out there are two ways to find out the number of columns in a sheet. 1> Open Sheet<number>.xml file, refer to dimension xml node (like below for exapmle) <dimension ref...

Hi i am presently working with a application where we need to import .docx and .xlsx files into our application and in turn convert them into our own application specific XML format which is nothing but a custom XML that our application can recognize. Support for the .docx already done and now we need...