Hi, Please see the debug report below.
DB<1> x $cell 0 Spreadsheet::ParseExcel::Cell=HASH(0x8f6430c) 'Code' => undef 'Format' => Spreadsheet::ParseExcel::Format=HASH(0x8f0eb44) 'AlignH' => 0 'AlignV' => 2 'BdrColor' => ARRAY(0x8f0eb5c) 0 0 1 0 2 0 3 0 'BdrDiag' => ARRAY(0x8f0eb8c) 0 0 1 0 2 0 'BdrStyle' => ARRAY(0x8f0e268) 0 0 1 0 2 0 3 0 'Fill' => ARRAY(0x8f0ebc8) 0 1 1 42 2 64 'FmtIdx' => 43 'Font' => Spreadsheet::ParseExcel::Font=HASH(0x8c4e080) 'Attr' => 0 'Bold' => 0 'Color' => 32767 'Height' => 10 'Italic' => 0 'Name' => 'Arial' 'Strikeout' => 0 'Super' => 0 'Underline' => 0 'UnderlineStyle' => 0 'FontNo' => 0 'Hidden' => 0 'Indent' => 0 'JustLast' => 0 'Key123' => 0 'Lock' => 1 'Merge' => 0 'ReadDir' => 0 'Rotate' => 0 'Shrink' => 0 'Style' => 0 'Wrap' => 0 'FormatNo' => 29 'Type' => 'Numeric' 'Val' => '7.42648557919274e+275' '_Kind' => 'RK' '_Value' => ' 742,648,557,919,274,215,596,480,721,467,753,739,797, +881,839,158,032,045,444,744,972,281,248,374,846,048,088,725,564,424,7 +05,059,145,840,738,686,965,435,358,755,836,749,146,754,873,675,932,60 +0,092,125,946,893,868,194,138,671,244,971,437,781,478,579,517,410,099 +,590,090,026,114,048,017,693,855,644,672,962,827,489,552,711,307,891, +602,716,747,903,682,255,045,301,108,736.00 '
Thanks

In reply to Re^2: Error reading Excel Cell Value by sandeep78
in thread Error reading Excel Cell Value by sandeep78

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.