How can I open it xls files which include HTML code on open office

Question

0.00/5 (No votes)

See more:

Hello everyone,

I have xls file which is created html codes.i want to open it open office calc when i try to run it open office calc i see only html codes but i want to see the table which are created html codes.

How can i see the tables on open office calc or some other program which is not excel.

When i open the xls files on note pad i see:

          <?xml version="1.0" encoding="UTF-8"?>
        <!DOCTYPE html
            PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
           "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
        <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
           <head>
               <title>Minimal XHTML 1.0 Document with W3C DTD</title>
           </head>
         <body>
               <style> br {mso-data-placement:same-cell;} </style>
                       <table border="1px"; style="width:1000px;">
                           <thead>
                               <tr>
        <td> Depo Adı </td>
<td>TKM Acil Astore İlaç</td>
<td colspan="7" rowspan="3"></td>
        </tr>
        <tr>
        <td> Depo Kodu</td>
       <td>1837</td>
       </tr>
        <tr>
        <th>
        Tarih
        </th>
        <td>25/04/2018</td>
        </tr>
        <tr>
        <th style="width:73px;text-wrap:avoid">Urun Kodu</th>
         <th style="width:215px;text-wrap:avoid">Urun Adi</th>
          <th style="width:47px;text-wrap:avoid">Dolum Miktari</th>
          <th style="width:58px;text-wrap:avoid">Max Tamamlama</th>
          <th style="width:31px;text-wrap:avoid">Min</th>
          <th style="width:31px;text-wrap:avoid">Max</th>
           <th style="width:45px;text-wrap:avoid">Stok Miktari</th>
           <th style="width:48px;text-wrap:avoid">Order Miktari</th>
           <th style="width:29px;text-wrap:avoid">Tip</th>
       </tr>
