csv files

Linux Journal: "One of the enhancement suggestions I got was to add the ability to extract all the sheets and/or a specific sheet rather than always extracting the first sheet.

The following update to the code does just that."

Some months back I developed some pyuno code for converting spreadsheets into CSV files from the command line. Pyuno being the Python interface to the OpenOffice runtime.

One of the enhancement suggestions I got was to add the ability to extract all the sheets and/or a specific sheet rather than always extracting the first sheet.

How to extract and manipulate CSV data using the command line.

Download in .ogv format

read more

How to extract and manipulate CSV data from the command line.

Download in .ogv format

read more

In my last few posts about pyuno (SSConverter, OORunner) we used pyuno to convert spreadsheets to CSV files by running OpenOffice from Python using

Using the SSConverter class that we developed last week, which used the OORunner class from the week before that, this week we'll create a Python function that allows us to use spreadsheets as if they were CSV files by converting them on

read more

Using the OORunner class that we developed last week we'll now create a Python class for converting spreadsheets into CSV files.

The converter supports any type of input spreadsheet that is supported by OpenOffice.

read more

As a buddy of mine always says "the nice thing about standards is that there's so many to choose from".

Take CSV files for example. CSV, of course, stands for "Comma Separated Values", more often than not though, it seems that CSV files use tabs to separate values rather than commas.

read more