xsl-list
[Top] [All Lists]

[xsl] Trouble with Excel spreadsheet using VB.NET to generate the XML

2008-05-01 13:34:37

I trying to create an Excel spreadsheet using VB.NET to generate the
XML.

The application queries a SQL database dependent on user selections via
a form with the results being output to Excel. The issue I am having is
that the generated xml does not have the following code at the top:

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>

This is the generated xml I am getting:

<Workbook xmlns:msxsl="urn:schemas-microsoft-com:xslt" 
xmlns:user="urn:my-scripts" 
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";>
<Styles>
        <Style ss:ID="Default" ss:Name="Normal">
                <Alignment ss:Horizontal="Left" ss:Vertical="Bottom" />
                <Borders>
                        <Border ss:Position="Bottom"
ss:LineStyle="Continuous" ss:Weight="1" />
                        <Border ss:Position="Left"
ss:LineStyle="Continuous" ss:Weight="1" />
                        <Border ss:Position="Right"
ss:LineStyle="Continuous" ss:Weight="1" />
                        <Border ss:Position="Top"
ss:LineStyle="Continuous" ss:Weight="1" />
                </Borders>
                <Font ss:FontName="Times New Roman" x:Family="Roman"
ss:Size="8" />
                <Interior />
                <NumberFormat />
                <Protection />
        </Style>
        <Style ss:ID="s21">
                <Borders>
                        <Border ss:Position="Bottom"
ss:LineStyle="Continuous" ss:Weight="1" />
                        <Border ss:Position="Left"
ss:LineStyle="Continuous" ss:Weight="1" />
                        <Border ss:Position="Right"
ss:LineStyle="Continuous" ss:Weight="1" />
                        <Border ss:Position="Top"
ss:LineStyle="Continuous" ss:Weight="1" />
                </Borders>
                <Font ss:FontName="Times New Roman" x:Family="Roman"
ss:Size="8" />
                <Alignment ss:Horizontal="Left" ss:Vertical="Bottom" />
        </Style>
        <Style ss:ID="s22">
                <Borders>
                        <Border ss:Position="Bottom"
ss:LineStyle="Continuous" ss:Weight="1" />
                        <Border ss:Position="Left"
ss:LineStyle="Continuous" ss:Weight="1" />
                        <Border ss:Position="Right"
ss:LineStyle="Continuous" ss:Weight="1" />
                        <Border ss:Position="Top"
ss:LineStyle="Continuous" ss:Weight="1" />
                </Borders>
                <Font ss:FontName="Times New Roman" x:Family="Roman"
ss:Size="8" ss:Color="#000000" ss:Bold="1" />
                <Interior ss:Color="#00CCFF" ss:Pattern="Solid" />
        </Style>
        <Style ss:ID="s23">
                <Alignment ss:Horizontal="Left" ss:Vertical="Bottom" />
                <Font ss:FontName="Times New Roman" x:Family="Roman"
ss:Color="#000000" ss:Size="8" />
        </Style>
</Styles>
<Worksheet ss:Name="Table">
        <Table x:FullColumns="1" x:FullRows="1">
        <Row ss:Height="50">
                <Cell ss:StyleID="s22"><Data
ss:Type="String">ID</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">Fund_Activity</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">TypeOfAccount</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">AccountName</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">Amount</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">Audit</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">Agency</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">TypeOfFund</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">Description</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">Cause</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">WorkPaperReference</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">Category</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">ImpactFinancialStmts</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">CommunicationModeByMgmt</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">noAdjReason</Data></Cell>
                <Cell ss:StyleID="s22"><Data
ss:Type="String">PotentialFindingIndicator</Data></Cell>
        </Row>
        <Row>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">83</Data></Cell>
                <Cell ss:StyleID="s21"><Data ss:Type="String">MA Trust
Fund</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">Asset</Data></Cell>
                <Cell ss:StyleID="s21"><Data ss:Type="String">Cash and
Cash Equivalents</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">33444444.00</Data></Cell>
                <Cell ss:StyleID="s21"><Data ss:Type="String">1163 -
CAFR - DOA Central FY 2006</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">Administration</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">Governmental Fund</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">adfad</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">dsfsdf</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">sdfsdf</Data></Cell>
                <Cell ss:StyleID="s21"><Data ss:Type="String">Audit
Adjustment</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">No</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String"></Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String"></Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">No</Data></Cell>
        </Row>
        <Row>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">83</Data></Cell>
                <Cell ss:StyleID="s21"><Data ss:Type="String">MA Trust
Fund</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">Revenue</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">Intergovernmental</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">-4543534543.00</Data></Cell>
                <Cell ss:StyleID="s21"><Data ss:Type="String">1163 -
CAFR - DOA Central FY 2006</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">Administration</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">Governmental Fund</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">adfad</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">dsfsdf</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">sdfsdf</Data></Cell>
                <Cell ss:StyleID="s21"><Data ss:Type="String">Audit
Adjustment</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">No</Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String"></Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String"></Data></Cell>
                <Cell ss:StyleID="s21"><Data
ss:Type="String">No</Data></Cell>
        </Row>
        </Table>
</Worksheet>
</Workbook>

**************************
Any insight as to how to get these lines into the output would be
greatly appreciated! :)

TIA,

-Cheryl

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>