Converting Microsoft Excel sheet (XLS file) to a Comma Separated file (CSV) is relatively very easy while using an Office product, but it could be a tedious task for programmers to do it in command line. The situation may arrive when you have a XLS file and you need to fill the database from it after formatting the data. Converting the XLS to CSV is the ideal way here as the CSV is the format that can easily be manipulated in any language, be it Shell, Perl, Ruby, Python or Java. In this post, we will see the best ways to convert the XLS file to CSV and we will also discuss the pro and cons of using these methods.
[Read more...]
How to convert XLS file to CSV in Command Line [Linux]
By | February 3, 2012 | Leave a Comment
9 More OpenOffice Extensions
By | April 17, 2010 |
Moving all of your apps and information in the cloud has been adopted by a great number of people. However, there are also a large number who still prefer having a desktop application. Pretty much everyone like free.
I am typically use Google Docs for my word processing and spreadsheets, but do on occasion tinker with OpenOffice. I tend to use OpenOffice if I am on my netbook and not connected to the internet. I can use the word processor to write and not be tempted to go on Twitter or use Stumbleupon to find random sites.
At first, I didn’t realize you could use extensions; once I found that out, I was hooked. One of my favorites was covered in a previous post about OpenOffice extensions. It allows you to import, export and update documents you create in OpenOffice with Google Docs and other cloud office apps.
Below are several more extensions to help you tailor this opensource app to the way you use it.
[Read more...]
5 Tips for Google Spreadsheets
By | October 13, 2009 |
I see posts on business oriented sites almost daily shelling out tips for every inch of the Microsoft Office Suite. An equal number of sites talk about Gmail, giving tips and ways to be more productive while using it. What about Google Docs? Docs can do some equally fancy stuff too.
Slowly but surely Google has been adding a feature here and a feature there. Some have been bigger steps than others; all of them are chipping away at the reasons you need to buy an office suite. I’m not going to get on a soapbox and shout to the world. I will however, give you a few nifty tips to make using Google Docs spreadsheets a little easier.
[Read more...]
