user2441111
user2441111

Reputation: 11

How to export a .xls file from a website as a CSV file?

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

Answers (2)

jlbriggs
jlbriggs

Reputation: 17791

How about using a Google spreadsheet?

http://dataist.wordpress.com/2012/11/23/using-google-spreadsheet-as-a-database/

Upvotes: 1

Artur Udod
Artur Udod

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

Related Questions