How to log in and auto fill values into a 'drupal form' from an 'excel file'?
Question: So, there is this website where I have to log in and insert values in the _add
content->person roles_ and I have to take values from an excel file. I tried
entering the values in the database directly but got nowhere. The database is
too randomly generated.

I want to know- how to go by this problem? I think _python_ would be the best
way but I am more comfortable with _java_. The images bellow will help
understand the situation better-

The log in from:  
![log in form](http://i.stack.imgur.com/wHd8R.jpg)

The form to be filled:  
![log in form](http://i.stack.imgur.com/XwaOF.jpg)


Answer: Try using feeds module:

<https://www.drupal.org/project/feeds>

Install it on you site first of course. Or look for some similar import
module. Maybe this one:

<https://www.drupal.org/project/datasources>

If nothing succeeds then try making import script on your own. You have to
parse document (would be much easier to open it from excel and export as CSV
if possible <http://php.net/manual/en/function.fgetcsv.php>) and have some
loop to write content into Drupal system. Use Drupal's functions for that, do
not directly write to database. It's not hard as it looks like:

<https://www.drupal.org/node/1388922>

