Uploading data files
Variable values can be imported from text files, Microsoft Excel documents, and OpenOffice/LibreOffice spreadsheets.
Transferring data from a file to a variable’s value is a 2-step process:
CSV files (Comma Separated Values), a special type of text file that can be written by many applications, are also supported. Note that you’re not just limited to comma-separated data; semicolons, tabs, etc. will work just as well.
Uploading a file
- Click on the Upload data file tab at the bottom of the Solver. (See screenshot below)
- In the panel that slides up, click on the button at the bottom of the Uploads panel
- Select a file from your computer
- Click on the button at the bottom right of the file upload panel
Any files you upload will be deleted from our server if you log out or do not use them for several hours
Assigning a row or column of data to a variable
In the Solver, find the variable you want to assign the file data to and click on it
Select the file you uploaded (from the steps above)
Select whether you want to use a column or row (line) of data from the file
- The data file is parsed into a grid of data made up of columns (vertical) and rows (horizontal), similar to a spreadsheet.
Find the line or column number that has the data you want to use for the variable, and enter it into the text box
- The 1st value in the file, i.e. at the upper left-hand corner, is on row 1, column 1
Make any adjustments to the file layout settings, as described below
Press the button
The variable’s value field will then be updated with the new data.
Advanced file layout settings
The server will do its best to figure out the layout of the data in your file.
For text files, it will guess which field separator is in use for the file (comma, semicolon, etc), as well as attempting to deduce the format of the numbers, whether it be continental European-style commas for the decimal mark, or the period used in most English-speaking countries.
You can see the server’s guesses on the right-hand side of the file upload panel.
If any of this information is wrong, correct it before pressing the button.