</thead>
<tbody>

        <tr>
           <td>61461795</td>
       <td>Adrenalin 0,5 mg/ml 10 Ampul (Osel)</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>4</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010109</td>
       <td>Anestol %5 30 g Pomad</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>5</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61463534</td>
       <td>Anti-Nausea 10 mg/2 ml IM/IV Enj. Coz. Iceren 5 Ampul</td>
        <td>5</td>
        <td>5</td>
       <td>15</td>
       <td>30</td>
       <td>25</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61460584</td>
       <td>Aqua-Carbo (Aktif Karbon) 50 g/240 ml</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010134</td>
       <td>Aritmal %2 100 mg 5 ml 5 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>4</td>
       <td>8</td>
       <td>7</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010148</td>
       <td>Atropin 0,25 mg/ml 10 Ampul (Galen)</td>
        <td>1</td>
        <td>1</td>
       <td>3</td>
       <td>5</td>
       <td>4</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61456479</td>
       <td>Atropin 0,5 mg/ml 10 Ampul (Galen)</td>
        <td>1</td>
        <td>1</td>
       <td>3</td>
       <td>5</td>
       <td>4</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61456315</td>
       <td>Atropin 1 mg/ml 10 Ampul (Galen)</td>
        <td>2</td>
        <td>2</td>
       <td>3</td>
       <td>5</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>60008601</td>
       <td>Beloc Zok 25 mg 20 Kont.Sal.Film Tableti</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010193</td>
       <td>Beloc 5 mg/5 ml Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>2</td>
       <td>4</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010195</td>
       <td>Bemiks 5 Ampul</td>
        <td>11</td>
        <td>11</td>
       <td>10</td>
       <td>25</td>
       <td>14</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61494948</td>
       <td>Calcium Picken 2 Ampul / 30 ml Izotonik NaCI PVC</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61462354</td>
       <td>Cefaks IV/IM 750 mg 1 Flakon</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>4</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010700</td>
       <td>Combivent Tek Doz 20 Flakon (Nebul)</td>
        <td>4</td>
        <td>4</td>
       <td>5</td>
       <td>10</td>
       <td>6</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010325</td>
       <td>Contramal 100 mg 5 Ampul</td>
        <td>3</td>
        <td>3</td>
       <td>5</td>
       <td>10</td>
       <td>7</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010329</td>
       <td>Cordarone 150 mg 6 Ampul</td>
        <td>3</td>
        <td>3</td>
       <td>3</td>
       <td>6</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61457486</td>
       <td>Demizolam 5 mg/5 ml 5 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>2</td>
       <td>3</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010360</td>
       <td>Depomedrol 40 mg/ml Flakon</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010379</td>
       <td>Diazem 10 mg/2 ml 10 Ampul</td>
        <td>6</td>
        <td>6</td>
       <td>5</td>
       <td>10</td>
       <td>4</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010393</td>
       <td>Dikloron 75 mg IM 10 Ampul</td>
        <td>15</td>
        <td>15</td>
       <td>10</td>
       <td>25</td>
       <td>10</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010399</td>
       <td>Diltizem 30 mg 48 Tablet</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010410</td>
       <td>Dispril 300 mg 24 Tablet</td>
        <td>1</td>
        <td>1</td>
       <td>3</td>
       <td>5</td>
       <td>4</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>50011812</td>
       <td>Dolven 100 mg/5 ml 100 ml Ped. Surup</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>4</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010677</td>
       <td>Efedrin 50 mg/ml 100 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61478711</td>
       <td>Elektra 25 mg 20 Film Tablet</td>
        <td>1</td>
        <td>1</td>
       <td>2</td>
       <td>4</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010464</td>
       <td>Emla %5 Krem (5 g 5 Adet)</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61470888</td>
       <td>Enfluvir 75 mg 10 Kapsul</td>
        <td>1</td>
        <td>1</td>
       <td>3</td>
       <td>5</td>
       <td>4</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61492446</td>
       <td>E.S. Enema Tibbi Laksatif 135 ml Lavman</td>
        <td>1</td>
        <td>1</td>
       <td>2</td>
       <td>4</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61462950</td>
       <td>Ferroven 100 mg/5 ml IV 5 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>2</td>
       <td>4</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61477678</td>
       <td>Flotic 400 mg/200 ml IV Inf. Coz. Iceren Flakon</td>
        <td>2</td>
        <td>2</td>
       <td>1</td>
       <td>4</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61480587</td>
       <td>Furoson 20mg/2ml IM/IV 5 Ampul</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>6</td>
       <td>4</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020079</td>
       <td>Gaviscon 200 ml Likit</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61463234</td>
       <td>Iesef IV 1 g 1 Flakon</td>
        <td>11</td>
        <td>11</td>
       <td>15</td>
       <td>30</td>
       <td>19</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020180</td>
       <td>Isolyte S Ph 7.4 Pvc 1000 ml (Setsiz)</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020176</td>
       <td>Isolyte 1000 ml Pvc (Setsiz)</td>
        <td>2</td>
        <td>2</td>
       <td>7</td>
       <td>15</td>
       <td>13</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020177</td>
       <td>Isolyte 500 ml Pvc (Setsiz)</td>
        <td>6</td>
        <td>6</td>
       <td>10</td>
       <td>20</td>
       <td>14</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030565</td>
       <td>Izodeks 1/3 Pvc 500 ml (Setsiz)</td>
        <td>1</td>
        <td>1</td>
       <td>2</td>
       <td>3</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020568</td>
       <td>Izotonik Nacl Irigas 500 ml</td>
        <td>1</td>
        <td>1</td>
       <td>2</td>
       <td>4</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020190</td>
       <td>Izotonik Nacl Pvc 100 ml (Setsiz)</td>
        <td>5</td>
        <td>5</td>
       <td>20</td>
       <td>40</td>
       <td>35</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020192</td>
       <td>Izotonik Nacl Pvc 1000 ml (Setsiz)</td>
        <td>7</td>
        <td>7</td>
       <td>8</td>
       <td>16</td>
       <td>9</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020197</td>
       <td>Izotonik Nacl Pvc 250 ml (Setsiz)</td>
        <td>8</td>
        <td>8</td>
       <td>10</td>
       <td>30</td>
       <td>22</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>50022115</td>
       <td>Izotonik Nacl Pvc 50 ml (Setsiz)</td>
        <td>5</td>
        <td>5</td>
       <td>5</td>
       <td>10</td>
       <td>5</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020194</td>
       <td>Izotonik Nacl Pvc 500 ml (Setsiz)</td>
        <td>6</td>
        <td>6</td>
       <td>12</td>
       <td>25</td>
       <td>19</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>50000624</td>
       <td>Kapril 25 mg 48 Tablet</td>
        <td>1</td>
        <td>1</td>
       <td>5</td>
       <td>10</td>
       <td>9</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020576</td>
       <td>Laktatli Ringer Pvc 1000 ml (Setsiz)</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020575</td>
       <td>Laktatli Ringer Pvc 500 ml (Setsiz)</td>
        <td>1</td>
        <td>1</td>
       <td>4</td>
       <td>6</td>
       <td>5</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61470991</td>
       <td>Lefox 500 mg/100 ml IV Inf. Cozelti Icin Flakon</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020522</td>
       <td>Mannitol %20 Pvc 100 ml (Setsiz)</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020329</td>
       <td>Marcaine 100 mg/20 ml 1 Flakon</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61462196</td>
       <td>Metrosel %0,5 100 ml Pvc (Osel)</td>
        <td>1</td>
        <td>1</td>
       <td>3</td>
       <td>6</td>
       <td>5</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020358</td>
       <td>Metsil Fort 80 mg 50 Tablet</td>
        <td>1</td>
        <td>1</td>
       <td>2</td>
       <td>4</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010667</td>
       <td>Muscoril 4 mg/2 ml 6 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>5</td>
       <td>10</td>
       <td>9</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61455800</td>
       <td>Neostigmine 6 Ampul</td>
        <td>2</td>
        <td>2</td>
       <td>3</td>
       <td>5</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020422</td>
       <td>Nevparin 25.000 milyon uluslararasi unite/5 ml 1 Flakon</td>
        <td>1</td>
        <td>1</td>
       <td>3</td>
       <td>6</td>
       <td>5</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>50000579</td>
       <td>Nimotop 10 mg/50 ml 1 Flakon</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>4</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020438</td>
       <td>Nootropil 1 g 12 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>4</td>
       <td>8</td>
       <td>7</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020447</td>
       <td>Norodol 5 mg/ml 5 Ampul</td>
        <td>4</td>
        <td>4</td>
       <td>5</td>
       <td>10</td>
       <td>6</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13020469</td>
       <td>Oksamen-L 20 mg 1 Flakon</td>
        <td>2</td>
        <td>2</td>
       <td>10</td>
       <td>20</td>
       <td>18</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61477641</td>
       <td>Oksapar 6000 Anti-Xa uluslararasi unite/0,6 ml 2 Kull. Hazir Enjektor</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>4</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61478474</td>
       <td>Ondaren 4 mg/2 ml IV Enjeksiyonluk Cozelti Iceren Ampul</td>
        <td>2</td>
        <td>2</td>
       <td>8</td>
       <td>15</td>
       <td>13</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61478475</td>
       <td>Ondaren 8mg/4ml IV Enjeksiyonluk Cozelti Iceren 1 Ampul</td>
        <td>4</td>
        <td>4</td>
       <td>10</td>
       <td>20</td>
       <td>16</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61495136</td>
       <td>Onpyron 1000 mg/2 ml IM/IV Enjeksiyon Icin Cozelti Iceren 10 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>10</td>
       <td>25</td>
       <td>24</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61464054</td>
       <td>Onzyd 8 mg Agizda Dagilan 10 Tablet</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>4</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61514482</td>
       <td>Pandev 40 mg IV Enjeksiyonluk Liyofilize Toz Iceren 1 Flakon</td>
        <td>7</td>
        <td>7</td>
       <td>15</td>
       <td>25</td>
       <td>18</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>60008736</td>
       <td>Pantenol %5 30 g Pomad</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030013</td>
       <td>Paranox S 120 mg 10 Suppozituar</td>
        <td>2</td>
        <td>2</td>
       <td>1</td>
       <td>3</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61469411</td>
       <td>Parol 10 mg/ml IV 100 ml 12 Infuzyon Solusyonu</td>
        <td>16</td>
        <td>16</td>
       <td>15</td>
       <td>30</td>
       <td>14</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030048</td>
       <td>Perlinganit 10 mg/10 ml 10 Ampul</td>
        <td>4</td>
        <td>4</td>
       <td>5</td>
       <td>10</td>
       <td>6</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61460022</td>
       <td>Pol. Izolen-P %5 Dekstrozlu 500 ml PP Solusyon</td>
        <td>1</td>
        <td>1</td>
       <td>3</td>
       <td>5</td>
       <td>4</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61476832</td>
       <td>Precort-Liyo 250 mg IM/IV Liyofilize Toz Iceren 1 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>3</td>
       <td>6</td>
       <td>5</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61471150</td>
       <td>Precort-Liyo 40 mg IM/IV Liyofilize Toz Iceren 1 Ampul</td>
        <td>5</td>
        <td>5</td>
       <td>5</td>
       <td>10</td>
       <td>5</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61467268</td>
       <td>Progestan 50 mg/ml IM Enj. Coz. Iceren 5 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030562</td>
       <td>Pulmicort 0,25 mg/ml (2 ml) Nebulizer Sus. 20 Ampul</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>5</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61464447</td>
       <td>Raniver 50 mg/2 ml 10 Ampul</td>
        <td>23</td>
        <td>23</td>
       <td>15</td>
       <td>40</td>
       <td>17</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030145</td>
       <td>Rifocin 250 mg/3 ml 1 Ampul</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61517288</td>
       <td>Selovita-C 500mg/5ml IM/IV/SC Enjeksiyonluk Cozelti Iceren 5 Ampul</td>
        <td>4</td>
        <td>4</td>
       <td>10</td>
       <td>20</td>
       <td>16</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61464846</td>
       <td>Sulcid IM 500 mg 1 Flakon</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>61455588</td>
       <td>Sulcid IV 1 g 1 Flakon</td>
        <td>5</td>
        <td>5</td>
       <td>5</td>
       <td>10</td>
       <td>5</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030330</td>
       <td>Teobag 200 100 ml (Setsiz)</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030387</td>
       <td>Transamine %5 250 mg/5 ml 10 Ampul</td>
        <td>2</td>
        <td>2</td>
       <td>3</td>
       <td>5</td>
       <td>3</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030411</td>
       <td>Tylol Ped. 120 mg/5 ml 100 ml Suspansiyon</td>
        <td>1</td>
        <td>1</td>
       <td>1</td>
       <td>2</td>
       <td>1</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030461</td>
       <td>Ventolin Nebules 2,5 mg/2,5 ml 20 Doz</td>
        <td>3</td>
        <td>3</td>
       <td>8</td>
       <td>15</td>
       <td>12</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13030494</td>
       <td>Xanax 0,5 mg 30 Tablet</td>
        <td>1</td>
        <td>1</td>
       <td>5</td>
       <td>10</td>
       <td>9</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>50024194</td>
       <td>Zofran Zydis 4 mg Dilustu 10 Tablet</td>
        <td>2</td>
        <td>2</td>
       <td>2</td>
       <td>4</td>
       <td>2</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010011</td>
       <td>%5 Dekstroz Pvc 100 ml (Setsiz)</td>
        <td>1</td>
        <td>1</td>
       <td>2</td>
       <td>5</td>
       <td>4</td>
      <td></td>
      <td>D</td>
      </tr>
        <tr>
           <td>13010015</td>
       <td>%5 Dekstroz Pvc 500 ml (Setsiz)</td>
        <td>3</td>
        <td>3</td>
       <td>5</td>
       <td>10</td>
       <td>7</td>
      <td></td>
      <td>D</td>
      </tr></tbody>
   </table>
   </body>
   </html>

Thanks

What I have tried:

change file type with ods but it does not work

Posted 24-Apr-18 21:38pm

Member 10525430

Updated 24-Apr-18 23:25pm

Add a Solution

Comments

[no name] 25-Apr-18 3:54am

Is this a programming question or are you just trying to open a single xls file in open office?
If so, open it in excel and then in the "Save as" dialog, select .ODS, then open that in open office.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Answer 1 · 2018-04-24T23:26:00

That is not an XLS file but an HTML file. Such are generated by some applications and web pages using the incorrect file extension. While Excel will import them properly, OpenOffice and LibreOffice Calc will not.

If you use LibreOffice see Inserting External Data in Table (WebQuery) - LibreOffice Help[^] for a solution (I don't know if that works for OpenOffice too).

Another solution is opening the document in Writer, selecting the table (the text enclosed by the table tags including the tags), copy the selection to the clipboard, and paste into an empty Calc document. Use Edit - Paste Special to get additional options for pasting HTML.