Re: Excel copy data from one cell to another cell

Replies are listed 'Best First'.
Re^2: Excel copy data from one cell to another cell by davies (Monsignor) on Jun 06, 2019 at 14:22 UTC
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	[reply]
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]