I have a excel sheet something in this form 
name | group | dir |descrption|
1 |cfg_attribute_id|IN|16|mib_cfg_if||clk_cfg|
2 |cfg_selector_idx|IN|4|mib_cfg_if|

[download]
as headers & text under each of these I need to store in 
$parameters{group[0]}{name}
$parameters{group[0]}{dir}
.
.

[download]

here %parameters is hash & i am using tie::autotie to create a structure So I am storing group as array as the text in the group changes script should be able to store in new array each group has parameters like name ,dir etc which are the columns of excel ,i want to use use Spreadsheet::ParseExcel;

But I am not able to complete the script , i tried with csv but as i converted to csv few places CR was hit so wanted to do with excel

csv would look something like this 


No.,Name,DIR,WIDTH,Group,Description,clock,QUANTITY
1,cfg_attribute_id,IN,16,mib_cfg_if,,clk_cfg,
2,cfg_selector_idx,IN,4,mib_cfg_if,"

[download]

Can some one please suggest me the code ASAP?

In reply to How to parse excel to hash by nm_pavan

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.