GrapeCity Forums

I  need to be able to define multiple schemas on a single sheet based on the sections on it. For instance I'm expected to parse summary data  and detail data on the same sheet. Does farpoint spread support this. I have no problems defining different schemas for different sheets however I haven't found a way to do that on the same sheet.

 

This would require a redesign of the Spreadsheet Schema Wizard but we will take a look at this to see if it is a possible enhancement for a future version of Spread for BizTalk.

You can map the entire sheet as data using the Spreadsheet Schema Wizard, and use the BizTalk Mapper to transform the XML data from that sheet into the XML nodes you require.

---

Robby -
FarPoint Technologies, Inc.