xml schema to a spreadsheet with repeating and non-repeating data. It is
quite awesome!
http://msdn.microsoft.com/library/default.asp?url="">
(See the articles down the left side to the screen)
You existing layout may preclude this but it is worth a try ..
Michael
----- Original Message -----
From: "Stephen Russell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 12, 2004 11:29 AM
Subject: [C#.NET] Load Data from an Excel Sheet
>
> I have an intergrated price file that needs to update our existing system.
>
> We manufacture modular equipment so when you mix & match various parts
your
> coming up with a unique combination <PART #> and price.
>
> My starting excel sheet is at best an xml layout with a few pieces of crud
> in node 1.
>
> Root = 442
> Node 1
> Chelsea Basic Model Node 2 Node3 4 Node 5 Node6
> 442**AB 5-P-1001 A 629.48
>
>
> Next series in same sheet:
> Mounting Options Node 2 Node 3
> node4 Node5 node6
> G Standard Mount W/Metric
> Studs 6.56
>
> Here is a series with dirty data in node 1
> Shift Options
> 1 A Air Shift
> 147.14
> V Air Shift Less Installation
> Kit 74.84
> 21 S PTO & Pump Combo Valve
> 316.25
>
>
> So how would you bring in this data that has to be parsed row by row for
the
> update process?
>
> TIA
> Stephen Russell
> S.R. & Associates
> Memphis, TN 38115
>
> 901.246-0159
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/CSharpNET/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
