Connecting to Excel (XLSX)

These are the steps needed to connect BiG EVAL to an Excel-file. It could be either a XLSX or an XLS file as well.

1. Ensure that the folder where youre Excel file is located, can be accessed from the BiG EVAL server. Either on a local drive or using a network share.
   
2. Ensure that the file can be accessesd by the BiG EVAL service account or a domain user you will configure in the “Credentials” dialog of the datasource.
   
3. Create a new data source under “Environment” > “Datasources” and give it a name.
   
4. Choose “Excel” as the type of the datasource.
   
5. Change to the register “Excel”.
   
6. Enter the path and filename of the Excel-file by using an absolute location.
   e.g. C:\Testdata\MyFile.xlsx
   
7. Enter the name of the Excel-Sheet you want to read data from into the “Sheet” textbox. An excel-sheet is a register within the excel-file.
   
8. Enter the Cell-Area you want to read data from into the “Area” textbox. Use the Excel-Syntax.
   The following example selects all cells starting at A1 until and including D10000.
   A1:D10000
   If the cell-area should be a kind of dynamic, you should enter a larger area including some empty rows or columns. BiG EVAL only reads in cells that have a value. Therefore, empty cells will be filtered out automatically.
   
9. Choose whether your cell-area includes a header-row.
   
10. Change to the register “Columns”.
    
11. Add all columns of the excel-file to the list. The names can differ from the ones in the excel-file. You can freely choose a convenient name.
    
12. Save the datasource.