i see you used the code tags but slightly incorrect, you are missing the frontslash in the end code tag -> '<'/code'>'

Update:

well it would help if i new something about data your structure. Personally i rarly use xml and xls, only when there is no other options (i like my data in csv, tsv...) but looking at your scripts all you should do is initialize writer then xls and in the part where it states 

my $source_cell = $source_sheet->{Cells}[$row_index][$col_index];
   if ($source_cell)
   {


    # here you add data from xls into xml (not just copy/past the line
+ like i did but you have to know the structure of your data thah you 
+wish to pass into xml)


    #$writer->startTag("PosMntReq", "ReqID" => "18AEXR" ,"TxnTyp" => "
+1","BizDt"=>"2003-12-04","SetSesID" => "EOD", "TxnTm" => "2003-09-10T
+00:00:00");
    #$storage_book->{$source_sheet->{Name}}->{$row_index}->{$col_index
+} = $source_cell->Value;
   } # end of source_cell check

[download]
just state that output of your xls should be input to xml. and that should be it . in the end you close your xml 
$writer->endTag("PosMntReq");
$writer->endTag("FIXML");
$writer->end();
$output->close();

[download]

In reply to Re: Reading data from excel and create xml file using data by baxy77bax
in thread Reading data from excel and create xml file using data by asha80

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.