Data entry into web page from excel

0 votes
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.
Oct 10 in Others by Kithuzzz
• 20,660 points
61 views

1 answer to this question.

0 votes

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

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.

answered Oct 10 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 22,040 points
296 views
0 votes
0 answers

Download Excel sheet from .NET Core 3.1 Web API with jQuery Ajax client

I am trying to download an Excel ...READ MORE

Feb 10 in Others by Edureka
• 13,640 points
378 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
6,117 views
0 votes
1 answer

Excel web query to login into a website

To be recognized by the web server ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
160 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
450 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,209 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
68 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
202 views
0 votes
1 answer

(Excel) Data Entry Form inputting data into table

Solution  Fill in all the fields in your ...READ MORE

answered Oct 15 in Others by narikkadan
• 37,660 points
53 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP