Skip to Content
Former Member
Aug 22, 2008 at 05:10 AM

Writing data from excel to file


Hi friends,

Hope you all are doing well.I have to write data from an excel to file.Let us consider that the excel has 2 columns L1 and L2.There are 3 rows R1,R2 and R3. The cells are R1L1, R1L2,R2L1 and so on.

Suppose the data in R1L1 and R2L1 are the same.So these two cells are merged into a cell say R1R2L1.

When the data is to be written to a file,it has to be done as follows:

Data for row R1 -> R1R2L1 R1L2

Data for row R2 -> R1R2L1 R2L2

Data for row R3 -> R3L1 R3L2

Please suggest how I can achieve the above objective.