Reputation: 11
I am trying to export self updating .xls file from other website to mine as csv, so that I will be able to create "Live data graphs" using Highcharts JS for different parameters from this , which also update automatically according to the file.
OR
I have another method, same self updating data is on a website in form of table which gets updated with time. So , is it possilble to pull data from there for specific parameters and generate live data graphs?
Please Help.....
Upvotes: 0
Views: 229
Reputation: 17791
How about using a Google spreadsheet?
http://dataist.wordpress.com/2012/11/23/using-google-spreadsheet-as-a-database/
Upvotes: 1
Reputation: 4743
If I got you right, you want to convert an .xls
file to .csv
?
Then you'll want to look at this article:
http://www.c-sharpcorner.com/uploadfile/yuanwang200409/how-to-convert-xls-file-into-csv-file-in-c-sharp/
As well as consider some answers on SO:
Personally I like the solution to extract .xls
into dataset and then generate you .csv
from datatble. (see c# datatable to csv)
Upvotes: 1