Overview

Introduction and Purpose

This toolbox provides functions for importing and exporting numeric tabular data (*.csv, *.dat, *.txt, *.xls, *.xlsx) without hassle. It is based on Scilab's in-built functions csvRead(), fscanfMat(), cvsWrite() and the Excel-format read and write functions of the toolbox "XLreadwrite". The purpose of this toolbox is to make the use of these functions more convenient by introducing a GUI for selecting the files and specifying the im- or export parameters.

Choose data file:

Read CSV- and text-data files:

Read Excel's XLS- or XLSX-files:

Write CSV- and text-data and …

… Excel's XLS-/XLSX-files:

It can easily integrated in scripts and controlled by dataINT's exit codes but can also be used in Scilab's console for importing or exporting data conveniently.

dataINT's import functions read the data from a comma-separated value (*.csv), other text-based data (*.dat, *.txt) or from a binary Excel 95-2003 (*.xls) and modern XML-Excel 2010-365 (*.xlsx) file into a Scilab matrix variable for further processing. The export function saves a Scilab matrix into a csv or other text-based file or an Excel XLS- or XLSX-file.

The following data formats, field and decimal separators are supported:

• COMMA-SEPARATED-VALUE files (*.csv) with field separators: comma, semicolon or tabulator. The decimal separator can be point or comma.

• TEXT-BASED-DATA files (*.dat, *.txt) with space or spaces as field separator. The decimal separator can be point or comma.

• EXCEL files in Excel 95-2003 format (*.xls).

• EXCEL files in Excel 2010-365 format (*.xlsx).

This makes dataINT flexible to a huge variety of commonly-used data formats.

dataINT can now import XML-based Excel files (Excel 2010 and higher)! The toolbox "XLreadwrite" is used for this purpose. It will be installed automatically, if needed.

Functions

DI_read:

Read data from a comma-separated-value, text-based data file or a binary Excel 95-2003 file and stores it into a matrix variable interactively.

DI_show:

Read the first 25 or an arbitrary number of lines of a text data file, displays them in the console and invoke the reading procedure "DI_read" after, if desired.

DI_writedat:

Write a Scilab matrix of doubles to a comma-separated value or other text-based file or Excel's XLS-/XLSX-file interactively.

Type "demo_gui()" in Scilab's console and search for "dataINT" to get started.

Functions (deprecated)

The following functions are obsolete. To avoid breaking legal scripts, the code stays in the toolbox but is removed from the documentation and a deprecation message is displayed.

DI_readcsv:

Read data from a comma-separated-value or another text-based data file and stores it into a matrix variable interactively.

The successor is DI_read.

DI_readxls:

Read data from a binary Excel 95-2003 file and stores it into a matrix variable interactively.

The successor is DI_read.

DI_writecsv:

Write a Scilab matrix of doubles to a comma-separated value or other text-based file interactively.

The successor is DI_writedat.

Authors

Hani A. Ibrahim - hani.ibrahim@gmx.de