473,385 Members | 1,379 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 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 1994
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
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...
6
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...
0
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...
3
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.
1
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 ?
5
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();...
1
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...
0
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...
1
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...
12
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...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
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...

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.