Auto fill a third party web site with the data from excel /CSV

Question

0.00/5 (No votes)

See more:

Guys

I have a requirement.

We have to fill a web site (Eg Name,Address,age one at a time) from an excel data source where the name,address,age of about 100 students are listed. Currently we are doing this one by one like looking at the first student in the excel sheet and fill in the web site then click on the save button and then go on to the next row in the excel sheet.

This is very time consuming and has became an issue where we have to do some thing to automate. I have looked online (google) for any tip without much luck and will be great, if some one could shed some light ?

thanks in advance for your great help, each and every tip / help will be very much apprecited.

Posted 30-Oct-12 6:58am

Bala Selvanayagam

Updated 5-Aug-16 23:57pm

v2

Add a Solution

Comments

ZurdoDev 30-Oct-12 13:23pm

Do a search on "c# how to post data to a website" You can mimic a user filling out the form through C#.

Bala Selvanayagam 30-Oct-12 13:36pm

thanks ryanb31

http://msdn.microsoft.com/en-us/magazine/cc337896.aspx

looks usefull through poweshell but not sute untill proven

I am mainly looking to send key strokes (TAB to navigate between controls) and paste the text box values

looks promising http://stackoverflow.com/questions/7610558/how-to-automate-firefox-with-powershell

bbirajdar 31-Oct-12 3:01am

Why not upload the excel to the server and read it record by record and then insert into database?

Bala Selvanayagam 31-Oct-12 3:10am

The challenge is, the web site is a third party web site and into which, we needs to input the release details(do not worry about what is release but records like students name, address & age) o about 200 records every day and takes 4 hours of a single staff causing delays.

We do not have any control over the web site / database ( its on java server pages) but have a login user name and password to input the data

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ijmar86 · Answer 1 · 2012-10-30T20:47:00

Solution 1

You can import your excel to Datagrid and on submit, you can convert the data from Datagrid to xml and save in Database using Stored Procedures.

For importing Excel to Datagrid sample code, there are many links available

http://www.c-sharpcorner.com/uploadfile/ankurmee/import-data-from-excel-to-datagridview-in-C-Sharp/[^]

http://csharp.net-informations.com/datagridview/csharp-datagridview-load-excel.htm[^]

Posted 30-Oct-12 20:47pm

ijmar86

Comments

Bala Selvanayagam 31-Oct-12 3:11am

This may not work, please read my requirement careully

The challenge is, the web site is a third party web site and into which, we needs to input the release details(do not worry about what is release but records like students name, address & age) o about 200 records every day and takes 4 hours of a single staff causing delays.

We do not have any control over the web site / database ( its on java server pages) but have a login user name and password to input the data