Sam
Moderator
Premium Member
Registered: 24th Dec 99
Location: West Midlands
User status: Offline
|
Is it fairly easy to use XML in Excel?
I have a spreadsheet with a few worksheets in it (price lists) that I'd like updated via XML over the web. Is this possible?
Please don't flame me - I'm not a Windows programmer and I've not done anything remotely VBA/VBscript/whatever before (only use VB 4.0 many MANY years ago)!
|
Paul_J
Member
Registered: 6th Jun 02
Location: London
User status: Offline
|
what do you think XML is?
|
Sam
Moderator
Premium Member
Registered: 24th Dec 99
Location: West Midlands
User status: Offline
|
quote:
Originally posted by Paul_J
what do you think XML is?
Have you actually got something useful to input in this thread?
|
Paul_J
Member
Registered: 6th Jun 02
Location: London
User status: Offline
|
quote:
Originally posted by Sam
quote:
Originally posted by Paul_J
what do you think XML is?
Have you actually got something useful to input in this thread?
What I mean, is that it is not exactly clear what you want to do.
You are mentioning XML like it's an action / utility / programming language you're going to use.
Where infact it's just a way of modelling data. So I'm not totally sure what you wanted to achieve, hence by you explaining what you thought XML was, may actually reveal exactly what you want to achieve.
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
Basically what paul said
What are you expecting to get ? What do you want to do ? What systems do you currently have in place ? What file formats does it want you to upload etc
|
Sam
Moderator
Premium Member
Registered: 24th Dec 99
Location: West Midlands
User status: Offline
|
OK... At the moment I have to manually copy and paste my cost prices from suppliers into said spreadsheet on a daily basis.
I can apparently access their price lists via XML - haven't looked into it fully yet as I've been busy today but I'm guessing it's something along the lines of me submitting a query to their server via XML and getting a response back.
Sorry for getting arsey BTW Paul.
|
Paul_J
Member
Registered: 6th Jun 02
Location: London
User status: Offline
|
Yup sounds about right, there'll have a web service that you can send a request to, that'll return you a piece of XML which will have all those prices. Then you can just import that XML data into excel like:
http://office.microsoft.com/en-us/excel-help/import-xml-data-HP010206405.aspx
...
Of course, if you wanted this to be an automated process, you could write a little application to do it for you or potentially write a plugin for excel which will do a request and pull down the data into the sheet.
|
Sam
Moderator
Premium Member
Registered: 24th Dec 99
Location: West Midlands
User status: Offline
|
Thanks Paul, looks pretty straightforward.
I'll give it a whirl!
|
