in reply to After parsing .xls the rows getting emerged

Are you confident in the number of columns in your @array and @row? select * is a potential problem if fields are ever added, renamed or removed.

Dum Spiro Spero
  • Comment on Re: After parsing .xls the rows getting emerged

Replies are listed 'Best First'.
Re^2: After parsing .xls the rows getting emerged
by ravi45722 (Pilgrim) on Oct 08, 2015 at 13:34 UTC

    Thanks for reply. I know my array & row exactly. Depend on the DB I created the template. After seeing your reply I rechecked it. But I think if I have more columns in DB it will not effect the top rows. Its just go continuously. But in the .xls the headers (Merged cells) are presented in 0th row. I started writing from 2nd row. I am not making any changes for the above rows.

[reply]

In Section Seekers of Perl Wisdom