Skip to main content
Participant
Aug 10, 2021 1:34 PM UTC
Question

Data Merging Excel file to Dreamweaver template

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 is closed to new replies. Start a new post to keep the conversation going.

4 replies

B i r n o u
Legend
Aug 11, 2021 8:44 AM UTC
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)

Translate
Nancy OShea
Community Expert
Community Expert
Aug 10, 2021 5:50 PM UTC

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.

 

Translate
Nancy O'Shea— Product User & Community Expert
Participant
Aug 10, 2021 6:29 PM UTC

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

 

Translate