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

in reply to Re: Excel copy data from one cell to another cell
in thread Excel copy data from one cell to another cell

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

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

Replies are listed 'Best First'.
Re^3: Excel copy data from one cell to another cell by Ratazong (Monsignor) on Jun 07, 2019 at 06:48 UTC
Example for copying a single cell with Win32::OLE `$Sheet->Range("B4")->{Value} = $Sheet->Range("A1")->{Value};` [download] with $Sheet being an Excel-worksheet HTH, Rata	[reply] [d/l]
Re^4: Excel copy data from one cell to another cell by davies (Monsignor) on Jun 07, 2019 at 07:30 UTC
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	[reply]
Re^3: Excel copy data from one cell to another cell by PraveenKS (Initiate) on Jun 07, 2019 at 06:44 UTC
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.	[reply]

In Section Seekers of Perl Wisdom