Full text search

XLS to XML conversions: XML output file

Introduction: Excel to XML conversion

Sample

  <!DOCTYPE xls2xml SYSTEM "xls2xml.dtd" []>
  <xls2xml><title>Flour Power Bakery Timesheet</title>
  <ulist>
  <li>Name: Joe Doakes</li>
  <li>Date From: Monday</li>
  <li>Date To: Sunday</li>
  </ulist><table>
  <tr>
  <th>Project/Activity</th>
  <th>WBS #</th>
  <th>Mon</th>
  <th>Tue</th>
  <th>Wed</th>
  <th>Thurs</th>
  <th>Fri</th>
  <th>Sat</th>
  <th>Sun</th>
  <th>Total</th></tr>
  <tr>
  <td>Bagels</td>
  <td>100</td>
  <td>4</td>
  <td></td>
  <td>2</td>
  <td>4</td>
  <td>1</td>
  <td></td>
  <td></td>
  <td>11</td></tr>
  <tr>
  <td>Bread</td>
  <td>200</td>
  <td>2</td>
  <td>4</td>
  <td></td>
  <td></td>
  <td>1</td>
  <td></td>
  <td></td>
  <td>7</td></tr>
  <tr>
  <td>Donuts</td>
  <td>600</td>
  <td>2</td>
  <td>2</td>
  <td>2</td>
  <td></td>
  <td>1</td>
  <td></td>
  <td></td>
  <td>7</td></tr>
  <tr>
  <td>Hotdog buns</td>
  <td>900</td>
  <td></td>
  <td>2</td>
  <td>2</td>
  <td></td>
  <td>1</td>
  <td></td>
  <td></td>
  <td>5</td></tr>
  <tr>
  <td>Mille-feuille</td>
  <td>1000</td>
  <td></td>
  <td>invalid</td>
  <td>2</td>
  <td></td>
  <td>1</td>
  <td></td>
  <td></td>
  <td>3</td></tr>
  <tr>
  <td>Vacation</td>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  <td>4</td>
  <td></td>
  <td></td>
  <td></td>
  <td>4</td></tr>
  <tr>
  <td>Sick Leave</td>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  <td>3</td>
  <td></td>
  <td></td>
  <td>3</td></tr>
  <tr>
  <td>Total</td>
  <td></td>
  <td>8</td>
  <td>8</td>
  <td>8</td>
  <td>8</td>
  <td>8</td>
  <td></td>
  <td></td>
  <td>40</td></tr>
  </table>
  <p>*Note: WBS# is for project work only and includes:</p><dl>
  <dt>100</dt>
  <dd>Bagels</dd>
  <dt>600</dt>
  <dd>Danish</dd>
  <dt>200</dt>
  <dd>Bread</dd>
  <dd>Donuts</dd>
  <dt>300</dt>
  <dt>800</dt>
  <dd>Hamburger buns</dd>
  <dt>400</dt>
  <dd>Cupcakes</dd>
  <dt>900</dt>
  <dd>Hotdog buns</dd>
  <dt>500</dt>
  <dd>Cookies</dd>
  <dt>1000</dt>
  <dd>Mille-feuille</dd>
  </dl></xls2xml>