Loading data from Excel files
This example shows how to use Script source window to load data from Excel files by using XLSX Julia package.
You will have to install XLSX package before using this example. Please note that there are many other packages for Julia which add Excel file support.
using XLSX
function update( output_signal::SigviewSignalWindow )
#load xslx file
xfile = XLSX.readxlsx("c:/temp/data.xlsx")
#get one sheet
sheet = xfile["data"]
#get data from specific cell range and convert to array
output_signal.samples = sheet["D7:D37"][:,1]
#read sampling rate from one cell
output_signal.samplingRate = sheet["C6"]
#get unit string from one cell
output_signal.xAxisUnit = sheet["C5"]
return true
end