Skip to main content
Participant
August 10, 2021
Question

Data Merging Excel file to Dreamweaver template

  • August 10, 2021
  • 2 replies
  • 681 views

Is there a way to take that data from the excel sheet and merge that data with a template I created in dream weaver? I don't want to data to display the same on dreamweaver as it does on the excel file. Does anyone have any insight? 

 

This topic has been closed for replies.

2 replies

B i r n o u
Legend
August 11, 2021
quote

I don't want to data to display the same on dreamweaver as it does on the excel file. Does anyone have any insight?

By @Aurora5CA1

 

if you want to present the data differently, i.e. not tabulated, then you have to proceed in two steps, the first one to inject the Excel file in a database, and then distribute these data from a script (Javascript, or PHP) in an appropriate HTML structure.


However, the database step can be avoided, if you use PHP and a library to browse Excel data PHPSpreadsheet and so on


Javascript also offers various possibilities to read XLSX or CSV data, there is also a plugin that allows you to transform your data from Excel into JSON (I never tried this last way)

Nancy OShea
Community Expert
Community Expert
August 10, 2021

Excel is not a database, it's a spreadsheet.  Copy and paste tabular data into HTML tables. 

 

Although not 100% perfect, there's a feature in DW for importing tabular data from the File menu.  See screenshot.

 

 

Hope that helps.

 

Nancy O'Shea— Product User & Community Expert
Participant
August 10, 2021

Thank you for your response. I will try that now!