Menu

Import directly from an Excel speadsheet

+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.4k points)
recategorized by
Share on
share on gp share on fb share on tw share on li

1 Answer

0 votes

dbFront 1.1.2.214 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 (65.2k points)
edited by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.

Categories

Most popular tags

table-view error lookup-field security action-button table-grid form-fields advanced-search user-interface stored-procedure css reporting customizing installing tables import url authentication export attachments single-sign-on user-help active-directory login search sqlserver database-connection foreign-key license field-preferences custom-visibility email performance pdf-form cascading-lookup themes mysql date-field backup upgrading table-relationships quick-search drop-down-list logo table-preferences refresh excel printing duplicates notifications primary-key iis azure database webrequest costed sidebar-help user-profile multi-select main-menu attachment-properties iframe numeric-field access-control record-locks timeout sorting multilingual header connector audit support csv oracle display hosting connection link help html-fields whitelisting child-tables session-key-failure wildcard-search font-size caching save-button row-security default-value barcode network-file local-file integrations logout custom-sorting validation custom-caption debugging ldap xml
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...