title: perl to convert xls to xml
body: <p>I do have this script that convert xls to xml, my excel file has to or three columns, the xmls format should be like this <code>&lt;testcase name="Test1"&gt; but it prints &lt;testcase name&gt;test-1&lt;/testcase name&gt;</code></p>
  
  <p>per script is like this:</p>
  
  <pre><code> my $file = 'myfile.xls';
   my @columns = ('testcase name', 'summary', 'preconditions');
   my $xls = XML::Excel-&gt;new({column_headings =&gt; \@columns});
   print $file;
  
   $xls-&gt;parse_doc($file);
   $xls-&gt;declare_xml({version =&gt; '1.0',
   encoding =&gt; 'UTF-8', standalone =&gt; 'yes'});
   $xls-&gt;print_xml('test.xml',
                      {
                      file_tag    =&gt; 'testcases',
                      parent_tag  =&gt; "testcase"
                      }
              );
  </code></pre>
  
  <p>thanks in advance..</p>