Patrick\’s Bytes

11, January 2008

Custom XML Schema in Excel 2007 – Multi line items tip

Filed under: Excel,OpenXML — patrickyong @ 7:12 am

 

Excel enables you to import your own custom XML Schema or public XML standards such as RosettaNet and bind the elements to a particular cell. Excel 2007 take one step further with the ability to detect detail line items and apply table formating as well as filtering when you drop the detail line onto the spreadsheet as below.

image

However there is a rule apply here, you must define the minOccurs and maxOccurs attribute in the element level (example here would be LineItem)

image

if you left out the minOccurs and maxOccurs attribute, Excel will not able to determine the element is a detail line.

image

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: