Browse by Tags

Consider I have formulas in Excel document. When I add new row inside "area" of formula, I must add that new row to formula, e.g the formula is "SUM(B2:B7)" and it is in B8 , I add new row to B3, and replace other rows which is >B3 (B4,B5 ...) , and formula now in B9, but formula...

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

Thanks for your advice Br.

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

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