In Re: Delete Row in Excel, I described a common mistake in deleting rows. I've made it frequently myself. But I've also shown in that post how to set up Excel so that your would-be helpers can tell what your problem is. If the node I have linked to doesn't solve your problem, please post code that actually shows the problem. I had a colleague who frequently came to me with the problem "it doesn't work". My invariable reply was "is your computer switched on?", which eventually convinced him that helpers have to start somewhere, and the chosen starting point may not be very near the actual problem. But don't DREAM of posting 3226 rows of data! Cut it down to the minimum that will show the problem and I would bet that you will get it solved quite quickly.
A few comments on the code you have posted: first, you specify Spreadsheet::WriteExcel without ever using it. I don't know it myself, as all machines I use have Excel and controlling Excel directly gives far greater power, which I usually need. Second, the with construct is safe in VBA and Perl, but it is buggy (and documented as such) in VB6, so it is something I avoid in any language except VBA, and frequently even then. Third, you define and increment $count but never use it. Fourth, your indentation has (let's be charitable) got scrambled in transit from the source to here, and is confusing to the reader as a result
Regards,
John Davies
Update: fixed minor typo
In reply to Re: how to remove blank cell with perl
by davies
in thread how to remove blank cell with perl
by meghavarshney
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |