Hi Team,
I want to copy and paste specific excel column data to my database one by one. tried with csvread but not working as expected. is there any sample macro to refer or a link that shows the command to do it?
Hi Team,
I want to copy and paste specific excel column data to my database one by one. tried with csvread but not working as expected. is there any sample macro to refer or a link that shows the command to do it?
Can you provide a screen video of the task that you want automate? Then we can suggest a solution.
csvread working like a charm need only to study and use it
Copy and paste data from excel require desktop automation it’s hard job to do
please share me a link to refer, like a sample macro?
You must use desktop automatioin and emulate keyboard, i already created similar macro
This is an example of Excel automation
{
“Command”: “XType”,
“Target”: “${KEY_DEL}${KEY_DOWN}”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “pause”,
“Target”: “1000”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_CTRL+KEY_HOME}${KEY_RIGHT}${KEY_DOWN}”,
“Value”: “”,
“Description”: “”
},