Link Data from Excel

Report · Apr 04, 2018

I am trying to create a dynamic link from excel to dreamweaver and all the help I find says to select things that are not there. So my question is how do I link the values from excel into a cell in dreamweaver?

Report · Apr 04, 2018

Could you provide detail? I'm not understanding your request. ".. dynamic link from excel to dreamweaver.."?

V/r,

^ _ ^

Report · Apr 04, 2018

I need the value of a cell from excel that changes daily to reflect in the cell on the webpage

Report · Apr 04, 2018

Well, the best way to do that would be to use a server-side language (like ColdFusion) that has built-in Excel functions.

I used to think that there was no way to do it without a server-side language, but I was wrong. I just found this SO thread that explains how you can do that using JavaScript.

Hope this helps,

^ _ ^

Report · Apr 04, 2018

Thank You I will try that

Report · Apr 04, 2018

Actually, I should have done more research before responding. ActiveXObject will soon be deprecated, and is only supported in IE on Windows.

There are other ways of doing it, but they all involve downloading some kind of Javascript library, or jQuery plugin if you're using jQuery.

V/r,

^ _ ^

Report · Apr 04, 2018

Personally I would try to get that data out of Excel. Excel is great for very simple data stored in spreadsheets, but it's not a very easy thing to work with across multiple users or systems. I did do a little research though and found this library if you wanted to build a PHP script that could read from an Excel doc ( GitHub - PHPOffice/PhpSpreadsheet: A pure PHP library for reading and writing spreadsheet files ).

If you wanted to move the data elsewhere, you should know Excel data does not have to live in Excel. There is functionality to use Exteral Data Sources with Excel to connect to MS SQL, mySQL, Oracle, etc. etc. So another option might be storing that data somewhere else in a central database and then use an external connection in Excel to query the data and the data could then also be extracted easier with a server-side language for the web server, but also accessible in Excel.

Report · Apr 04, 2018

<!doctype html>

<html>

<head>

<title>Production Tally</title>

.cell1 {

font: 200 normal xx-large/normal "cooper-black-std";

font-size: 100px;

text-align: center;

color: brown

}

</style>

.style {

font: 400 normal xx-large/normal cooper-black-std;

font-size: 250px;

text-align: center;

text-transform: none;

color: brown;

}

</style>

.style1 {

font: 400 normal medium/normal cooper-black-std;

font-size: 100px;

text-align: center;

text-transform: none;

color: brown;

}

</style>

</head>

<header class="style">Production Tally</header>

<tbody>

<tr>

<th scope="col" class="style1">Afternoons</th>

<th scope="col" class="style1">Midnight</th>

</tr>

<tr>

</tr>

</tbody>

</table>

This is what I have so far I need the info to go into the cells above

Report · Apr 04, 2018

This really should be done via server-side code, either ColdFusion (which gets Excel interactivity from POI), or PHP (as Ben M has suggested.)

If you are not an experienced coder, this is going to be a difficult job, because there is no DW plugin or extension that will automatically do this, for you.

You could try the Javascript or jQuery libraries that I suggested, but this really should be done server-side.

V/r,

^ _ ^

Report · Apr 04, 2018

Thank you

Report · Apr 04, 2018

As stated above, you need to translate the CSV data into JSON or a database format.

This is the one that I use https://www.dmxzone.com/go/32574/dmxzone-data-importer/ to import the data into a database.

Wappler is the DMXzone-made Dreamweaver replacement and includes the best of their powerful extensions, as well as much more!

Link Data from Excel

1 Correct answer