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?

  • 1
    $\begingroup$ Take a look at the help for Export[] $\endgroup$ – Dr. belisarius May 5 '14 at 12:50

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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.