Search Results

Anyone have anyother better solution to merge cells?

As of now the excel first column looks like this:
----------|
abs-pq |
----------|
----------|
----------|
abs-pqrst |
----------|
----------|
tbs-pqrst |
----------|
----------|

I...

I also want the empty cells to be merged with the respective string.

---------- Post updated at 09:57 PM ---------- Previous update was at 09:23 PM ----------

As of now it is removing...

INPUT:
abs-pq tfr23 12345
abs-pq tfr24 12843
abs-pq tfr24 12435
abs-pqrst tfr24 19923|23141
abs-pqrst rts10 23456
tbs-pqrst tfr25 21938|22143...

Below is the complete code which works great converting all csv files(sorted based on column1) in dest directory to a single xls with multiple tabs.

use warnings;
use Spreadsheet::WriteExcel;
my...

Perl script to merge cells

---------- Post updated at 12:59 AM ---------- Previous update was at 12:54 AM ----------

I am using below code to read files from a dir and print to excel.
...