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

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

I have a table in a spreadsheet template with 3 columns with headers. The first row in the table is populated, and the first cell in this row contains a formula, the second and third cells contain data validations. On the row just below the table is a button that runs a macro. I need to insert new rows...

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

Hello guys I hope i dont sound extremely stupid when i ask this question. Before you answer my question please keep in mind that i have looked over the documentation metioned here in this site, plus I have looked at the tools. They are great. However what i cant understand for the life of me is the actual...

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.

Hi, I've written a Perl module called Excel::Writer::XLSX for creating Excel XLSX files. Here is an example that creates a pie chart (sorry for the pun): #!/usr/bin/perl use strict; use warnings; use Excel::Writer::XLSX; my $workbook = Excel::Writer::XLSX->new( 'chart_pie.xlsx' ); my ...

Hi , i am new for the openxml ., However i want to export the database value to excel . How can i insert image to the excel file ? My image are store as varbinary . Can anyone provide me sample source code? thank for your helping

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

I want to validate xlsx documents using OpenXMLValidator and the code from the MS examples: try { OpenXmlValidator validator = new OpenXmlValidator(); int count = 0; foreach ( ValidationErrorInfo error in validator.Validate( SpreadsheetDocument.Open(xlsxFile, true )) ) { count++; Console.WriteLine( "Error...

I generate xlsx file from my java application. I do not use any third-part libraries cause xlsx is the zipped set of xml files and I need only basic functionality of SpreadsheetML. I need to create very large documents(for about 350000 rows and 120 columns). My synthetic tests with fake data work fine...

Say I have a table named "MyTable". I want to find the worksheet where this table resides. So, knowing just the table name how can I find the worksheet?

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