locked
Expressions and Excel RRS feed

  • Question

  • Currently setting a small website up for work and would like to be able to link the web site to Excel documents:

    The idea is for us to be able to update information, in Excel, and the information show on the website. 

    For example if a create a table on the site the corresponding information from the Excel spreadsheet in shown in the table.  So on the site a would have customer name, in the Excel sheet C2, would be the name and this would appear in the table. If they update the spread sheet this will update the site as the details are pulled through from Excel.  

    I assume this is just some coding if you can help.

    Thank you 

     

    Sunday, January 18, 2015 4:13 PM

All replies

  • A website can't interact directly with an Excel spreadsheet on the desktop.  You can upload the spreadsheet to the website and have it extract the data from Excel using PHP.  Here is a good site.


    https://code.google.com/p/php-excel-reader/
    • Edited by mogulman52 Wednesday, January 21, 2015 3:17 AM
    Wednesday, January 21, 2015 3:17 AM