I have a website for my team. I also have the responsibility of downloading an excel file from a remote server and displaying it on my web page. I am able to convert the spreadsheet to a .csv and import it into mysql database everyday and display it that way.
My question is this. Does anybody know of a way to write a php script to connect to an excel spreadsheet on a webserver and use it as a datasource? What I am trying to do is eliminate the responsibility of downloading and converting it everyday. I want it so when somebody opens the php page on my webserver, it connects to the excel spreadsheet on another webserver and displays it according to my script.
Does anybody know of a way to do this?
mojodojo
My question is this. Does anybody know of a way to write a php script to connect to an excel spreadsheet on a webserver and use it as a datasource? What I am trying to do is eliminate the responsibility of downloading and converting it everyday. I want it so when somebody opens the php page on my webserver, it connects to the excel spreadsheet on another webserver and displays it according to my script.
Does anybody know of a way to do this?
mojodojo