Skipping blank cells in excel

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • einstein
    New Member
    • Apr 2014
    • 4

    Skipping blank cells in excel

    my $data = $cell->value();

    This is how I parse in perl and then get the cell value. if the cell value is a blank , I want to skip that cell and move further. but its not excuting once it finds a blank cell.

    please help
  • miller
    Recognized Expert Top Contributor
    • Oct 2006
    • 1086

    #2
    I suspect that you're using this code in a loop.

    If that's the case then the function you need is next. It's up to you to determine the logic you need to test if a cell is blank.

    - Miller

    Comment

    Working...