Re: how to remove blank cell with perl

Did you want to delete a cell or a row?

You said: $Sheet->Cells($row,$col)->EntireRow->Delete; Also, note that you do not correct for the movement of the remaining cells... your rows and/or columns will be different after removing some cells, and that misalignment will cause trouble as well.

Please provide a better description of what you want to happen, and what is happening. Examples are good!

Comment on Re: how to remove blank cell with perl Download Code

Replies are listed 'Best First'.
Re^2: how to remove blank cell with perl by meghavarshney (Novice) on Aug 03, 2011 at 17:09 UTC
i want to delete that every row which contain a single blank cell. i want that my prog chk every line or single cell ,if its contain any blank cell then it has to delete that entire row. but whenver m trying to that it's not working properly.... example : let's suppose this is my data 0.344828497 0.344828497 0.650764559 1.09085343 0.124328135 0.98550043 0.310340121 0.757023247 1.15704371 0.214124805 0.613531653 0.90303827 0.250961574 0.214124805 0.613531653 0.454175893 0.028569152 0.50589093 0.056583528 i want... 0.650764559 1.09085343 0.124328135 0.98550043 0.310340121 0.757023247 1.15704371 0.214124805 0.613531653 0.90303827 0.250961574 0.214124805 but the o/p was somehowe like in this formate 0.344828497 0.344828497 0.650764559 1.09085343 0.124328135 0.98550043 0.613531653 0.90303827 0.250961574 0.214124805 0.613531653 0.454175893 0.028569152 [download]	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: how to remove blank cell with perl
by meghavarshney (Novice) on Aug 03, 2011 at 17:09 UTC

i want to delete that every row which contain a single blank cell. i want that my prog chk every line or single cell ,if its contain any blank cell then it has to delete that entire row. but whenver m trying to that it's not working properly.... example :

 
let's suppose this is my data
0.344828497            0.344828497
0.650764559    1.09085343    0.124328135    0.98550043

0.310340121    0.757023247    1.15704371    0.214124805

0.613531653    0.90303827    0.250961574    0.214124805

            0.613531653     0.454175893      0.028569152

            0.50589093                0.056583528

i want...
0.650764559    1.09085343    0.124328135    0.98550043

0.310340121    0.757023247    1.15704371    0.214124805

0.613531653    0.90303827    0.250961574    0.214124805

but the o/p was somehowe like in this formate

0.344828497            0.344828497

0.650764559    1.09085343    0.124328135    0.98550043

0.613531653    0.90303827    0.250961574    0.214124805

            0.613531653     0.454175893      0.028569152
[download]

[reply]
[d/l]