Superhuman Soap Dispensor

The add-in for Excel 2007 Tanagra and 2010

The add ("add-in" in English) "tanagra.xla" contributes greatly to the spread of software Tanagra. The principle is simple, it involves integrating a menu in Excel Tanagra. Thus the user can launch the statistical calculations without having to leave the spreadsheet. Simple as it Regardless, this feature facilitates the work of the Data Miner. The spreadsheet is one of the most used tools for data preparation (see KDNuggets Polls: Tools / Languages for Data Cleaning - 2008 ). By integrating the data mining software in this environment, the practitioner avoids repetitive and tedious manipulations: import, export, check the compatibility of formats, etc..

Installing the add-in in Office XP (valid Office 1997 to Office 2003) is described in one of our tutorials . The procedure lapses in Office 2007 and Office 2010 since the menus of Excel were reorganized. Yet the macro will work. It is a shame that the users can not enjoy it.

In this tutorial, we detail the steps to follow to integrate the macro Tanagra in new versions of Excel. We will focus on Office 2007 in a first step, we see that the procedure is also valid for Office 2010. This transition to newer versions of Excel is absolutely not trivial. Indeed, compared to previous methods, they can manage a larger number of rows and columns. We can treat up to 1,048,575 base observations (the first line corresponds to the names of variables) et 16.384 variables .

Nous traiterons pour notre part une base comportant 100.000 observations et 22 variables. Il s'agit d'une version du fichier " waveform " bien connu des informaticiens. Notons que ce fichier, de par le nombre de lignes, ne peut pas être manipulé par les versions antérieures d'Excel.

La procédure décrite dans ce document est également valable pour la macro complémentaire associée au logiciel SIPINA ( sipina.xla ).

Mots-clés : importation des données, fichier excel, macro complémentaire, add-in, add-on, xls, xlsx
Composants : VIEW DATASET
Link: fr_Tanagra_Add_In_Excel_2007_2010.pdf
Data : wave100k.xlsx
References:
Tanagra, " Import XLS (Excel) - Add-.
Tanagra, "Connection Open Office Calc .
Tanagra, " Connecting Open Office Calc on Linux .
Tanagra, " Excel Connection - Sipina "