Hi All,
Let me explain you clearly what i need first. i have a excel in which three columns are there Firt columns consists of First name, Second column consists of Last name and thrid columns consists of Email IDs of the persons. Now i have a Web browser which has these fields First name, last name and Email IDs text bobx along with a submit and reset button at the end. All i have to do is copy paste each data from excel and paste it in the respectively fields in the web browser and submit it when i submit i get a pop stating succesfully completed where again i have to give a enter. So i have to give a double enter after pasting the data into the web browser. i tried doing in marco's but could not find a solutions for it. Can anyone help me in doing this.
ashwin
Ashwin,
Use the below javascript code for copyig excel clipboard data to webbrowser.
- First copy some data from excl in clipboard.
- onbuttonclick even of html page call below javascript.
function pasteGrid()
{
var chkTable = window.clipboardData.getData("Text");
if(chkTable != null)
{
alert(chkTable);
}
once you get alert, you can split data by using below coomand
var data = window.clipboardData.getData("Text").split("\n");
....
I hope it will help you.
- Santosh
mansukh_santosh@yahoo.com
I am looking at the code above and wondering what the 'data' variable has in it? Can I loop through it in two dimensions to populate a table? Would very much appreciate some help on this next step!
Thanks,
Rich
I need one help in a form i am having the following fields
Name
Surname
Email
Address
Mobile no
IN the form i am having another button called upload
if i click upload it must open an excel sheet in the excel sheet having column names as name, surname, email, address, mobile no along with values
After clicking upload it must pull data from excel and load in the text box of the form..
Can any post your ideas regarding this???
Regards
Sabari
Hi All,
Let me explain you clearly what i need first. i have a excel in which one column are there column consists of URL . That consist paste into a website than that website creat into the one URL. Than that URL do the copy and paste into the excel sheet. I have lot of URL's. It will do the manually take the lot of days any easy method for automatically do that work. Please help me.
Regards
Sri
Pages
Add new comment