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

Writing data from excel to file

14 Views

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.

regards

Debansu