从excel进入网页的数据

Question

I have an excel file with 3 columns, "First name", "Last name", "email" and about 700 entries (rows). I also have a website with a form for first name, last name and email. Obviously I don't want to type out all 700 entries manually. Is there a way to get these columns from excel and enter them into the online form? Perhaps using visual basic/php or any other alternative. If such code already exists then it would be great if somebody could show me. If not, then it would be appreciated if somebody could give some advice on how to approach this. Thanks!

Answer 1

PHP has a CSV method, you can convert/save your excel file to csv and process if using PHP.

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

https://www.w3schools.com/php/func_filesystem_fgetcsv.asp

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

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

check out https://www.w3schools.com/php/func_filesystem_fgetcsv.asp

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

There is also varied information on how to's on SO. How to use Selenium with PHP?