EasyNN-plus help
Getting Started
Data to Neural Network
Grid data Formats
Starting with Images
Inside EasyNN-plus
Samples
Projects
Simulating a Network with Excel
A Test Excel Simulation
Classifying Components from images
Predicting Soccer Results
Predicting Horse Race Winners
Shortcuts
Cloning Hidden Nodes
Learning Threads
Main Window's elements
EasyNN-plus main window
Grid
Network
Learning Progress
Predictions
Associations
Column Values
Example Errors
Input Importance
Sensitivity
Macros & Scripts
Toolbars
Main
Advanced
Extras
Tools
View & zoom
Reconfigure
Main Dialogs
Information
Import TXT CSV file
2nd Import Dialog
Input/Output Column Dialog
Example Row Type Dialog
Import XLS file
Import Binary file
Import Images
Edit Grid
New Network
Controls
Query
File Query
Trimming
Leave Some Out
Connections
AutoSave
Export special files
Classify Column
Extend Learning
Noise
Jog Weights
Forget Learning
Network Defaults
Import Defaults
Controls Defaults
File Open Defaults
Edit Defaults
Date & Time
Add to Subset
Select Subset
Forecast
Input Validating Rules
Output Validating Rules
Outside Limits
Edit Grid Range
Change Input/Output Types
Change Example Types
Copy Input/Outputs
Copy Examples
Missing Data
Image
Fragment Image
Image Fragment
Set Function
Diagnostic Array
Auto Shuffle
Freezes
< Previous page Next page >

Import XLS file

Import XLS file
 
Import. Simple spreadsheet files produced by Excel in xls format can be imported directly into EasyNN-plus but a much greater degree of import control is available if the files are first saved as comma separated csv types.  Files in xls format are limited to 256 columns and 65536 rows.
 
If the xls file is to be imported directly to produce a new Grid proceed as follows.
 
1.     File > New to create a new Grid.
 
2.     File > Import...
 
3.     Open the xls file that is to be imported.
 
4.     Enter the name of the sheet that is to be imported if it is different to Sheet1.
 
5.     Answer the messages according to how you want to create the Grid Input/Output and Example names.
 
6.     Step through all the columns setting the type and mode.
 
1

Worksheet name

1. Worksheet nameEnter the name of the worksheet to import.
 
[Top]
2

OK

2. OKClick to accept and close the dialog.
 
[Top]
3

Cancel

3. CancelClick to reject and close the dialog.
 
[Top]