473,398 Members | 2,212 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > xml > questions > convert the data in xml file to excel spreadsheet

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

Convert the data in XML file to Excel spreadsheet

Hi,

This is the code of the XML file, when I open it in Excel it asks to Open as text. How can I convert the code/data below and view it in a excel spreadsheet. I use Mac Office 2011 and only allows me to open the XML file as "Open as Text".

Here is the code:

Expand|Select|Wrap|Line Numbers
  1. <xml version>
  2. "<Workbook xmlns=""urn:schemas-microsoft-com:office:spreadsheet"""
  3. " xmlns:o=""urn:schemas-microsoft-com:office:office"""
  4. " xmlns:x=""urn:schemas-    microsoft-com:office:excel"""
  5. " xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet"">"
  6.  <Styles>
  7. " <Style ss:ID=""Default"" ss:Name=""Normal"">"
  8. " <Alignment ss:Vertical=""Bottom""/>"
  9.  <Borders/> <Font/> <Interior/> <NumberFormat/> <Protection/> </Style>
  10. " <Style ss:ID=""BoldColumn"">"
  11. " <Font x:Family=""Swiss"" ss:Bold=""1""/>"
  12.  </Style>
  13. " <Style     ss:ID=""StringLiteral"">"
  14. " <NumberFormat ss:Format=""@""/>"
  15.  </Style>
  16. " <Style ss:ID=""Decimal"">"
  17. " <NumberFormat ss:Format=""0.0000""/>"
  18.  </Style>
  19. " <Style ss:ID=""Integer"">"
  20. " <NumberFormat ss:Format=""0""/>"
  21.  </Style>
  22. " <Style ss:ID=""DateLiteral"">"
  23. " <NumberFormat ss:Format=""mm/dd/yyyy;@""/>"
  24.  </Style> </Styles>
  25. " <Worksheet ss:Name=""Sheet1""><Table><Row><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">UniqueKey</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoZugangsObjektID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoMandantID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoFremdObjektID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoAktiverSecKey</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoFremdObjBezeichnung</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoErfasstAm</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoErfasstVon</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoPruefWert</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoBcKoordID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoBcZugangsObjektID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoBcBCID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoBcGueltigVon</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoBcGueltigBis</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoBcErfasstAm</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoBcErfasstVon</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoBcGeaendertAm</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZoBcGeaendertVon</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcBCID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcMandantID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcSerienNummer</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcSimID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcBenzinCardID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcEinkaufDatum</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcErfasstAm</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcErfasstVon</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcGeaendertAm</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcGeaendertVon</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcBemerkungen</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcHardwareVersion</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcStatus</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BcBCTypId</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkBenzinCardID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkKartenGesellschaftID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkKartenGesellschaft</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkKartenName</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkKartenNr</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkPinCode</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkBemerkungen</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkAktiv</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkMandantID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkChipID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkErfasstAm</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BkErfasstVon</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkSimID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkSimNr</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkRufNr</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkDatenNr</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkPin1</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkPuk1</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkPin2</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkPuk2</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkBemerkung</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkProviderID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkProviderName</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkAktiv</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkMandantID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkErfasstAm</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SkErfasstVon</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">FWVersion</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">AmpelStatusId</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">AmpelStatusText</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">BCStatusText</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SprachCode</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ZugangsObjektID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">GueltigBis</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">GueltigVon</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">PruefWert</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">StatusID</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SMSCTelNr</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SMSDestTelNr</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">CallCenterTelNr</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">FZGSMTelNr</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">FZGSMPIN</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">FuelPIN</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">KMFaktor</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SWAnpFz</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">EmergencyCode</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SWTyp</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">HWVersion</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">SWTyp2</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">GSMMode</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">TimeMode</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">ConfigBits</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">CarConfig1</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">CarConfig2</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">CarConfig3</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">CarConfig4</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">CarConfig5</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">CarConfig6</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">CarConfig7</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">Functions1</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">Functions2</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">Functions3</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">Functions4</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">Functions5</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">FuelAlertStates</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">FuelOffset</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">FuelGain</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">AbmeldenTime</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">StandardSprache</Data></Cell><Cell ss:StyleID=""BoldColumn""><Data ss:Type=""String"">HWOptions</Data></Cell></Row><Row><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">55372966_4824_0_4836</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55372966</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">217</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Peugeot 207</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T12:21:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Asve</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00015342</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">2007</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55372966</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4824</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-07-22T10:34:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">3000-01-31T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-07-22T10:34:51.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4824</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">601591</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4836</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T17:15:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T17:15:11.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">20</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">True</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4836</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">89470311100812046705</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">004797556809</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">004797556809</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">7114</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">05856585</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">1</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Swisscom</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">True</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T17:55:58.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">63</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">2</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Orange</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Active</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">en</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55372966</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">3000-01-01T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-07-22T15:22:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">15342</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">2</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">004790002100</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0041792909110</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">5015</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">5234</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">20</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">11000010100011</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">100000000011000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">110</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">100000110110010</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">100010000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">1000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">63</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">10</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell></Row><Row><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">55372927_4836_0_4848</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55372927</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">169</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Peugeot 308</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-17T08:22:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Asve</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00015349</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">2047</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55372927</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4836</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-08-05T15:35:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">3000-01-31T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-08-05T15:35:42.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4836</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">601603</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4848</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T17:20:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T17:20:50.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">20</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">True</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4848</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">89470311100730103026</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">004797556821</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">004797556821</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">6490</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">88184297</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">1</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Swisscom</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">True</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T18:06:10.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">63</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">2</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Orange</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Active</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">en</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55372927</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">3000-01-01T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-08-08T15:37:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">15349</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">2</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">004790002100</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0041792909110</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">5015</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3782</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">20</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">11000010100011</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">100000000011000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">110</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">100000110110010</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">100010000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">1000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">63</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">10</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell></Row><Row><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">55372956_4834_0_4846</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55372956</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">99</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Peugeot 207</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-24T08:38:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00017643</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">2235</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55372956</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4834</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-11-17T13:13:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">3000-01-31T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-11-17T13:13:49.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4834</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">601601</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4846</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T17:19:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T17:19:38.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">20</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">True</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4846</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">89470311100730102994</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">004797556819</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">004797556819</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">8465</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">58090348</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">1</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Swisscom</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">True</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-11-29T18:04:07.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">stefan</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">63</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">1</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Green</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Active</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">en</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55372956</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">3000-01-01T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-11-17T14:07:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">17643</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">004790002100</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0041792909110</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">5015</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">7478</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">20</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">11000010100011</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">100000000011000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">110</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">100000110110010</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">100010000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">1000000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">0</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">63</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">10</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00000000</Data></Cell></Row><Row><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">55373284_4915_0_4907</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55373284</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">290</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">0</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Peugeot 308 sw</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-06-08T09:18:00.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">Asve</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">00066178</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">2269</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">55373284</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4915</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-11-30T12:45:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">3000-01-31T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2011-11-30T12:45:28.000</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4915</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">3401</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String"">601613</Data></Cell><Cell ss:StyleID=""Integer""><Data ss:Type=""Number"">4907</Data></Cell><Cell ss:StyleID=""StringLiteral""><Data ss:Type=""String""></Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-12-23T00:00:00.000</Data></Cell><Cell ss:StyleID=""DateLiteral""><Data ss:Type=""DateTime"">2010-12-24T08:2"

