[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

FW: generic SpreadsheetML transform

Subject: FW: generic SpreadsheetML transform
From: "Rick Roen" <Rick@xxxxxxxxxxxxxxxxxx>
Date: Wed, 15 Nov 2006 17:13:17 -0600
spreadsheetml
I have a .NET 2005 project where I am filling a dataset and using its native
methods to export the table rows to XML which can optionally come with an
inline schema.

The general format is like this

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<CustomersNoOrders2007>
  <Customers>
    <IDNUM>1022</IDNUM>
    <NAME>FEDEX GROUND COD PREPAID</NAME>
    <STORENUM />
    <ADDRESS1>456 PEACH STREET</ADDRESS1>
    <ADDRESS2 />
    <CITY>ATLANTA</CITY>
    <STATE>GA</STATE>
    <ZIP>30303</ZIP>
  </Customers>
  <Customers>
    <IDNUM>1107</IDNUM>
    <NAME>FEDEX STANDARD OVERNIGHT LETTER</NAME>
    <STORENUM />
    <ADDRESS1>789 DAVIES</ADDRESS1>
    <ADDRESS2 />
    <CITY>ENGLEWOOD</CITY>
    <STATE>CO</STATE>
    <ZIP>80112</ZIP>
  </Customers>
</CustomersNoOrders2007>

I want to take this generalized format and transform it into a excel
spreadsheet in SpreadsheetML using XSLT.

I am hoping to take advantage of the schema elements and perhaps do some
rudimentary numeric formatting and other minor presentational effects.

Before I start with the XSLT, I wondered if I am reinventing the wheel here.
 I googled but did not find any references.  Does this type of xslt already
exist or is there something I can use as a base?

I surely cant be the only one doing this type of thing from .NET

Thanks,

Rick

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.