Forum
Bildirimler
Hepsini Temizle
Yazılım Genel
2
Yazılar
2
Üyeler
0
Reactions
467
Görüntüleme
Konu başlatıcı
Merhaba,
vb.net ile bir xml dosyasından veri almaya çalışıyorum ama bir türlü başaramadım.
<?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"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> <Author/> <Title/> <Description>Günlük Rapor</Description> </DocumentProperties> <Styles> <Style ss:ID="27"> <Alignment ss:Horizontal="Right" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Dot" ss:Weight="1" ss:Color="#808080"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> <NumberFormat/> </Style> <Style ss:ID="24"> <Alignment ss:Horizontal="Right" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Dot" ss:Weight="1" ss:Color="#808080"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> </Style> <Style ss:ID="26"> <Alignment ss:Horizontal="Right" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Dot" ss:Weight="1" ss:Color="#808080"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> <NumberFormat ss:Format="[$-409]h:mm:ss AM/PM"/> </Style> <Style ss:ID="22"> <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="20.0" ss:Bold="1" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#444e68"/> </Style> <Style ss:ID="29"> <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> <NumberFormat/> </Style> <Style ss:ID="23"> <Alignment ss:Horizontal="Right" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="1" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#444e68"/> </Style> <Style ss:ID="30"> <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/> <Border ss:Position="Top" ss:Weight="1"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="1" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> </Style> <Style ss:ID="28"> <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:Weight="1"/> <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="1" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> </Style> <Style ss:ID="31"> <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" ss:Color="#000000"/> <Border ss:Position="Top" ss:Weight="1"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> </Style> <Style ss:ID="20"> <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> </Style> <Style ss:ID="21"> <Alignment ss:Horizontal="Right" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> </Style> <Style ss:ID="32"> <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> </Style> <Style ss:ID="33"> <Alignment ss:Horizontal="Right" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> </Style> <Style ss:ID="25"> <Alignment ss:Horizontal="Right" ss:Vertical="Top" ss:WrapText="1"/> <Borders> <Border ss:Position="Bottom" ss:LineStyle="Dot" ss:Weight="1" ss:Color="#808080"/> <Border ss:Position="Top"/> <Border ss:Position="Left"/> <Border ss:Position="Right"/> </Borders> <Font ss:FontName="serif" ss:Size="9.0" ss:Bold="0" ss:Italic="0" ss:StrikeThrough="0" ss:Color="#000000"/> <NumberFormat ss:Format="[$-409]M/d/yy"/> </Style> <Style ss:ID="1"> <NumberFormat ss:Format="yyyy-M-d HH:mm:ss AM/PM"/> </Style> </Styles> <Names/> <Worksheet ss:Name="Sheet1"> <ss:Table> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="12"/> <ss:Column ss:Width="7"/> <ss:Column ss:Width="5"/> <ss:Column ss:Width="24"/> <ss:Column ss:Width="0"/> <Row> <Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="14" ss:MergeDown="0"> <Data ss:Type="String"/> </Cell> <Cell ss:Index="16" ss:StyleID="21" ss:MergeAcross="16" ss:MergeDown="0"> <Data ss:Type="String"/> </Cell> </Row> <Row> <Cell ss:Index="1" ss:StyleID="22" ss:MergeAcross="31" ss:MergeDown="0"> <Data ss:Type="String">Günlük Rapor</Data> </Cell> </Row> <Row> <Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="31" ss:MergeDown="0"> <Data ss:Type="String"/> </Cell> </Row> <Row> <Cell ss:Index="1" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Bölüm</Data> </Cell> <Cell ss:Index="2" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Kayıt Türü</Data> </Cell> <Cell ss:Index="3" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Kayıt Numarası</Data> </Cell> <Cell ss:Index="4" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Durumu</Data> </Cell> <Cell ss:Index="5" ss:StyleID="23" ss:MergeAcross="1" ss:MergeDown="0"> <Data ss:Type="String">Durum Tarihi</Data> </Cell> <Cell ss:Index="7" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Kaynak</Data> </Cell> <Cell ss:Index="8" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Kaydın içeriği</Data> </Cell> <Cell ss:Index="9" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Kaydı Açan</Data> </Cell> <Cell ss:Index="10" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Önem Seviyesi 1</Data> </Cell> <Cell ss:Index="11" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Önem Seviyesi 2</Data> </Cell> <Cell ss:Index="12" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Önem Seviyesi 3</Data> </Cell> <Cell ss:Index="13" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Önem Seviyesi 4</Data> </Cell> <Cell ss:Index="14" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Hangi Grupta</Data> </Cell> <Cell ss:Index="15" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">İlgilenen</Data> </Cell> <Cell ss:Index="16" ss:StyleID="23" ss:MergeAcross="1" ss:MergeDown="0"> <Data ss:Type="String">Rapor Tarihi</Data> </Cell> <Cell ss:Index="18" ss:StyleID="23" ss:MergeAcross="1" ss:MergeDown="0"> <Data ss:Type="String">Açılma Tarihi</Data> </Cell> <Cell ss:Index="20" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Son Değişiklik Yapan</Data> </Cell> <Cell ss:Index="21" ss:StyleID="23" ss:MergeAcross="1" ss:MergeDown="0"> <Data ss:Type="String">Değiştirilme Tarihi</Data> </Cell> <Cell ss:Index="23" ss:StyleID="23" ss:MergeAcross="1" ss:MergeDown="0"> <Data ss:Type="String">Bekletmeye Alınma Tarihi</Data> </Cell> <Cell ss:Index="25" ss:StyleID="23" ss:MergeAcross="1" ss:MergeDown="0"> <Data ss:Type="String">Etkilenme Tarihi</Data> </Cell> <Cell ss:Index="27" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Etkilenen Kişi</Data> </Cell> <Cell ss:Index="28" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Etkilenen TLF</Data> </Cell> <Cell ss:Index="29" ss:StyleID="23" ss:MergeAcross="2" ss:MergeDown="0"> <Data ss:Type="String">Açan Tlf</Data> </Cell> <Cell ss:Index="32" ss:StyleID="23" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Sistem Numarası</Data> </Cell> </Row> <Row> <Cell ss:Index="1" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">URT-00</Data> </Cell> <Cell ss:Index="2" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">SR</Data> </Cell> <Cell ss:Index="3" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">IR10041</Data> </Cell> <Cell ss:Index="4" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Bekletiliyor</Data> </Cell> <Cell ss:Index="5" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T18:29:45</Data> </Cell> <Cell ss:Index="6" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T18:29:45</Data> </Cell> <Cell ss:Index="7" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Telefon</Data> </Cell> <Cell ss:Index="8" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Test Açaklı Açıldı</Data> </Cell> <Cell ss:Index="9" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">ejderateşi</Data> </Cell> <Cell ss:Index="10" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String"/> </Cell> <Cell ss:Index="11" ss:StyleID="27" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="Number">2</Data> </Cell> <Cell ss:Index="12" ss:StyleID="27" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="Number">2</Data> </Cell> <Cell ss:Index="13" ss:StyleID="27" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="Number">3</Data> </Cell> <Cell ss:Index="14" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Elektrik Grubunda</Data> </Cell> <Cell ss:Index="15" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">Hakkı</Data> </Cell> <Cell ss:Index="16" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T17:23:32</Data> </Cell> <Cell ss:Index="17" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T17:23:32</Data> </Cell> <Cell ss:Index="18" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T17:39:32</Data> </Cell> <Cell ss:Index="19" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T17:39:32</Data> </Cell> <Cell ss:Index="20" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">ejderateşi</Data> </Cell> <Cell ss:Index="21" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T18:29:45</Data> </Cell> <Cell ss:Index="22" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T18:29:45</Data> </Cell> <Cell ss:Index="23" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T18:29:45</Data> </Cell> <Cell ss:Index="24" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T18:29:45</Data> </Cell> <Cell ss:Index="25" ss:StyleID="25" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T17:23:32</Data> </Cell> <Cell ss:Index="26" ss:StyleID="26" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="DateTime">2011-04-04T17:23:32</Data> </Cell> <Cell ss:Index="27" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">ejder</Data> </Cell> <Cell ss:Index="28" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">1654</Data> </Cell> <Cell ss:Index="29" ss:StyleID="24" ss:MergeAcross="2" ss:MergeDown="0"> <Data ss:Type="String">1543</Data> </Cell> <Cell ss:Index="32" ss:StyleID="24" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">21030000</Data> </Cell> </Row> <Row> <Cell ss:Index="1" ss:StyleID="20" ss:MergeAcross="31" ss:MergeDown="0"> <Data ss:Type="String"/> </Cell> </Row> <Row> <Cell ss:Index="1" ss:StyleID="28" ss:MergeAcross="4" ss:MergeDown="0"> <Data ss:Type="String">Toplam Kayıt Sayısı:</Data> </Cell> <Cell ss:Index="6" ss:StyleID="29" ss:MergeAcross="26" ss:MergeDown="0"> <Data ss:Type="Number">1</Data> </Cell> </Row> <Row> <Cell ss:Index="1" ss:StyleID="30" ss:MergeAcross="4" ss:MergeDown="0"> <Data ss:Type="String">Dinemik Kod:</Data> </Cell> <Cell ss:Index="6" ss:StyleID="31" ss:MergeAcross="26" ss:MergeDown="0"> <Data ss:Type="String">Gizli</Data> </Cell> </Row> <Row> <Cell ss:Index="1" ss:StyleID="32" ss:MergeAcross="14" ss:MergeDown="0"> <Data ss:Type="String">29.06.2011 08:03:03</Data> </Cell> <Cell ss:Index="16" ss:StyleID="33" ss:MergeAcross="13" ss:MergeDown="0"> <Data ss:Type="String">1</Data> </Cell> <Cell ss:Index="30" ss:StyleID="33" ss:MergeAcross="0" ss:MergeDown="0"> <Data ss:Type="String">/</Data> </Cell> <Cell ss:Index="31" ss:StyleID="33" ss:MergeAcross="1" ss:MergeDown="0"> <Data ss:Type="String">1</Data> </Cell> </Row> </ss:Table> <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel"> <PageSetup> <Layout x:Orientation="Landscape"/> </PageSetup> </WorksheetOptions> </Worksheet> </Workbook>
Program bu şekilde bir dosyayı xml olarak vermekte.
ben buradaki bilgileri nasıl okuyabilirim?
fakat sorun su 1.2.3 satirda günlük rapor yazmakta
ve sonradan onceki 4 satirinda farkli bilgiler yer almakta benim bilgi almak istediğim bu iki grubun icinde kalan 32 kolondan oluşan verileri cekip değişkenlere atamak istiyorum yardımcı olursanız sevinirim.
Gönderildi : 30/06/2011 20:04
Merhaba,
Bu işi en güzel BizTalk Server kullanarak yapabilirsiniz.
Gönderildi : 01/07/2011 13:55