Re^2: Excel copy data from one cell to another cell

[davies]

If the OP is using Win32::OLE, the thread Inserting copied rows at another position in Excel might help. Copying single cells isn't discussed, but lots of copying techniques are and might be helpful.

Regards,

John Davies

[Ratazong]

Example for copying a single cell with Win32::OLE

$Sheet->Range("B4")->{Value} = $Sheet->Range("A1")->{Value};

with $Sheet being an Excel-worksheet

HTH, Rata

[davies]

Yes, if the value is what is wanted. If it's the formula or (parts of) the format, the command will be different. For myself, I copy formulae far more often than values, but we don't know what the OP wants.

Regards,

John Davies

[PraveenKS]

John, thank you for your reply.. it's my mistake I haven't mentioned where I am working.. I am trying to generate the excle file from Linux OS machine.