Unmerge Merged cells in Spreadsheet

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Dear Monks, Is there any way by which we can get the mergedArea/range in a spreadsheet. I want to convert the XLS file to CSV by repeating the value of the cells which are merged. I.e.My spreadsheet may look like below A B c ABC 123 424 445 345 PQR 678 XYZ 789 513 here I want to duplicate the value ABC in cells A2, A3 (Considering A1, A2 and A3 cells are merged)and similary repeat valyes 445 in C2 and so on. Is there any way to achieve the same? Thanks, Mansi

Comment on Unmerge Merged cells in Spreadsheet

Replies are listed 'Best First'.
Re: Unmerge Merged cells in Spreadsheet by Anonymous Monk on Sep 26, 2014 at 07:36 UTC
Why can't you export to CSV from your spreadsheet program?	[reply]
Re^2: Unmerge Merged cells in Spreadsheet by Anonymous Monk on Sep 26, 2014 at 09:04 UTC
I cannot do it directly from Spreadsheet, because there are steps involved in a certain application, where it first does some validation then converts the file to CSV and then does the comparison of CSV files and find out the difference. Entire logic is written in perl. I am stuck with the stage where the cells in spreadsheet are merged horizontally as well as vertically.	[reply]