Excel Macro Example: Sun Rise, Set, Transit, Twilight

Versione 1.0.1 (58,2 KB) da Meg Noah
to demonstrate writing inputs and reading outputs from an xlsm spreadsheet
0.0
(0)
90 download
Aggiornato 21 feb 2020

Visualizza la licenza

The purpose of this project is to demonstrate how to interact with an Excel xlsm file to write inputs and read outputs from the Excel calculation. For this example, the matlab code sets the inputs of location and time, and reads the values calculated by the spreadsheets: Sun's rise, set, transit, and twilight.

The download includes the spreadsheet xlsm files. The xlsm extension is the spreadsheet that enables visual basic macros. The .BAS file and a text file explaining how to create your own calculator spreadsheet is included in the download.

Cita come

Meg Noah (2024). Excel Macro Example: Sun Rise, Set, Transit, Twilight (https://www.mathworks.com/matlabcentral/fileexchange/74300-excel-macro-example-sun-rise-set-transit-twilight), MATLAB Central File Exchange. Recuperato .

Compatibilità della release di MATLAB
Creato con R2019b
Compatibile con qualsiasi release
Compatibilità della piattaforma
Windows macOS Linux
Categorie
Scopri di più su Celestial Phenomena in Help Center e MATLAB Answers

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Versione Pubblicato Note della release
1.0.1

Fixed that line of code in getTwilightTimes.m
1.0.0