I need a script that will take data from a spreadsheet, and insert it into html code.
Please take a look at the attached files..
1) The html file graphs many latitude and longitude points which are listed within the code.
2) The spreadsheet contains many additional latitude and longitude points that are not currently listed.
I want to be able to take any spreadsheet which is formatted this way, and have the latitude and longitude points inserted into the html (and replace the current contents).
THIS CAN BE DONE HOWEVER YOU LIKE.
If you would rather have the html file directly read a csv / xls file each time it is opened, that will be ok too. The file will be used locally, not on the web.
If you would like to make a quick application which generates a html output file after inputing a spreadsheet in this format, thats ok.
If you have a different solution, go ahead and suggest it I will likely be ok with it.
Just as long as I can take an excel file thats in the same format as the example, and output it into an html file thats in the same format as the example.