Convert PDF Tables to Excel Format

October 28th, 2005 I wanted to manipulate dates in Microsoft Excel - the result is a sum of date, a fixed number of days and a variable no of day(s) from a second column. I couldn't find much documentation in Microsoft Excel to help me.

August 13th, 2007 In short in HSQLDB cached table sucks in terms of performance. To elaborate I was running a program which takes around 9 hours running on two medium sized cached tables (bigger one 163 MB).

March 12th, 2009 The line of a text is a big headache sometimes. If you work with text based documents, you will probably know the utility of a linebreak or a word-wrap.

August 25th, 2009 Does it requires hundreds on tools to convert Power Point (PPT) to PDF? Of course not, there are cost effective ways to achieve the same results. PDF is by and large the standard in distributing electronic documents.

May 27th, 2006 Many of us do not realize that MySQL's Timestamp is not the timestamp which PHP date() understands. In fact if you try to use MySQL timestamp directly in php date() function then you will get totally wrong dates.

May 24th, 2007 Overview There are two good choices for reading & writing Microsoft Excel Spreadsheet files from Java, in a platform independent way, - jexcelapi and Jakarta POI (HSSF). Both of them provide nice interface to access Excel data structure and even generate new spreadsheet.

August 30th, 2008 Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL. Use mdbtools utilities as described below: mdb-tables displays the list of tables in MS Access mdb-scheme export the MS Access schema to MySQL database.

February 16th, 2009 Downloading cool videos from YouTube or Google Video on you Mac. Now who doesn't need that? What you know is that these videos files are in FLV format.

July 6th, 2007 If you thought HTML tables were passe, think again. Show me how you can draw the same picture using only CSS; I will then use it on my blog :) I think HTML tables are as useful as ever in representing tabular / spreadsheet type data.

December 29th, 2008 There have been times when we needed a PDF file to edit. So we have converted that to a word document with the help of hundreds of free software across the internet.

June 12th, 2007 ANALYZE TABLE analyzes and stores the key distribution for a table. The MySQL query optimizer is the magic inside MySQL that decides which keys, if any, to use to in the query.

July 5th, 2007 I tested several file compression programs like zip, gzip, arj, bzip2, jar etc for compressing big files. The corpus constituted 5 POI generated Microsoft Excel documents totaling 298.8 MB.

July 31st, 2007 HSQLDB is a high performance RDBMS written in pure Java. It can be used as a in-memory database or regular file based database.

May 16th, 2007 Google AdSense allows exporting the data in CSV format, suitable for Microsoft Excel. It doesn't open in Mousepad, Gedit or even in normal spreadsheet programs under Linux.

February 10th, 2009 PDFs and MS Word - Anyone having a little relation with soft copies and computer documents knows about them. They are unparalleled in their service and thereby popular on their own.