Excel copy data from one cell to another cell

PraveenKS has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Excel copy data from one cell to another cell by holli (Abbot) on Jun 06, 2019 at 14:09 UTC
Use Spreadsheet::ParseExcel. holli You can lead your users to water, but alas, you cannot drown them.	[reply] [d/l]
Re: Excel copy data from one cell to another cell by poj (Abbot) on Jun 06, 2019 at 14:09 UTC
Use Win32::OLE , see Using Win32::OLE and Excel - Tips and Tricks. poj	[reply]
Re^2: Excel copy data from one cell to another cell by davies (Prior) 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 (Prior) on Jun 07, 2019 at 07:30 UTC
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]


Come for the quick hacks, stay for the epiphanies.
	PerlMonks