Data entry into web page from excel

Question

There are roughly 700 items in an excel document with three columns for first name, last name, and email (rows). My website also includes a form that asks for first name, surname name, and email. Naturally, I don't want to manually type out all 700 entries. Is it possible to import these columns from Excel into the online form? Possibly utilizing PHP and Visual Basic, or any other option. It would be nice if someone could show me such code if it already exists. If not, it would be helpful if someone could offer suggestions for how to approach this.

Answer 1

Reading the File in PHP

Example 1

How to create an array from a CSV file using PHP and the fgetcsv function

$file = fopen('youruploadedfile.csv', 'r');

while (($line = fgetcsv($file)) !== FALSE) {
  // each line of the array

 print_r($line);
}

fclose($file);

Example 2

$file = fopen("youruploadedfile.csv","r");

while(! feof($file))
{
 print_r(fgetcsv($file));
}
fclose($file);

 

Definition and Usage

Definition and Usage

The fgetcsv() function parses a line from an open file, checking for CSV fields.

The fgetcsv() function stops returning on a new line, at the specified length, or at EOF, whichever comes first.

This function returns the CSV fields in an array on success, or FALSE on failure and EOF.

---

Selenium

Selenium is a tool to automate user interface testing. It helps with testing your application against the browser

Take a look at the web driver  https://github.com/facebook/php-webdriver.