Import Excel spreadsheet to prepopulate a field?

How to prepopulate a form dropdown from an Excel spreadsheet.

Overview

The issue is that form fields cannot directly read data from an Excel file.
Import the spreadsheet data into a database table or convert it to a PHP array, then use that data source to populate the dropdown menu.

Answered
We WebTeam110 31 Mar, 2023
Is it possible to prepopulate form fields from an Excel spreadsheet? For reference, I'm trying to create a form where users can select their name from a dropdown menu. Is this possible?
Max_admin Max_admin 02 Apr, 2023
Answer
No, you need to import the sheet data into a database table then read the data from the table, or convert the list to a PHP array and pass that to the dropdown
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.