title: Decode XML Spreadsheet content of a clipBoard generated by Excel
body: <p>I want to do a very simple thing in my program : </p>
  
  <p>When a user do a copy of a selection in Excel (2007 - 2016), I want to be able to read the clipboard content, then extract all the values.</p>
  
  <p>Currently Excel puts into the clipboard lots a different formats like Biff5, Biff8, CSV, plain/text etc.</p>
  
  <p>One simple solution could be to use the CSV format but that's not precise enough because if I tumble on a number, I wouldn't know if it was a String or a number in the excel file. Also the dates are sent in their original format and it will be a pain to understand it.</p>
  
  <p>So the solution I see is to parse the "XML Spreadsheet" sent by Excel which looks like that : </p>
  
  <pre><code> &lt;?xml version="1.0"?&gt;
  &lt;?mso-application progid="Excel.Sheet"?&gt;
  &lt;Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
   xmlns:o="urn:schemas-microsoft-com:office:office"
   xmlns:x="urn:schemas-microsoft-com:office:excel"
   xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
   xmlns:html="http://www.w3.org/TR/REC-html40"&gt;
   &lt;Styles&gt;
    &lt;Style ss:ID="Default" ss:Name="Normal"&gt;
     &lt;Alignment ss:Vertical="Bottom"/&gt;
     &lt;Borders/&gt;
     &lt;Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/&gt;
     &lt;Interior/&gt;
     &lt;NumberFormat/&gt;
     &lt;Protection/&gt;
    &lt;/Style&gt;
   &lt;/Styles&gt;
   &lt;Worksheet ss:Name="Feuil1"&gt;
    &lt;Table ss:ExpandedColumnCount="1" ss:ExpandedRowCount="3"
     ss:DefaultColumnWidth="60" ss:DefaultRowHeight="15"&gt;
     &lt;Row&gt;
      &lt;Cell&gt;&lt;Data ss:Type="Number"&gt;8&lt;/Data&gt;&lt;/Cell&gt;
     &lt;/Row&gt;
     &lt;Row&gt;
      &lt;Cell&gt;&lt;Data ss:Type="Number"&gt;9&lt;/Data&gt;&lt;/Cell&gt;
     &lt;/Row&gt;
     &lt;Row&gt;
      &lt;Cell ss:Formula="=SUM(R[-2]C:R[-1]C)"&gt;&lt;Data ss:Type="Number"&gt;17&lt;/Data&gt;&lt;/Cell&gt;
     &lt;/Row&gt;
    &lt;/Table&gt;
   &lt;/Worksheet&gt;
  &lt;/Workbook&gt;
  </code></pre>
  
  <p>Before you ask, I've considered POI. But as far as I understood I need to use XSSF. But to use that I need poi-ooxml, and to use that I need poi-ooxml-schemas and poi. I don't know the total weight of these JARs but I'm not keen on the fact to add 10Mb of jars just to extract an information from a clipBoard.</p>
  
  <p>Has anyone ever tried to do that? Is there a project that could do that?</p>