Author Topic: Export data to Excel  (Read 836 times)

0 Members and 1 Guest are viewing this topic.

Offline Guillaume_67370

  • Contributor
  • ***
  • Posts: 112
    • METEO OFFENHEIM
Export data to Excel
« on: October 31, 2020, 09:05:00 AM »
Hello,

I want to export data from each day into an XLS file. What is the procedure ?
If i use dayfile.txt it isn't any title it's only the data, so we don't know which data correspond to which parameters...

Thanks for your help
Regards

Offline PaulMy

  • Forecaster
  • *****
  • Posts: 5268
    • KomokaWeather
Re: Export data to Excel
« Reply #1 on: October 31, 2020, 09:45:49 AM »

Quote
If i use dayfile.txt it isn't any title it's only the data, so we don't know which data correspond to which parameters...
The files dayfileheader.txt and monthlyfileheader.txt located in your Cumulus folder have the header description text that you would need to include or add to your import file as the titles.


Enjoy,
Paul
Davis Vantage Pro 2 Plus 24-FARS Wireless - Komoka, ON Canada
Envoy/USB Logger/Cumulus v1.9.4  www.komokaweather.com  
WFL/CMX www.komokaweather.com/komokaweather-ca2/index.php
WLL/CMX www.komokaweather.com/cumulusmxwll/index.htm
WLL/CMX www.komokaweather.com/cumulusmxwll/index.html
WLL/CMX www.komokaweather.com/cumulusmxwll/index.php
Blitzortung Station #1076


Offline Guillaume_67370

  • Contributor
  • ***
  • Posts: 112
    • METEO OFFENHEIM
Re: Export data to Excel
« Reply #2 on: October 31, 2020, 10:08:13 AM »

Quote
If i use dayfile.txt it isn't any title it's only the data, so we don't know which data correspond to which parameters...
The files dayfileheader.txt and monthlyfileheader.txt located in your Cumulus folder have the header description text that you would need to include or add to your import file as the titles.


Enjoy,
Paul

Thanks a lot Paul  :-) and it's not possible to have the traduction in French from these header descriptions ??

Guillaume

Offline PaulMy

  • Forecaster
  • *****
  • Posts: 5268
    • KomokaWeather
Re: Export data to Excel
« Reply #3 on: October 31, 2020, 11:49:32 AM »
If I recall correctly from years ago, Steve did have some Cumulus French translations some ware.  Can't recall what all was translated.  Possibly a search on the Cumulus forum or WiKi may show something.
Or you could get each title translated by a bilingual person (not me) and then create an identical file but with French headings.


Enjoy,
Paul
Davis Vantage Pro 2 Plus 24-FARS Wireless - Komoka, ON Canada
Envoy/USB Logger/Cumulus v1.9.4  www.komokaweather.com  
WFL/CMX www.komokaweather.com/komokaweather-ca2/index.php
WLL/CMX www.komokaweather.com/cumulusmxwll/index.htm
WLL/CMX www.komokaweather.com/cumulusmxwll/index.html
WLL/CMX www.komokaweather.com/cumulusmxwll/index.php
Blitzortung Station #1076


Offline ulrikesembler

  • Member
  • *
  • Posts: 1
Re: Export data to Excel
« Reply #4 on: September 07, 2022, 06:51:23 AM »
Creating an XLS file from Excel is an easy task. It's also a very handy way to share your data with others. That's because XLS files are compatible with Microsoft Excel and OpenOffice Calc, meaning that anyone with either program can open the file and view its contents. There are two main ways to create an XLS document, both of which involve exporting your data from Excel to a new file. You can read more in this article. The first method is to use the File menu and choose Export. The second way is to right-click on any worksheet tab in the workbook, select Save As, and choose the XLS option from the drop-down menu.

Offline Gyvate

  • Forecaster
  • *****
  • Posts: 1923
Re: Export data to Excel
« Reply #5 on: September 17, 2022, 02:59:23 PM »
and it's not possible to have the traduction in French from these header descriptions ??
Guillaume
you can do this yourself  8-) - take the dayfileheader.txt and monthlyfileheader.txt from ..\CumulusMX and translate them
you can use www.deepl.com - works perfectly and with high quality
As you are probably French you can cross-check the translations yourself too ...

tu peux le faire toi-même 8-) - Prends les fichiers dayfileheader.txt et monthlyfileheader.txt de ..\CumulusMX et traduis-les.
tu peux utiliser www.deepl.com - fonctionne parfaitement et de haute qualité
Comme tu es probablement Français, tu peux aussi vérifier les traductions toi-même...  ;)

Maybe the file content is different with Cumulus 1.9.4 - the above is for CumulusMX 3.2.1
But the principle remains the same - and already Cumulus 1.9.4 should have had these header files
« Last Edit: September 17, 2022, 03:03:19 PM by Gyvate »
WS2350 1.6.4, GW1000(3) 1.7.5, WH2650 WiFi (2) 1.7.5 (test/backup), GW1100 2.1.8, GW2000(3) 2.1.8/9, HP2551 1.6.4/1.8.5;
Ecowitt WS90(2), WS80, WH40, WH65, WH31(5), WH31-EP, WN30, WH32, WH32-EP, WH32B, WH57 [Lightning] (1), WH41 [PM2.5] (2), WH51 (4), WH45, WH55 (1)
MeteobridgePro(2)[test,prod] 5.4 Sep 7 2022, 14816 - Blake-Larsen Sun Recorder - RPi4/weewx 4.8.0/CumulusMX 3205/MB RPi4(2850)
Barani Meteoshield Pro, MetSpec Rad02 - Ecowitt 5763,34418;WU ISAARB3(WH4000SE), ISAARB22(HP2553), http://meshka.eu