Click here to Skip to main content
15,903,033 members
Home / Discussions / XML / XSL
   

XML / XSL

 
AnswerRe: xsl simple question Pin
Brent Lamborn28-Aug-06 10:04
Brent Lamborn28-Aug-06 10:04 
AnswerRe: xsl simple question Pin
Elina Blank28-Aug-06 10:06
sitebuilderElina Blank28-Aug-06 10:06 
GeneralRe: xsl simple question Pin
Brent Lamborn28-Aug-06 10:07
Brent Lamborn28-Aug-06 10:07 
QuestionMultiple root elements [modified] Pin
Tomi8728-Aug-06 9:21
Tomi8728-Aug-06 9:21 
AnswerRe: Multiple root elements Pin
led mike29-Aug-06 6:19
led mike29-Aug-06 6:19 
GeneralRe: Multiple root elements Pin
Tomi8729-Aug-06 6:40
Tomi8729-Aug-06 6:40 
GeneralRe: Multiple root elements Pin
led mike29-Aug-06 7:35
led mike29-Aug-06 7:35 
Questionxml-excel Pin
fmardani25-Aug-06 3:32
fmardani25-Aug-06 3:32 
Hi,
I have been given an .xml file to investigate how it produces data.
Basically there is a file called testData.xml
when this file is double clicked, it opens up in excel with data.
If you right click and open in excel then a properly formatted excel workbook with two named sheets appear which have both got formatted data in them.

I have pasted the first few lines of the xml file for you to see.

Could you let me know how this is possible and where is the data coming from?

<?xml version="1.0" ?>
- <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlnsBlush | :O ="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40">
- <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>Ursula Bitterlin</Author>
<LastAuthor>874496</LastAuthor>
<LastPrinted>2006-07-05T15:45:06Z</LastPrinted>
<Created>2005-01-12T14:14:33Z</Created>
<LastSaved>2006-07-10T11:15:56Z</LastSaved>
<Company>Engineering</Company>
<Version>10.6735</Version>
</DocumentProperties>
- <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
<DownloadComponents />
<LocationOfComponents HRef="/" />
</OfficeDocumentSettings>
- <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>5325</WindowHeight>
<WindowWidth>11820</WindowWidth>
<WindowTopX>120</WindowTopX>
<WindowTopY>60</WindowTopY>
<ActiveSheet>1</ActiveSheet>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
- <Styles>
- <Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom" />
<Borders />
<Font />
<Interior />
<NumberFormat />
<Protection />
</Style>
- <Style ss:ID="s16" ss:Name="Comma">
<NumberFormat ss:Format="_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_" />
</Style>

QuestionSorting nodes by a child node Pin
Malcolm Smart25-Aug-06 1:05
Malcolm Smart25-Aug-06 1:05 
QuestionHow do i control the format of a date output by XSL? Pin
Red_Wizard_Shot_The_Food24-Aug-06 0:48
Red_Wizard_Shot_The_Food24-Aug-06 0:48 
AnswerRe: How do i control the format of a date output by XSL? Pin
Dustin Metzgar24-Aug-06 4:20
Dustin Metzgar24-Aug-06 4:20 
Questionexport to excel using xslt when the column name contains blank?? [modified] Pin
steven_wong23-Aug-06 16:51
steven_wong23-Aug-06 16:51 
Questionremove periculat node from xml file Pin
rkhokle22-Aug-06 20:57
rkhokle22-Aug-06 20:57 
AnswerRe: remove periculat node from xml file Pin
Christian Graus22-Aug-06 21:07
protectorChristian Graus22-Aug-06 21:07 
QuestionSaving svg or xml to client side Pin
Yeast2722-Aug-06 7:31
Yeast2722-Aug-06 7:31 
Questionxml Pin
rkhokale19-Aug-06 3:04
rkhokale19-Aug-06 3:04 
AnswerRe: xml Pin
Vitaliy Tsvayer20-Aug-06 9:09
Vitaliy Tsvayer20-Aug-06 9:09 
AnswerRe: xml Pin
Dustin Metzgar22-Aug-06 11:15
Dustin Metzgar22-Aug-06 11:15 
AnswerRe: xml Pin
Sage30-Aug-06 15:04
Sage30-Aug-06 15:04 
QuestionI'm Sure It's Something Little... Pin
Scott_Roberts18-Aug-06 15:15
Scott_Roberts18-Aug-06 15:15 
QuestionSpecial characters - [modified] Pin
VK-Cadec18-Aug-06 7:28
VK-Cadec18-Aug-06 7:28 
QuestionHow to get popup onTrayIcon Pin
muravi17-Aug-06 22:39
muravi17-Aug-06 22:39 
AnswerRe: How to get popup onTrayIcon Pin
toxcct18-Aug-06 0:24
toxcct18-Aug-06 0:24 
QuestionURGENT innertext problem Pin
biaali17-Aug-06 21:19
biaali17-Aug-06 21:19 
AnswerRe: URGENT innertext problem Pin
Dustin Metzgar18-Aug-06 5:13
Dustin Metzgar18-Aug-06 5:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.