This article shortly describes how to read an Excel file into Julia. Generally, one can use different libraries to read Excel files, including XLSXReader , ExcelReaders or Taro. In this tutorial I will focus on Taro as it created the fewest problems and provides – at least in my eyes – an easy to understand syntax.
In order to read an Excel file into Julia it is sufficient to execute the following lines of code:
# in case you have not installed to Pkg yet Pkg.add("Taro") # load Taro - Pkg to read Excel Data using Taro Taro.init() # get data df = Taro.readxl("path to Excel", "sheet1", "A1:C357")
This code will read the selected data fields, i.e. field A1 to field C357, of sheet1 into a dataframe in Julia. You can also directly consult the documentation of the Taro Package here.