Thanks,
Sep 12 '12 #1
4 1996
pod
298 100+
There might be other ways to do this but you could try using MS Access; Access can import XML files into a new table, then you can export that table to Excel.
Sep 12 '12 #2
thanks pod, i will give it a try....but i know there is a way to some how edit the xml file to populate and form the excel spreadsheet. i was hoping maybe someone could help with this...

i'd appreciate it
Sep 12 '12 #3
pod
298 100+
if there is a need to do this on a daily basis, I agree that a script would be better.
Sep 12 '12 #4
use below code to convert by using a .NET Excel component Spire.XLS via below code:

Expand|Select|Wrap|Line Numbers
  1.             Workbook workbook = new Workbook(); 
  2.             workbook.LoadFromFile(@"..\..\test.xml"); 
  3.             workbook.SaveToFile("sample.xls");
Sep 14 '12 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

6
Parsing Excel spreadsheet to db
by: Phil Powell | last post by:
What would one best recommend to parse an existing Excel spreadsheet (was done in Excel 97 or 2000 not sure to be honest)? I am looking for the most practical way of parsing an existing...
PHP
6
Getting data from excel spreadsheet column into access table
by: syvman | last post by:
Hi everyone... I am pulling my hair out trying to do this, and was wondering if someone could give me some assistance... I have an Excel spreadsheet containing several worksheets. I'd like to be...
Microsoft Access / VBA
0
how do you read in data from excel spreadsheet for xml
by: dotnetnoob | last post by:
i need to read the data in a spreadsheet and use the data for attribute to put into xml file. i search the web but all the example that i see is to create macro by VBA. can someone give me an...
.NET Framework
3
How to using asp to insert data into excel spreadsheet ?
by: kelvinweb | last post by:
Hi All, How to using one excel template to insert data into another excel spreadsheet by using asp programming ? Please help.
ASP / Active Server Pages
1
Update Excel Spreadsheet Help
by: kelvinweb | last post by:
Hi All, How to using asp script update data in Excel Spreadsheet with style (ie, Bold, Font Size ..) ? Is it possible to do that ?
ASP / Active Server Pages
5
How to read data from Excel spreadsheet?
by: barbara_dave | last post by:
Hi All, I need to read data from a Excel spreadsheet, but I got the problem when I tried the code below: StringBuilder sbConn = new StringBuilder();...
C# / C Sharp
1
Extract data from Excel Spreadsheet using C# or VB.net
by: fly2irfan | last post by:
Hi All, I am new to IT/Developer Network I have to create an application which has to Extract data from Excel Spreadsheet using C# or VB.net then save the data into SQL database. Can anybody...
.NET Framework
0
Retrieve Data from Excel to fill DataGridView
by: lenniekuah | last post by:
Hi Friends, I need your help. Please help me. I am trying to retrieve data from Excel Spreadsheet to fill the DataGridView for display prior to updating SQL SERVER with individual DataGridView...
.NET Framework
1
Linking word textbox data to excel spreadsheet
by: kmariojr77 | last post by:
I am wanting to link some data from a textbox in word to an excel spread sheet. I will have many similar word documents, so when data is entered into the spreadsheet the next time, i need it to move...
Visual Basic 4 / 5 / 6
12
How to Import data from excel spreadsheet vb.net?
by: sasasasa | last post by:
Hello I am trying to import data from an excel file but the spreadsheet name is causing problem. If I use 'Sheet1' as the name of the spreadsheet from which I want data, then it works fine but I...
Visual Basic .NET
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing
0
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server
0
tracyyun
Discussion: How does Zigbee compare with other wireless protocols in smart home applications?
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
General

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.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!