473,327 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

XML with inline schema open in Excel 2007

Rob
Hi. I have XML data that I want to be more user-friendly when its
opened in excel. I have been just trying to get excel to recognise an
inline schema to do very basic formatting - as in for it to know
recognise its datatype etc..- is this possible in the Excel?
Any information regarding this would be very helpful as I'm trying to
research which would be the best way to implement this - and an inline
schema seems the most straightforward.
Thanks

May 8 '07 #1
3 4138
Rob wrote:
Hi. I have XML data that I want to be more user-friendly when its
opened in excel. I have been just trying to get excel to recognise an
inline schema to do very basic formatting - as in for it to know
recognise its datatype etc..- is this possible in the Excel?
Any information regarding this would be very helpful as I'm trying to
research which would be the best way to implement this - and an inline
schema seems the most straightforward.
Thanks
Hi, Rob,
Recently I’ve got pretty much the same issue on project I was involved.
I had to display XML file (with results) in Excel, so I did it with XSL
transformation as described in http://aspalliance.com/471

HTH,
Petar Atanasov
http://a-wake.net
May 8 '07 #2
Rob
Hi, Rob,
Recently I've got pretty much the same issue on project I was involved.
I had to displayXMLfile (with results) in Excel, so I did it with XSL
transformation as described inhttp://aspalliance.com/471

HTH,
Petar Atanasovhttp://a-wake.net
Thanks a million Petar - I will study the link and see if this is
viable for me.
I haven't found an example anywhere of an inline schema working for
excel.
My end goal was to have a Web Query file that they would open in excel
and refresh the data each time they opened the file, so that they
could use the data to build pivot tables etc. which they can't do
straight away at the moment due to the format that the data renders
in.

Rob

May 8 '07 #3
Rob wrote:
>Hi, Rob,
Recently I've got pretty much the same issue on project I was involved.
I had to displayXMLfile (with results) in Excel, so I did it with XSL
transformation as described inhttp://aspalliance.com/471

HTH,
Petar Atanasovhttp://a-wake.net

Thanks a million Petar - I will study the link and see if this is
viable for me.
I haven't found an example anywhere of an inline schema working for
excel.
My end goal was to have a Web Query file that they would open in excel
and refresh the data each time they opened the file, so that they
could use the data to build pivot tables etc. which they can't do
straight away at the moment due to the format that the data renders
in.

Rob
ok, good luck :)

Regards,
Petar Atanasov
http://a-wake.net
May 9 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Morten W. Petersen | last post by:
Hi, I'm developing a validation schema for a new thing called extensible open xhtml outlines (XOXO) . I'd like to include inline XHTML elements in these outlines, and do the least amount of...
1
by: Matt McMinn | last post by:
I'm trying to have an XML file validate against an inline schema. The declarations follow: <PLMXML xmlns="http://www.plmxml.org/Schemas/PLMXMLSchema" xmlns:data="x-schema:#inLineSchema">    ...
1
by: martin | last post by:
Are inline schema (i.e a schema included in the XML document) compliant with the W3C recommendations on schema? I keep reading about them in .net articles on webservices. I don't understand how...
1
by: Andreas Palm | last post by:
Hi there, I do have a dataset which I use to write a XML file with inline schema. A second application should use a XmlvalidatingReader to read the xml file again. Now I get errors like: The...
8
by: aevans1108 | last post by:
Greetings I can't seem to inherit enumerated values from a globally defined type in my XML schema. XmlSchema.Compile() doesn't like it. Here's the schema. <?xml version="1.0"...
2
by: Edward Diener | last post by:
I could not find an example of an inline XSD schema for an XML document which has no namespaces. Could someone supply one ? When I tried validating my XML with an inline XSD schema, using...
0
by: veenakj | last post by:
Hello, We use ASP.NET. We have a page with Excel download link when clicked it is supposed to render the excel data in browser. Below is the header info we set Response.ContentType =...
1
by: cidney001 | last post by:
Hi, I am trying to create a schema with an inline schema in it. I have looked for a simple example of how to do this but i can't find one. I have included 2 simple schemas. How would i make the...
0
by: jzalar | last post by:
I have Access 2007, Excel 2007, Access 97 and Excel 97 running on my Windows XP computer. When I try to open up a Pivot Form in Access 97, Excel 2007 Opens. I can not figure how to make Excel 97...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.