ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   xsl to xml problem during load (https://www.excelbanter.com/excel-programming/377119-xsl-xml-problem-during-load.html)

Kevin

xsl to xml problem during load
 
FilesI use xsl to create the following xml file, but when I open it with
excell I get either a blank worksheet with the name I provided or I get
"Problem Duing Load and a path to a log file at C:\Documents and
Settings\MyUser\Local Settings\Temporary Internet\Conten.MSO.

That path does not exist

Can anyone tell me what is wrong with this xml
--------------------------------------------------------
<?xml version="1.0" encoding="utf-8"?
<?mso-application progid="Excel.Sheet"?
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns: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"
xmlns:ms="urn:schemas-microsoft-com:xslt"
<Styles
<Style ss:ID="Default" ss:Name="Normal"
<Alignment ss:Vertical="Bottom" /
<Borders /
<Font /
<Interior /
<NumberFormat /
<Protection /
</Style
</Styles
<Worksheet ss:Name="Dec2006"
<Table ss:ExpandedColumnCount="6" ss:ExpandedRowCount="10"
x:FullColumns="1" x:FullRows="1"
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:StyleID="Default"
<Data ss:Type="String"PROCESS</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="String"POSTING</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="String"Data</Data
</Cell
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
</Row
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:StyleID="Default"
<Data ss:Type="String"DATE</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="String"DATE</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="String" RETURNS </Data
</Cell
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default"
<Data ss:Type="String" ORIGINATIONS</Data
</Cell
<Cell ss:StyleID="Default" /
</Row
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:Index="3" ss:StyleID="Default"
<Data ss:Type="String"DAILY & EOM ORIG ALERT</Data
</Cell
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default"
<Data ss:Type="Number"70000</Data
</Cell
</Row
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:Index="3" ss:StyleID="Default"
<Data ss:Type="String"#</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="String"$ AMOUNT</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="String"#</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="String"$ AMOUNT </Data
</Cell
</Row
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:StyleID="Default"
<Data ss:Type="DateTime"2006-11-01T00:00:00.000</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="DateTime"2006-11-02T00:00:00.000</Data
</Cell
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
</Row
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:StyleID="Default"
<Data ss:Type="DateTime"2006-11-02T00:00:00.000</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="DateTime"2006-11-03T00:00:00.000</Data
</Cell
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
</Row
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:StyleID="Default"
<Data ss:Type="DateTime"2006-11-03T00:00:00.000</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="DateTime"2006-11-06T00:00:00.000</Data
</Cell
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
</Row
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:StyleID="Default"
<Data ss:Type="DateTime"2006-11-06T00:00:00.0000000-05:00</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="DateTime"2006-11-07T00:00:00.0000000-05:00</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="Number"0</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="Number"1132</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="Number"2</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="Number"1132</Data
</Cell
</Row
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default" /
</Row
<Row ss:AutoFitHeight="0" ss:Height="11.4375" ss:StyleID="Default"
<Cell ss:StyleID="Default" /
<Cell ss:StyleID="Default"
<Data ss:Type="String"TOTALS</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="Number"0</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="Number"0</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="Number"0</Data
</Cell
<Cell ss:StyleID="Default"
<Data ss:Type="Number"0</Data
</Cell
</Row
</Table
</Worksheet
</Workbook
-------------------------------------------------------
--
kevin...


All times are GMT +1. The time now is 06:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com