Join
Sign in
Search Options
Search Everything
Search Formats
Home
Blog
Resources
Forums
About Open XML
More ...
Home
»
Forums
»
Formats
»
SpreadsheetML
»
How to get data from xml mapped parts?
How to get data from xml mapped parts?
Formats
Discussions about working with different Open XML Formats
Get this RSS feed
Details
1
Reply
2
Subscribers
Posted
over 2 years ago
Options
Subscribe via RSS
Share this
SpreadsheetML
How to get data from xml mapped parts?
rated by 0 users
This post has
1 Reply |
2
Followers
SnowEagle
25
Posted by
SnowEagle
on
Tue, Jul 13 2010 1:59 AM
rated by 0 users
Post Points: 20
How to get data from xml mapped parts?
Hi there
Imagine that you've got a spreadsheet which has got xml mapping, is there any simple way to programaticaly retrieve data from mapped cells (using openXML)? Unfortunately I can't do this using Excel automation because it is going to be a ASP.NET server job (Microsoft seriously warns not to use office automation on server side http://support.microsoft.com/kb/257757).
Thanks for help!
Intergen
2610
Posted by
Intergen
on
Thu, Jul 15 2010 5:13 PM
rated by 0 users
Post Points: 5
Re: How to get data from xml mapped parts?
Microsoft have made some helpful code snippets which can be found here:
http://coolthingoftheday.blogspot.com/2009/09/open-xml-format-sdk-20-code-snippets.html
You can simply use the
XLGetCellValue
code snippet to help you look up any data in your spreadsheet.
Page 1 of 1 (2 items)