DONE: Add Excel Import functionality

+3 votes

Currently the import process only allows CSV files. It would be great if XLSX files would also be supported.

in Features (Done) by (7.0k points)
recategorized by

1 Answer

0 votes

dbFront now allows direct import from Excel (xlsx) files.

dbFront will look in the first worksheet and scan for the range of cells used. The first row must contain the column names.

An easy way to use or test out the functionality is to use the Quick Print / Export functionality to export a section of the table to an Excel file, edit the Excel file and then reimport it.

by (64.5k points)
edited by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer