$t[6] means the 7th item of the array @t. But you declared my @t=(',',$_); which only has 2 items ( $t[0] and $t[1] ). So when you try $t[6] eq "CA" then perl says it's uninitialized because that item does not exist in that list.

The code you posted makes no sense. Try to start from scratch and organize your thoughts, using pen and paper if necessary, before and while writing the code. You're making some progress. Keep trying, and organize your code:

    my $input   = "SRC185.xlsx";
    my $output  = "Output2022.xlsx";

    my $workbook  = Excel::Writer::XLSX->new( $output );   
    my $worksheet = $workbook->add_worksheet('List');
    my $rowCount  = 0;

    open(FH, "<", $input ) or die "Can't open $input: $!";

[download]

<P> tags added by GrandFather to improve readability

code tags on array elements added by Discipulus

In reply to Re: Parsing error by Anonymous Monk
in thread Parsing error by MoodyDreams999

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.