Export data as XLS file

Question

data = WeatherData["WMO44207", "Temperature", {{1950}, {2013}}]

This list contains 11400 records ... date,temperature value .... I want to export all records as an XLS file. How can I do that?

$\begingroup$ Take a look at the help for Export[] $\endgroup$
– Dr. belisarius
Commented May 5, 2014 at 12:50 — Dr. belisarius, Commented May 5, 2014 at 12:50

2 revs · Accepted Answer · 2017-04-13 12:55:44Z

1

The way you want to Export data depends on your tastes and what you plan to do with the XLS file afterwards.

But as belisarius said Export is your friend:

rawdata = WeatherData["WMO44207", "Temperature", {{2013}, {2013}}]
Export["your/Path/rawdata.xls", rawdata, "XLS"]

enter image description here

If you want to Export rawdata after making some Mathematica operations on it (e.g. DateString) you can do the following:

data = Thread@{DateString /@ First /@ rawdata, Last /@ rawdata}
Export["your/Path/data.xls", data, "XLS"]

enter image description here

community wiki

2 revs
Öskå

$\begingroup$ :) ...and what is the trick to link a comment?? $\endgroup$
– Dr. belisarius
Commented May 5, 2014 at 14:04
$\begingroup$ Click on the timestamp. $\endgroup$
– Öskå
Commented May 5, 2014 at 14:05
$\begingroup$ Ha! I never saw that link! Nice! $\endgroup$
– Dr. belisarius
Commented May 5, 2014 at 14:07
$\begingroup$ That can be useful sometimes.. :D $\endgroup$
– Öskå
Commented May 5, 2014 at 14:11

Add a comment |

1 Answer 1