API tools faq
paste
Advertisement
rplantiko

Read MSO Table via ABAP XML SAX Parser

rplantiko
Sep 12th, 2011
816
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ABAP 55.86 KB | None | 0 0
raw download clone embed print report
  1. *&---------------------------------------------------------------------*
  2. *& Report  ZZ_TEST_READ_MSO_XML
  3. *&---------------------------------------------------------------------*
  4. *& Tabelle mit Tabelleninformationen einlesen
  5. *& Gehört zu einer Diskussion im Kommentarbereich des Blogs
  6. *& http://ruediger-plantiko.blogspot.com/2009/03/ereignisbasierter-xml-parser-in-abap.html
  7. *&---------------------------------------------------------------------*
  8.  
  9. report  zz_test_read_mso_xml.
  10.  
  11. data: go_xml type ref to if_ixml,
  12.       go_stream_factory type ref to if_ixml_stream_factory.
  13.  
  14. * Datentyp Zielstruktur
  15. types: ty_data_tab type standard table of stringtab,
  16.        begin of ty_colprops,
  17.          title type string,          " Titel = Erste Datenzeile
  18. * Weitere Eigenschaften der Column (Format, Datentyp etc.)
  19.          properties type tihttpnvp,  " Tabelle von Name/Wert-Paaren
  20.        end of ty_colprops,
  21.        ty_colprops_tab type standard table of ty_colprops.
  22.  
  23.  
  24. load-of-program.
  25.   perform get_xml_factory.
  26.  
  27. start-of-selection.
  28.   perform start.
  29.  
  30. *
  31. form start.
  32.  
  33.   data: lt_data type ty_data_tab,
  34.         lt_colprops type ty_colprops_tab,
  35.         lo_xml   type ref to if_ixml_istream.
  36.  
  37.   perform build_xml changing lo_xml.
  38.  
  39.   perform parse_xml using lo_xml
  40.                     changing lt_data lt_colprops.
  41.  
  42. * Ergebnis lt_data und lt_colprops betrachten:
  43.   break-point.
  44.  
  45. endform.                    "start
  46.  
  47. * --- Parsen
  48. form parse_xml using io_xml type ref to if_ixml_istream
  49.                changing et_data type ty_data_tab
  50.                         et_colprops type ty_colprops_tab.
  51.  
  52.   clear: et_data, et_colprops.
  53.  
  54.   data: lo_parser   type ref to if_ixml_parser,
  55.         lv_events   type i.
  56.  
  57. * SAX Parser beschaffen
  58.   perform get_sax_parser using io_xml
  59.                          changing lo_parser.
  60.  
  61. * Ereignisse können mit '+' in ein Bitfeld zusammengesetzt werden
  62.   lv_events =  if_ixml_event=>co_event_element_pre2  " Element geöffnet, alle Attribute bekannt
  63.             +  if_ixml_event=>co_event_text_post     " Textknoten
  64.             +  if_ixml_event=>co_event_element_post. " Element beendet
  65.  
  66. * Registrieren
  67.   lo_parser->set_event_subscription( lv_events ).
  68.  
  69.   perform parse_loop using lo_parser changing et_data et_colprops.
  70.  
  71. endform.                    "parse_xml
  72.  
  73. *
  74. form parse_loop using io_parser      type ref to if_ixml_parser
  75.                 changing et_data     type ty_data_tab
  76.                          et_colprops type ty_colprops_tab.
  77.  
  78.   data: lo_event        type ref to if_ixml_event,
  79.         lv_type         type i,
  80.         lv_row_count    type i,
  81.         lv_current_node type string,
  82.         lt_text         type stringtab.
  83.  
  84.   do.
  85.  
  86.     lo_event = io_parser->parse_event( ).
  87.     if lo_event is initial.
  88.       exit.
  89.     endif.
  90.  
  91.     lv_type = lo_event->get_type( ).
  92.     case lv_type.
  93.       when if_ixml_event=>co_event_element_pre2.
  94. * Neues Element wurde entdeckt
  95.         perform do_start_element
  96.           using
  97.             lo_event
  98.           changing
  99.             lv_current_node
  100.             et_colprops.
  101.       when if_ixml_event=>co_event_text_post.
  102. * Das Lesen eines Textknotens wurde abgeschlossen
  103.         perform do_text
  104.           using
  105.             lo_event
  106.             lv_current_node
  107.           changing
  108.             lt_text.
  109.       when if_ixml_event=>co_event_element_post.
  110. * Schliessendes Element wurde erkannt
  111.         perform do_end_element
  112.           using
  113.             lo_event
  114.           changing
  115.             lt_text
  116.             lv_row_count
  117.             et_data
  118.             et_colprops.
  119.     endcase.
  120.  
  121.   enddo.
  122.  
  123.  
  124. endform.                    "parse_loop
  125.  
  126. * ---
  127. form do_start_element using io_event type ref to if_ixml_event
  128.                       changing ev_current_node type string
  129.                                et_colprops     type ty_colprops_tab.
  130.  
  131.   data: lo_attributes type ref to if_ixml_named_node_map,
  132.         ls_colprops type ty_colprops.
  133.  
  134.   ev_current_node = io_event->get_name( ).
  135.  
  136.   if ev_current_node eq 'Column'.
  137.     lo_attributes = io_event->get_attributes( ).
  138.     perform map_attributes using lo_attributes changing ls_colprops-properties.
  139.     append ls_colprops to et_colprops.
  140.   endif.
  141.  
  142. endform.                    "do_start_element
  143.  
  144.  
  145. * ---
  146. form do_end_element using io_event type ref to if_ixml_event
  147.                     changing ct_text type stringtab
  148.                              cv_row_count type i
  149.                              ct_data type ty_data_tab
  150.                              ct_colprops type ty_colprops_tab.
  151.  
  152.   data: lv_closing_node type string.
  153.  
  154.   lv_closing_node = io_event->get_name( ).
  155.   if lv_closing_node eq 'Row'.
  156.     add 1 to cv_row_count.
  157.     if cv_row_count = 1.
  158. * Erste Zeile wird zu Titelzeile
  159.       perform add_titles using ct_text changing ct_colprops.
  160.     else.
  161. * Alle nachfolgenden Zeilen sind Datenzeilen
  162.       append ct_text to ct_data.
  163.     endif.
  164.     clear ct_text.
  165.   endif.
  166.  
  167. endform.                    "do_end_element
  168.  
  169.  
  170. * ---
  171. form do_text using io_event type ref to if_ixml_event
  172.                    iv_current_node type string
  173.              changing ct_text type stringtab.
  174.  
  175.   data: lv_text type string.
  176.  
  177.   if iv_current_node eq 'Data'.
  178.     lv_text = io_event->get_value( ).
  179.     append lv_text to ct_text.
  180.   endif.
  181.  
  182. endform.                    "do_text
  183.  
  184. * ---
  185. form map_attributes
  186.      using io_attributes type ref to if_ixml_named_node_map
  187.      changing et_properties type tihttpnvp.
  188.  
  189.   data: lo_iterator type ref to if_ixml_node_iterator,
  190.         lo_node type ref to if_ixml_node,
  191.         ls_property type ihttpnvp.
  192.  
  193.   lo_iterator = io_attributes->create_iterator( ).
  194.  
  195.   clear et_properties.
  196.  
  197.   do.
  198.     lo_node = lo_iterator->get_next( ).
  199.     if lo_node is not bound.
  200.       exit.
  201.     endif.
  202.  
  203.     ls_property-name  = lo_node->get_name( ).
  204.     ls_property-value = lo_node->get_value( ).
  205.  
  206.     append ls_property to et_properties.
  207.  
  208.   enddo.
  209.  
  210. endform.                    "map_attributes
  211.  
  212. * ---
  213. form add_titles using it_text type stringtab
  214.                 changing ct_colprops type ty_colprops_tab.
  215.  
  216.   field-symbols: <ls_colprops> type ty_colprops.
  217.  
  218.   do.
  219.     read table ct_colprops assigning <ls_colprops> index sy-index.
  220.     if sy-subrc ne 0.
  221.       exit.
  222.     endif.
  223.     read table it_text into <ls_colprops>-title index sy-index.
  224.   enddo.
  225.  
  226. endform.                    "add_titles
  227.  
  228.  
  229. * --- XML-Fabrik beschaffen
  230. form get_xml_factory.
  231.   go_xml            = cl_ixml=>create( ).
  232.   go_stream_factory = go_xml->create_stream_factory( ).
  233. endform.                    "get_xml_factory
  234.  
  235. * --- SAX Parser beschaffen
  236. form get_sax_parser using io_xml type ref to if_ixml_istream
  237.                     changing eo_parser type ref to if_ixml_parser.
  238.  
  239.   data: lo_dummy    type ref to if_ixml_document.
  240.  
  241. * Eine Instanz eines XML-Doc wird zwar benötigt, aber hier nicht verwendet
  242.   lo_dummy = go_xml->create_document( ).
  243.  
  244. * Parser wird pro Dokument beschafft
  245.   eo_parser   = go_xml->create_parser( document       = lo_dummy
  246.                                        istream        = io_xml
  247.                                        stream_factory = go_stream_factory ).
  248.  
  249. * --- Entscheidende Stelle: Hier wird die DOM-Generierung abgeschaltet!
  250.   eo_parser->set_dom_generating( space ).
  251.  
  252. endform.
  253.  
  254.  
  255. * --- Das Beispiel-XML von Enno als Stream bereitstellen
  256. form build_xml changing eo_xml type ref to if_ixml_istream.
  257.  
  258.   data: lv_xml type string.
  259.  
  260.  
  261.   perform get_xml_as_string changing lv_xml.
  262.  
  263.  
  264.   eo_xml = go_stream_factory->create_istream_string( lv_xml ).
  265.  
  266.  
  267. endform.                    "build_xml
  268.  
  269. * --- Das Beispiel-XML von Enno als String im ABAP herstellen
  270. form get_xml_as_string changing ev_xml type string.
  271.   define _concat.
  272.     concatenate ev_xml &1 into ev_xml respecting blanks.
  273.   end-of-definition.
  274.  
  275.   clear ev_xml.
  276.   _concat :
  277. `<?xml version="1.0" encoding="utf-16"?> <?mso-application `,
  278. `progid="Excel.Sheet"?><Workbook xmlns="urn:schemas-microsoft-`,
  279. `com:office:spreadsheet" xmlns:Integer="java://java.lang.Integer" `,
  280. `xmlns:SL="http://schemas.microsoft.com/schemaLibrary/2003/core" `,
  281. `xmlns:alv="http://www.sap.com/ALV/2.5" `,
  282. `xmlns:aml="http://schemas.microsoft.com/aml/2001/core" `,
  283. `xmlns:asx="http://www.sap.com/abapxml" `,
  284. `xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dt="uuid:C2F41010-65B3-11d1-`,
  285. `A29F-00AA00C14882" xmlns:fo="http://www.w3.org/1999/XSL/Format" `,
  286. `xmlns:html="http://www.w3.org/TR/REC-html40" `,
  287. `xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:o="urn:schemas-microsoft-`,
  288. `com:office:office" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" `,
  289. `xmlns:v="urn:schemas-microsoft-com:vml" xmlns:x="urn:schemas-microsoft-`,
  290. `com:office:excel" xmlns:xlink="http://www.w3.org/1999/xlink"><DocumentProperties `,
  291. `xmlns="urn:schemas-microsoft-com:office:office"/><OfficeDocumentSettings `,
  292. `xmlns="urn:schemas-microsoft-`,
  293. `com:office:office"><DownloadComponents/><LocationOfComponents `,
  294. `HRef="file:///\\msowc.cab"/></OfficeDocumentSettings><ExcelWorkbook `,
  295. `xmlns="urn:schemas-microsoft-`,
  296. `com:office:excel"><WindowHeight>12660</WindowHeight><WindowWidth>18060</WindowWi`,
  297. `dth><WindowTopX>240</WindowTopX><WindowTopY>60</WindowTopY><ProtectStructure>Fal`,
  298. `se</ProtectStructure><ProtectWindows>False</ProtectWindows></ExcelWorkbook><Styl`,
  299. `es><Style ss:ID="Default" ss:Name="Normal"><Alignment `,
  300. `ss:Vertical="Bottom"/><Borders/><Font/><Interior/><NumberFormat/><Protection/></`,
  301. `Style><Style ss:ID="ce1"><Alignment ss:Horizontal="Left" `,
  302. `ss:Vertical="Bottom"/></Style><Style ss:ID="ce2"><Alignment ss:Horizontal="Left" `,
  303. `ss:Vertical="Bottom"/><NumberFormat ss:Format="Short Date"/></Style><Style `,
  304. `ss:ID="ce3"><Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/><NumberFormat `,
  305. `ss:Format="[$-F400]h:mm:ss\ AM/PM"/>&gt; </Style><Style `,
  306. `ss:ID="ce4"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  307. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  308. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  309. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  310. `ss:Weight="1"/></Borders><Interior ss:Color="#00CCFF" `,
  311. `ss:Pattern="Solid"/></Style><Style ss:ID="ce5"><Alignment ss:Horizontal="Left" `,
  312. `ss:Vertical="Bottom"/><Font ss:Bold="1"/></Style><Style ss:ID="ce6"><Alignment `,
  313. `ss:Horizontal="Left" ss:Vertical="Bottom"/><Font ss:Italic="1"/></Style><Style `,
  314. `ss:ID="ce10"><Alignment ss:Horizontal="Right" `,
  315. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0"/></Style><Style `,
  316. `ss:ID="ce11"><Alignment ss:Horizontal="Right" `,
  317. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.0"/></Style><Style `,
  318. `ss:ID="ce12"><Alignment ss:Horizontal="Right" `,
  319. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.00"/></Style><Style `,
  320. `ss:ID="ce13"><Alignment ss:Horizontal="Right" `,
  321. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.000"/></Style><Style `,
  322. `ss:ID="ce14"><Alignment ss:Horizontal="Right" `,
  323. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.0000"/></Style><Style `,
  324. `ss:ID="ce15"><Alignment ss:Horizontal="Right" `,
  325. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.00000"/></Style><Style `,
  326. `ss:ID="ce16"><Alignment ss:Horizontal="Right" `,
  327. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.000000"/></Style><Style `,
  328. `ss:ID="ce17"><Alignment ss:Horizontal="Right" `,
  329. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.0000000"/></Style><Style `,
  330. `ss:ID="ce18"><Alignment ss:Horizontal="Right" `,
  331. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.00000000"/></Style><Style `,
  332. `ss:ID="ce19"><Alignment ss:Horizontal="Right" `,
  333. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.000000000"/></Style><Style `,
  334. `ss:ID="ce1H"><Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/><Font `,
  335. `ss:Color="#0000FF" ss:Underline="Single"/></Style><Style ss:ID="ce2H"><Alignment `,
  336. `ss:Horizontal="Left" ss:Vertical="Bottom"/><NumberFormat ss:Format="Short `,
  337. `Date"/><Font ss:Color="#0000FF" ss:Underline="Single"/></Style><Style `,
  338. `ss:ID="ce3H"><Alignment ss:Horizontal="Left" ss:Vertical="Bottom"/><NumberFormat `,
  339. `ss:Format="Long Time"/><Font ss:Color="#0000FF" `,
  340. `ss:Underline="Single"/></Style><Style ss:ID="ce10H"><Alignment `,
  341. `ss:Horizontal="Right" ss:Vertical="Bottom"/><NumberFormat ss:Format="0"/><Font `,
  342. `ss:Color="#0000FF" ss:Underline="Single"/></Style><Style `,
  343. `ss:ID="ce11H"><Alignment ss:Horizontal="Right" `,
  344. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.0"/><Font ss:Color="#0000FF" `,
  345. `ss:Underline="Single"/></Style><Style ss:ID="ce12H"><Alignment `,
  346. `ss:Horizontal="Right" ss:Vertical="Bottom"/><NumberFormat `,
  347. `ss:Format="0.00"/><Font ss:Color="#0000FF" ss:Underline="Single"/></Style><Style `,
  348. `ss:ID="ce13H"><Alignment ss:Horizontal="Right" `,
  349. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.000"/><Font ss:Color="#0000FF" `,
  350. `ss:Underline="Single"/></Style><Style ss:ID="ce14H"><Alignment `,
  351. `ss:Horizontal="Right" ss:Vertical="Bottom"/><NumberFormat `,
  352. `ss:Format="0.0000"/><Font ss:Color="#0000FF" `,
  353. `ss:Underline="Single"/></Style><Style ss:ID="ce15H"><Alignment `,
  354. `ss:Horizontal="Right" ss:Vertical="Bottom"/><NumberFormat `,
  355. `ss:Format="0.00000"/><Font ss:Color="#0000FF" `,
  356. `ss:Underline="Single"/></Style><Style ss:ID="ce16H"><Alignment `,
  357. `ss:Horizontal="Right" ss:Vertical="Bottom"/><NumberFormat `,
  358. `ss:Format="0.000000"/><Font ss:Color="#0000FF" `,
  359. `ss:Underline="Single"/></Style><Style ss:ID="ce17H"><Alignment `,
  360. `ss:Horizontal="Right" ss:Vertical="Bottom"/><NumberFormat `,
  361. `ss:Format="0.0000000"/><Font ss:Color="#0000FF" `,
  362. `ss:Underline="Single"/></Style><Style ss:ID="ce18H"><Alignment `,
  363. `ss:Horizontal="Right" ss:Vertical="Bottom"/><NumberFormat `,
  364. `ss:Format="0.00000000"/><Font ss:Color="#0000FF" `,
  365. `ss:Underline="Single"/></Style><Style ss:ID="ce19H"><Alignment `,
  366. `ss:Horizontal="Right" ss:Vertical="Bottom"/><NumberFormat `,
  367. `ss:Format="0.000000000"/><Font ss:Color="#0000FF" `,
  368. `ss:Underline="Single"/></Style><Style ss:ID="ce1S"><Borders><Border `,
  369. `ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/><Border `,
  370. `ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/><Border `,
  371. `ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/><Border `,
  372. `ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Interior `,
  373. `ss:Color="#FFFF00" ss:Pattern="Solid"/></Style><Style ss:ID="ce2S"><Alignment `,
  374. `ss:Horizontal="Left" ss:Vertical="Bottom"/><Borders><Border ss:Position="Bottom" `,
  375. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" `,
  376. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" `,
  377. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" `,
  378. `ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Interior ss:Color="#FFFF00" `,
  379. `ss:Pattern="Solid"/><NumberFormat ss:Format="Short Date"/></Style><Style `,
  380. `ss:ID="ce3S"><Alignment ss:Horizontal="Left" `,
  381. `ss:Vertical="Bottom"/><Borders><Border ss:Position="Bottom" `,
  382. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" `,
  383. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" `,
  384. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" `,
  385. `ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Interior ss:Color="#FFFF00" `,
  386. `ss:Pattern="Solid"/><NumberFormat ss:Format="Long Time"/></Style><Style `,
  387. `ss:ID="ce10S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  388. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  389. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  390. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  391. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  392. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  393. `ss:Pattern="Solid"/><NumberFormat ss:Format="0"/></Style><Style `,
  394. `ss:ID="ce11S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  395. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  396. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  397. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  398. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  399. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  400. `ss:Pattern="Solid"/><NumberFormat ss:Format="0.0"/></Style><Style `,
  401. `ss:ID="ce12S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  402. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  403. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  404. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  405. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  406. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  407. `ss:Pattern="Solid"/><NumberFormat ss:Format="0.00"/></Style><Style `,
  408. `ss:ID="ce13S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  409. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  410. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  411. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  412. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  413. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  414. `ss:Pattern="Solid"/><NumberFormat ss:Format="0.000"/></Style><Style `,
  415. `ss:ID="ce14S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  416. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  417. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  418. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  419. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  420. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  421. `ss:Pattern="Solid"/><NumberFormat ss:Format="0.0000"/></Style><Style `,
  422. `ss:ID="ce15S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  423. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  424. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  425. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  426. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  427. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  428. `ss:Pattern="Solid"/><NumberFormat ss:Format="0.00000"/></Style><Style `,
  429. `ss:ID="ce16S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  430. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  431. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  432. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  433. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  434. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  435. `ss:Pattern="Solid"/><NumberFormat ss:Format="0.000000"/></Style><Style `,
  436. `ss:ID="ce17S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  437. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  438. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  439. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  440. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  441. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  442. `ss:Pattern="Solid"/><NumberFormat ss:Format="0.0000000"/></Style><Style `,
  443. `ss:ID="ce18S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  444. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  445. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  446. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  447. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  448. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  449. `ss:Pattern="Solid"/><NumberFormat ss:Format="0.00000000"/></Style><Style `,
  450. `ss:ID="ce19S"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  451. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  452. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  453. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  454. `ss:Weight="1"/></Borders><Alignment ss:Horizontal="Right" `,
  455. `ss:Vertical="Bottom"/><Interior ss:Color="#FFFF00" `,
  456. `ss:Pattern="Solid"/><NumberFormat ss:Format="0.000000000"/></Style><Style `,
  457. `ss:ID="ce1SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  458. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  459. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  460. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  461. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  462. `ss:Pattern="Solid"/></Style><Style ss:ID="ce2SS"><Alignment ss:Horizontal="Left" `,
  463. `ss:Vertical="Bottom"/><Borders><Border ss:Position="Bottom" `,
  464. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" `,
  465. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" `,
  466. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" `,
  467. `ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  468. `ss:Pattern="Solid"/><NumberFormat ss:Format="Short Date"/></Style><Style `,
  469. `ss:ID="ce3SS"><Alignment ss:Horizontal="Left" `,
  470. `ss:Vertical="Bottom"/><Borders><Border ss:Position="Bottom" `,
  471. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Left" `,
  472. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Right" `,
  473. `ss:LineStyle="Continuous" ss:Weight="1"/><Border ss:Position="Top" `,
  474. `ss:LineStyle="Continuous" ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  475. `ss:Pattern="Solid"/><NumberFormat ss:Format="Long Time"/></Style><Style `,
  476. `ss:ID="ce10SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  477. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  478. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  479. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  480. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  481. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  482. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0"/></Style><Style `,
  483. `ss:ID="ce11SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  484. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  485. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  486. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  487. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  488. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  489. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.0"/></Style><Style `,
  490. `ss:ID="ce12SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  491. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  492. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  493. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  494. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  495. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  496. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.00"/></Style><Style `,
  497. `ss:ID="ce13SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  498. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  499. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  500. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  501. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  502. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  503. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.000"/></Style><Style `,
  504. `ss:ID="ce14SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  505. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  506. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  507. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  508. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  509. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  510. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.0000"/></Style><Style `,
  511. `ss:ID="ce15SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  512. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  513. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  514. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  515. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  516. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  517. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.00000"/></Style><Style `,
  518. `ss:ID="ce16SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  519. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  520. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  521. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  522. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  523. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  524. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.000000"/></Style><Style `,
  525. `ss:ID="ce17SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  526. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  527. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  528. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  529. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  530. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  531. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.0000000"/></Style><Style `,
  532. `ss:ID="ce18SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  533. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  534. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  535. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  536. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  537. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  538. `ss:Vertical="Bottom"/><NumberFormat ss:Format="0.00000000"/></Style><Style `,
  539. `ss:ID="ce19SS"><Borders><Border ss:Position="Bottom" ss:LineStyle="Continuous" `,
  540. `ss:Weight="1"/><Border ss:Position="Left" ss:LineStyle="Continuous" `,
  541. `ss:Weight="1"/><Border ss:Position="Right" ss:LineStyle="Continuous" `,
  542. `ss:Weight="1"/><Border ss:Position="Top" ss:LineStyle="Continuous" `,
  543. `ss:Weight="1"/></Borders><Interior ss:Color="#FFFF99" `,
  544. `ss:Pattern="Solid"/><Alignment ss:Horizontal="Right" `,
  545. `ss:Vertical="Bottom"/><NumberFormat `,
  546. `ss:Format="0.000000000"/></Style></Styles><Worksheet ss:Name="Sheet1"><Table `,
  547. `x:FullColumns="1" x:FullRows="1"><Column ss:AutoFitWidth="1" `,
  548. `ss:StyleID="ce1"/><Column ss:AutoFitWidth="1" ss:StyleID="ce1"/><Column `,
  549. `ss:AutoFitWidth="1" ss:StyleID="ce1"/><Column ss:AutoFitWidth="1" `,
  550. `ss:StyleID="ce1"/><Column ss:AutoFitWidth="1" ss:StyleID="ce1"/><Column `,
  551. `ss:AutoFitWidth="1" ss:StyleID="ce1"/><Column ss:AutoFitWidth="1" `,
  552. `ss:StyleID="ce1"/><Column ss:AutoFitWidth="1" ss:StyleID="ce1"/><Column `,
  553. `ss:AutoFitWidth="1" ss:StyleID="ce1"/><Column ss:AutoFitWidth="1" `,
  554. `ss:StyleID="ce1"/><Column ss:AutoFitWidth="1" ss:StyleID="ce1"/><Column `,
  555. `ss:AutoFitWidth="1" ss:StyleID="ce1"/><Column ss:AutoFitWidth="1" `,
  556. `ss:StyleID="ce1"/><Row><Cell ss:StyleID="ce4"><Data `,
  557. `ss:Type="String">Fluggesellschaft</Data></Cell><Cell ss:StyleID="ce4"><Data `,
  558. `ss:Type="String">Verbindungs-Nummer</Data></Cell><Cell ss:StyleID="ce4"><Data `,
  559. `ss:Type="String">Datum des Fluges</Data></Cell><Cell ss:StyleID="ce4"><Data `,
  560. `ss:Type="String">Flugpreis</Data></Cell><Cell ss:StyleID="ce4"><Data `,
  561. `ss:Type="String">Hauswährung d. Fluggesellschaft</Data></Cell><Cell `,
  562. `ss:StyleID="ce4"><Data ss:Type="String">Flugzeugtyp</Data></Cell><Cell `,
  563. `ss:StyleID="ce4"><Data ss:Type="String">Maximale Belegung Economy `,
  564. `Class</Data></Cell><Cell ss:StyleID="ce4"><Data ss:Type="String">Belegte Plätze `,
  565. `Economy Class</Data></Cell><Cell ss:StyleID="ce4"><Data ss:Type="String">Akt. `,
  566. `Buchungssumme</Data></Cell><Cell ss:StyleID="ce4"><Data `,
  567. `ss:Type="String">Maximale Belegung Business Class</Data></Cell><Cell `,
  568. `ss:StyleID="ce4"><Data ss:Type="String">Belegte Plätze Business `,
  569. `Class</Data></Cell><Cell ss:StyleID="ce4"><Data ss:Type="String">Maximale `,
  570. `Belegung First Class</Data></Cell><Cell ss:StyleID="ce4"><Data `,
  571. `ss:Type="String">Belegte Plätze First Class</Data></Cell></Row><Row><Cell `,
  572. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  573. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  574. `ss:StyleID="ce2"><Data ss:Type="DateTime">2009-11-18</Data></Cell><Cell `,
  575. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  576. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  577. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  578. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  579. `ss:StyleID="ce10"><Data ss:Type="Number">373</Data></Cell><Cell `,
  580. `ss:StyleID="ce12"><Data ss:Type="Number">192607.07</Data></Cell><Cell `,
  581. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  582. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  583. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  584. `ss:StyleID="ce10"><Data ss:Type="Number">19</Data></Cell></Row><Row><Cell `,
  585. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  586. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  587. `ss:StyleID="ce2"><Data ss:Type="DateTime">2009-12-16</Data></Cell><Cell `,
  588. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  589. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  590. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  591. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  592. `ss:StyleID="ce10"><Data ss:Type="Number">363</Data></Cell><Cell `,
  593. `ss:StyleID="ce12"><Data ss:Type="Number">188847.19</Data></Cell><Cell `,
  594. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  595. `ss:StyleID="ce10"><Data ss:Type="Number">29</Data></Cell><Cell `,
  596. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  597. `ss:StyleID="ce10"><Data ss:Type="Number">20</Data></Cell></Row><Row><Cell `,
  598. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  599. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  600. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-01-13</Data></Cell><Cell `,
  601. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  602. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  603. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  604. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  605. `ss:StyleID="ce10"><Data ss:Type="Number">365</Data></Cell><Cell `,
  606. `ss:StyleID="ce12"><Data ss:Type="Number">190771.37</Data></Cell><Cell `,
  607. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  608. `ss:StyleID="ce10"><Data ss:Type="Number">28</Data></Cell><Cell `,
  609. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  610. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell></Row><Row><Cell `,
  611. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  612. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  613. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-02-10</Data></Cell><Cell `,
  614. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  615. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  616. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  617. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  618. `ss:StyleID="ce10"><Data ss:Type="Number">371</Data></Cell><Cell `,
  619. `ss:StyleID="ce12"><Data ss:Type="Number">193402.16</Data></Cell><Cell `,
  620. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  621. `ss:StyleID="ce10"><Data ss:Type="Number">30</Data></Cell><Cell `,
  622. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  623. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell></Row><Row><Cell `,
  624. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  625. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  626. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-03-10</Data></Cell><Cell `,
  627. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  628. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  629. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  630. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  631. `ss:StyleID="ce10"><Data ss:Type="Number">373</Data></Cell><Cell `,
  632. `ss:StyleID="ce12"><Data ss:Type="Number">194442.58</Data></Cell><Cell `,
  633. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  634. `ss:StyleID="ce10"><Data ss:Type="Number">30</Data></Cell><Cell `,
  635. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  636. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell></Row><Row><Cell `,
  637. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  638. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  639. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-04-07</Data></Cell><Cell `,
  640. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  641. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  642. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  643. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  644. `ss:StyleID="ce10"><Data ss:Type="Number">371</Data></Cell><Cell `,
  645. `ss:StyleID="ce12"><Data ss:Type="Number">193474.19</Data></Cell><Cell `,
  646. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  647. `ss:StyleID="ce10"><Data ss:Type="Number">30</Data></Cell><Cell `,
  648. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  649. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell></Row><Row><Cell `,
  650. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  651. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  652. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-05-05</Data></Cell><Cell `,
  653. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  654. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  655. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  656. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  657. `ss:StyleID="ce10"><Data ss:Type="Number">372</Data></Cell><Cell `,
  658. `ss:StyleID="ce12"><Data ss:Type="Number">194531.56</Data></Cell><Cell `,
  659. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  660. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  661. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  662. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell></Row><Row><Cell `,
  663. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  664. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  665. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-06-02</Data></Cell><Cell `,
  666. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  667. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  668. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  669. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  670. `ss:StyleID="ce10"><Data ss:Type="Number">364</Data></Cell><Cell `,
  671. `ss:StyleID="ce12"><Data ss:Type="Number">186893.18</Data></Cell><Cell `,
  672. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  673. `ss:StyleID="ce10"><Data ss:Type="Number">28</Data></Cell><Cell `,
  674. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  675. `ss:StyleID="ce10"><Data ss:Type="Number">19</Data></Cell></Row><Row><Cell `,
  676. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  677. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  678. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-06-30</Data></Cell><Cell `,
  679. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  680. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  681. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  682. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  683. `ss:StyleID="ce10"><Data ss:Type="Number">45</Data></Cell><Cell `,
  684. `ss:StyleID="ce12"><Data ss:Type="Number">24247.14</Data></Cell><Cell `,
  685. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  686. `ss:StyleID="ce10"><Data ss:Type="Number">4</Data></Cell><Cell `,
  687. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  688. `ss:StyleID="ce10"><Data ss:Type="Number">3</Data></Cell></Row><Row><Cell `,
  689. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  690. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  691. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-07-28</Data></Cell><Cell `,
  692. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  693. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  694. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  695. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  696. `ss:StyleID="ce10"><Data ss:Type="Number">38</Data></Cell><Cell `,
  697. `ss:StyleID="ce12"><Data ss:Type="Number">19696.32</Data></Cell><Cell `,
  698. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  699. `ss:StyleID="ce10"><Data ss:Type="Number">3</Data></Cell><Cell `,
  700. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  701. `ss:StyleID="ce10"><Data ss:Type="Number">2</Data></Cell></Row><Row><Cell `,
  702. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  703. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  704. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-08-25</Data></Cell><Cell `,
  705. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  706. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  707. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  708. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  709. `ss:StyleID="ce10"><Data ss:Type="Number">108</Data></Cell><Cell `,
  710. `ss:StyleID="ce12"><Data ss:Type="Number">55303.68</Data></Cell><Cell `,
  711. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  712. `ss:StyleID="ce10"><Data ss:Type="Number">8</Data></Cell><Cell `,
  713. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  714. `ss:StyleID="ce10"><Data ss:Type="Number">6</Data></Cell></Row><Row><Cell `,
  715. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  716. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  717. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-09-22</Data></Cell><Cell `,
  718. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  719. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  720. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  721. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  722. `ss:StyleID="ce10"><Data ss:Type="Number">82</Data></Cell><Cell `,
  723. `ss:StyleID="ce12"><Data ss:Type="Number">40010.15</Data></Cell><Cell `,
  724. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  725. `ss:StyleID="ce10"><Data ss:Type="Number">6</Data></Cell><Cell `,
  726. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  727. `ss:StyleID="ce10"><Data ss:Type="Number">3</Data></Cell></Row><Row><Cell `,
  728. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  729. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  730. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-10-20</Data></Cell><Cell `,
  731. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  732. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  733. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  734. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  735. `ss:StyleID="ce10"><Data ss:Type="Number">9</Data></Cell><Cell `,
  736. `ss:StyleID="ce12"><Data ss:Type="Number">5540.53</Data></Cell><Cell `,
  737. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  738. `ss:StyleID="ce10"><Data ss:Type="Number">1</Data></Cell><Cell `,
  739. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  740. `ss:StyleID="ce10"><Data ss:Type="Number">1</Data></Cell></Row><Row><Cell `,
  741. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  742. `ss:StyleID="ce1"><Data ss:Type="String">17</Data></Cell><Cell `,
  743. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-11-17</Data></Cell><Cell `,
  744. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  745. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  746. `ss:StyleID="ce1"><Data ss:Type="String">747-400</Data></Cell><Cell `,
  747. `ss:StyleID="ce10"><Data ss:Type="Number">385</Data></Cell><Cell `,
  748. `ss:StyleID="ce10"><Data ss:Type="Number">24</Data></Cell><Cell `,
  749. `ss:StyleID="ce12"><Data ss:Type="Number">12227.20</Data></Cell><Cell `,
  750. `ss:StyleID="ce10"><Data ss:Type="Number">31</Data></Cell><Cell `,
  751. `ss:StyleID="ce10"><Data ss:Type="Number">2</Data></Cell><Cell `,
  752. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  753. `ss:StyleID="ce10"><Data ss:Type="Number">1</Data></Cell></Row><Row><Cell `,
  754. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  755. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  756. `ss:StyleID="ce2"><Data ss:Type="DateTime">2009-11-20</Data></Cell><Cell `,
  757. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  758. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  759. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  760. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  761. `ss:StyleID="ce10"><Data ss:Type="Number">268</Data></Cell><Cell `,
  762. `ss:StyleID="ce12"><Data ss:Type="Number">132608.78</Data></Cell><Cell `,
  763. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  764. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  765. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  766. `ss:StyleID="ce10"><Data ss:Type="Number">9</Data></Cell></Row><Row><Cell `,
  767. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  768. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  769. `ss:StyleID="ce2"><Data ss:Type="DateTime">2009-12-18</Data></Cell><Cell `,
  770. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  771. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  772. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  773. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  774. `ss:StyleID="ce10"><Data ss:Type="Number">271</Data></Cell><Cell `,
  775. `ss:StyleID="ce12"><Data ss:Type="Number">133666.09</Data></Cell><Cell `,
  776. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  777. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  778. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  779. `ss:StyleID="ce10"><Data ss:Type="Number">9</Data></Cell></Row><Row><Cell `,
  780. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  781. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  782. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-01-15</Data></Cell><Cell `,
  783. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  784. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  785. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  786. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  787. `ss:StyleID="ce10"><Data ss:Type="Number">272</Data></Cell><Cell `,
  788. `ss:StyleID="ce12"><Data ss:Type="Number">133606.89</Data></Cell><Cell `,
  789. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  790. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  791. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  792. `ss:StyleID="ce10"><Data ss:Type="Number">8</Data></Cell></Row><Row><Cell `,
  793. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  794. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  795. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-02-12</Data></Cell><Cell `,
  796. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  797. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  798. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  799. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  800. `ss:StyleID="ce10"><Data ss:Type="Number">271</Data></Cell><Cell `,
  801. `ss:StyleID="ce12"><Data ss:Type="Number">132367.78</Data></Cell><Cell `,
  802. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  803. `ss:StyleID="ce10"><Data ss:Type="Number">20</Data></Cell><Cell `,
  804. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  805. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell></Row><Row><Cell `,
  806. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  807. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  808. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-03-12</Data></Cell><Cell `,
  809. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  810. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  811. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  812. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  813. `ss:StyleID="ce10"><Data ss:Type="Number">271</Data></Cell><Cell `,
  814. `ss:StyleID="ce12"><Data ss:Type="Number">134431.58</Data></Cell><Cell `,
  815. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  816. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  817. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  818. `ss:StyleID="ce10"><Data ss:Type="Number">9</Data></Cell></Row><Row><Cell `,
  819. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  820. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  821. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-04-09</Data></Cell><Cell `,
  822. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  823. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  824. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  825. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  826. `ss:StyleID="ce10"><Data ss:Type="Number">271</Data></Cell><Cell `,
  827. `ss:StyleID="ce12"><Data ss:Type="Number">133801.38</Data></Cell><Cell `,
  828. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  829. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  830. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  831. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell></Row><Row><Cell `,
  832. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  833. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  834. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-05-07</Data></Cell><Cell `,
  835. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  836. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  837. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  838. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  839. `ss:StyleID="ce10"><Data ss:Type="Number">271</Data></Cell><Cell `,
  840. `ss:StyleID="ce12"><Data ss:Type="Number">134994.15</Data></Cell><Cell `,
  841. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  842. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  843. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  844. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell></Row><Row><Cell `,
  845. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  846. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  847. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-06-04</Data></Cell><Cell `,
  848. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  849. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  850. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  851. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  852. `ss:StyleID="ce10"><Data ss:Type="Number">266</Data></Cell><Cell `,
  853. `ss:StyleID="ce12"><Data ss:Type="Number">133746.46</Data></Cell><Cell `,
  854. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  855. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  856. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  857. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell></Row><Row><Cell `,
  858. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  859. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  860. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-07-02</Data></Cell><Cell `,
  861. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  862. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  863. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  864. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  865. `ss:StyleID="ce10"><Data ss:Type="Number">108</Data></Cell><Cell `,
  866. `ss:StyleID="ce12"><Data ss:Type="Number">52622.26</Data></Cell><Cell `,
  867. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  868. `ss:StyleID="ce10"><Data ss:Type="Number">9</Data></Cell><Cell `,
  869. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  870. `ss:StyleID="ce10"><Data ss:Type="Number">3</Data></Cell></Row><Row><Cell `,
  871. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  872. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  873. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-07-30</Data></Cell><Cell `,
  874. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  875. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  876. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  877. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  878. `ss:StyleID="ce10"><Data ss:Type="Number">39</Data></Cell><Cell `,
  879. `ss:StyleID="ce12"><Data ss:Type="Number">17953.85</Data></Cell><Cell `,
  880. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  881. `ss:StyleID="ce10"><Data ss:Type="Number">2</Data></Cell><Cell `,
  882. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  883. `ss:StyleID="ce10"><Data ss:Type="Number">1</Data></Cell></Row><Row><Cell `,
  884. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  885. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  886. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-08-27</Data></Cell><Cell `,
  887. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  888. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  889. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  890. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  891. `ss:StyleID="ce10"><Data ss:Type="Number">108</Data></Cell><Cell `,
  892. `ss:StyleID="ce12"><Data ss:Type="Number">54064.47</Data></Cell><Cell `,
  893. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  894. `ss:StyleID="ce10"><Data ss:Type="Number">9</Data></Cell><Cell `,
  895. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  896. `ss:StyleID="ce10"><Data ss:Type="Number">4</Data></Cell></Row><Row><Cell `,
  897. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  898. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  899. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-09-24</Data></Cell><Cell `,
  900. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  901. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  902. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  903. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  904. `ss:StyleID="ce10"><Data ss:Type="Number">85</Data></Cell><Cell `,
  905. `ss:StyleID="ce12"><Data ss:Type="Number">41088.71</Data></Cell><Cell `,
  906. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  907. `ss:StyleID="ce10"><Data ss:Type="Number">6</Data></Cell><Cell `,
  908. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  909. `ss:StyleID="ce10"><Data ss:Type="Number">3</Data></Cell></Row><Row><Cell `,
  910. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  911. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  912. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-10-22</Data></Cell><Cell `,
  913. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  914. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  915. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  916. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  917. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  918. `ss:StyleID="ce12"><Data ss:Type="Number">11186.76</Data></Cell><Cell `,
  919. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  920. `ss:StyleID="ce10"><Data ss:Type="Number">2</Data></Cell><Cell `,
  921. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  922. `ss:StyleID="ce10"><Data ss:Type="Number">1</Data></Cell></Row><Row><Cell `,
  923. `ss:StyleID="ce1"><Data ss:Type="String">AA</Data></Cell><Cell `,
  924. `ss:StyleID="ce1"><Data ss:Type="String">64</Data></Cell><Cell `,
  925. `ss:StyleID="ce2"><Data ss:Type="DateTime">2010-11-19</Data></Cell><Cell `,
  926. `ss:StyleID="ce12"><Data ss:Type="Number">422.94</Data></Cell><Cell `,
  927. `ss:StyleID="ce1"><Data ss:Type="String">USD</Data></Cell><Cell `,
  928. `ss:StyleID="ce1"><Data ss:Type="String">A310-300</Data></Cell><Cell `,
  929. `ss:StyleID="ce10"><Data ss:Type="Number">280</Data></Cell><Cell `,
  930. `ss:StyleID="ce10"><Data ss:Type="Number">0</Data></Cell><Cell `,
  931. `ss:StyleID="ce12"><Data ss:Type="Number">0.00</Data></Cell><Cell `,
  932. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  933. `ss:StyleID="ce10"><Data ss:Type="Number">0</Data></Cell><Cell `,
  934. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  935. `ss:StyleID="ce10"><Data ss:Type="Number">0</Data></Cell></Row><Row><Cell `,
  936. `ss:StyleID="ce1"><Data ss:Type="String">AZ</Data></Cell><Cell `,
  937. `ss:StyleID="ce1"><Data ss:Type="String">555</Data></Cell><Cell `,
  938. `ss:StyleID="ce2"><Data ss:Type="DateTime">2009-11-18</Data></Cell><Cell `,
  939. `ss:StyleID="ce12"><Data ss:Type="Number">185.00</Data></Cell><Cell `,
  940. `ss:StyleID="ce1"><Data ss:Type="String">EUR</Data></Cell><Cell `,
  941. `ss:StyleID="ce1"><Data ss:Type="String">A319</Data></Cell><Cell `,
  942. `ss:StyleID="ce10"><Data ss:Type="Number">220</Data></Cell><Cell `,
  943. `ss:StyleID="ce10"><Data ss:Type="Number">205</Data></Cell><Cell `,
  944. `ss:StyleID="ce12"><Data ss:Type="Number">47321.15</Data></Cell><Cell `,
  945. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  946. `ss:StyleID="ce10"><Data ss:Type="Number">20</Data></Cell><Cell `,
  947. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  948. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell></Row><Row><Cell `,
  949. `ss:StyleID="ce1"><Data ss:Type="String">AZ</Data></Cell><Cell `,
  950. `ss:StyleID="ce1"><Data ss:Type="String">555</Data></Cell><Cell `,
  951. `ss:StyleID="ce2"><Data ss:Type="DateTime">2009-12-16</Data></Cell><Cell `,
  952. `ss:StyleID="ce12"><Data ss:Type="Number">185.00</Data></Cell><Cell `,
  953. `ss:StyleID="ce1"><Data ss:Type="String">EUR</Data></Cell><Cell `,
  954. `ss:StyleID="ce1"><Data ss:Type="String">A319</Data></Cell><Cell `,
  955. `ss:StyleID="ce10"><Data ss:Type="Number">220</Data></Cell><Cell `,
  956. `ss:StyleID="ce10"><Data ss:Type="Number">213</Data></Cell><Cell `,
  957. `ss:StyleID="ce12"><Data ss:Type="Number">48103.70</Data></Cell><Cell `,
  958. `ss:StyleID="ce10"><Data ss:Type="Number">22</Data></Cell><Cell `,
  959. `ss:StyleID="ce10"><Data ss:Type="Number">21</Data></Cell><Cell `,
  960. `ss:StyleID="ce10"><Data ss:Type="Number">10</Data></Cell><Cell `,
  961. `ss:StyleID="ce10"><Data `,
  962. `ss:Type="Number">9</Data></Cell></Row></Table><WorksheetOptions `,
  963. `xmlns="urn:schemas-microsoft-`,
  964. `com:office:excel"><Print><ValidPrinterInfo/><PaperSizeIndex>9</PaperSizeIndex><H`,
  965. `orizontalResolution>600</HorizontalResolution><VerticalResolution>0</VerticalRes`,
  966. `olution></Print><Selected/><Panes><Pane><Number>3</Number><ActiveRow>1</ActiveRo`,
  967. `w></Pane></Panes><ProtectObjects>False</ProtectObjects><ProtectScenarios>False</`,
  968. `ProtectScenarios></WorksheetOptions></Worksheet><Worksheet `,
  969. `ss:Name="Sheet2"><WorksheetOptions xmlns="urn:schemas-microsoft-`,
  970. `com:office:excel"><ProtectObjects>False</ProtectObjects><ProtectScenarios>False<`,
  971. `/ProtectScenarios></WorksheetOptions></Worksheet><Worksheet `,
  972. `ss:Name="Sheet3"><WorksheetOptions xmlns="urn:schemas-microsoft-`,
  973. `com:office:excel"><ProtectObjects>False</ProtectObjects><ProtectScenarios>False<`,
  974. `/ProtectScenarios></WorksheetOptions></Worksheet></Workbook>`.
  975.  
  976. endform.                    "get_xml_as_string
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!