Vitruvian Tux

It was quite logical given the prolonged absence from these pages that something was about to change.

Unfortunately I have no way, running from just this blog, to find the time to continuously update material - of course if anyone wants to help is welcome! - Mainly to update it with fresh news and not "recycled" from the echo generated daily by the chaos blogosphere.

My decision was therefore very simple: VitruvianTux continue to exist even if very rarely will show new post because of its highly technical nature and geared to a specific field of information technology (there are hundreds if not thousands of blogs on Linux and Free software and certainly not the lack of this will be felt much ^_^).

In the meantime I decided to create a new personal blog (thus less tied to various technical and possible, even if the computer will occupy a good chunk of the posts you write there ..).

Why create a new blog and not write directly about this? Obvious.

Not want "dirty" feeds with topics unrelated to those for which it was born VitruvianTux. The goals are and will be different. The new blog (which will also collect all the projects on which work) you can find it at: Blog.GiulioRossetti.net.

I will try to post as much as possible in English on that space - it depends on the time available, as always the rest.

Well, what to say, the next .. and past both here and visit me in my new space!

Popularity: 3% [?]

Like most of my post even this comes not only with the intent to do some 'information, to remind me of how I have solved a problem that occurred to me: In fact my memory is usually fallacious and googol To find the same information more than once I do not like very much ^ _ ^

An activity that often we have to do is to process "on the fly" a xls file (perhaps as a result dell'upload available to a user) and manage the data contained in it (possibly structured as we expected otherwise the thing is impractical ..) for example, the popular tables in a database or simply view them on our site.

Well, the solution to this problem is easier than you think.

It runs a project on Sourceforge that makes it available via the class ExcelReader everything we need.

Having included the two files reader.php and oleread.inc in our script and we will be ready to do the job "dirty".

First we initialize our class and then passiamogli the file to open:

  $ data-> read ( 'nome_filel.xls'); 

The next thing to do, of course, is to make a loop for each row and column pointing out that:

  $ data-> sheets [0] [ 'numRows'];
 $ data-> sheets [0] [ 'numCols']; 

represent the number of rows and columns in the file xls (particularly in the first sheet of paper).
At this point we can take the value contained in each cell access it as we do with a trivial matrix:

  $ data-> sheets [0] [ 'cells'] [$ i] [$ j]; 

A sample script to show a video data from a xls file in tabular form are the following:

  <?
 require_once 'Excel / reader.php';
 $ data = new Spreadsheet_Excel_Reader ();
 $ data-> setOutputEncoding ( 'CP1251');
 $ data-> read ( 'nome_file.xls');
 error_reporting (E_ALL ^ E_NOTICE);

 echo "<table>";
 for ($ i = 1, $ i <= $ data-> sheets [0] [ 'numRows'], $ i + +) (
         echo "<tr>";
	 for ($ j = 1, $ j <= $ data-> sheets [0] [ 'numCols'], $ j + +) (
		 echo "<td>. $ data-> sheets [0] [ 'cells'] [$ i] [$ j ]."</ td>";
	 )
	 echo "</ tr>";
 )
 echo "</ table>";
 ?> 

PS: Of course you can also loop on the sheets that compose the file .. xls

Popularity: 7% [?]

GuruAtWork and Cultural Association "Working Class Hero organize Saturday, October 24th, 2009, with the collaboration of CNA Grosseto, the Linux Day.

In this edition, the Linux will change when Day and events will be held at the premises of CNA, in Burma 96 (click here for map).

The registration event is not mandatory, but by registering in advance will help us in the procedures for registration of participants, particularly in case you want to receive the certificate of participation.

The main themes of the 2009 free software, and companies will cover legal aspects of free software development and publishing content on the web using free tools and gaming (video game) on Linux.

Two will be the track in this year, which will be held simultaneously in two separate rooms, one is kind of popular, the other of a technical nature.

To all those who register for the event (which will follow) will be issued a certificate of participation that can be used, for example, to request educational loans etc..

As every year will be staged area with PC it will install various Linux distributions and free software, so that participants can experience first-person technology and software covered during the course of the day.

Program

There will be two tracks on this edition of Linux Day: a service to business, popular character, who will explain how you can use free software in the performance of their professional activities.

The second track, of a more technical and addressed to all lovers of free software or who want to bring to this world for the first time, will consist of workshops on some of the most popular free tools (graphics, web and virtualization).

The actions will take place during the morning while the afternoon the staff of Guru @ Work and WCH will remain at your disposal to answer questions and provide help on using free software.

Popularity: 3% [?]