How To Read / Write Excel Spreadsheet From JavaMay 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.
Date Manipulation in Microsoft ExcelOctober 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.
Convert Microsoft Works Database (.wdb) to CSV or Excel Without Microsoft Works InstalledMay 20th, 2009 Microsoft Works comes with most of the windows based PC's for free. It is a basically an entry level office or home productivity software suite that includes word processor, spreadsheet and database.
Yet Another Microsoft Excel VulnerabilityJune 21st, 2006 While Microsoft developers are scrambling to patch a security hole in Excel, a hacker has now posted code that exploits a second vulnerability in the popular spreadsheet software. Microsoft says that criminals are not yet using this code in attacks, but the software could be used to run unauthorised programs on a PC, according to Marc Maiffret, chief hacking officer at security software vendor eEye Digital Security.
10 MS Excel Hacks and TricksFebruary 28th, 2009 There are millions of Microsoft Office Excel spreadsheets users who rarely care to look for the best side of it, I mean hacks. There are a wide range of functions performed on Microsoft Excel from calculations to analyzing data to integrating information, the list continues. With a fluent interface rich data visualization, and PivotTable views MS Excel is now easier to use.
Microsoft Confesses of Major Excel Vulnerability, Advises. February 25th, 2009 Microsoft confesses again. Though there is nothing to be ashamed of MS.
Free WordPress Plugin To Disable wlw_manifest & EditURI Link From WordPress Blog HeaderJune 29th, 2008 Newer versions of WordPress (2.3.1 and above) adds two extra lines to your blog header. They are:
You need them to use Windows Live Writer to write to your WordPress blog.
Google Spreadsheets Takes on Microsoft Excel With Online CollaborationJune 6th, 2006 Google released a limited test version of Web-based spreadsheet program to make it simple to edit and share lists and data online. It comes barely months after Google bought a small Silicon Valley company called Upstartle, creators of a Web-based word-processing program called Writely.
Top 10 alternatives to Microsoft ExcelMarch 24th, 2009 Microsoft Excel has almost monopolized every Windows PC to carry Microsoft Office Suite with it. There's no doubt that Excel is good, but you can't argue its an all powerful spreadsheet.
Microsoft, Nokia agree to bring big versions of Office programs to tiny smart phone screensAugust 12th, 2009 Microsoft to put Office programs on Nokia phonesSEATTLE — Microsoft is working with Nokia to put Office software and other programs on smart phones. The companies say people will be able to read, edit and create new Word, Excel, PowerPoint and OneNote programs on Nokia smart phones, which run an operating system called Symbian that competes with Microsoft Corp.'s own Windows Mobile.
Ngnix: Solution for Directory Resolution Problem in Virtual HostingJuly 9th, 2008 Nginx displays a peculiar but logical behavior when handling directories specified without the ending slash. For example you have a directory like http://www.example2.com/dir/.
MS Excel Tip: How to Paste Column Widths March 16th, 2009 I know if you work with spreadsheets and particularly Microsoft Excel, you must be annoyed with the column widths according to your liking. To copy paste cells, you can use Ctrl+C and Ctrl+V.
Microsoft opens Office 2010 for early testing, but keeps Web browser versions under wrapsJuly 13th, 2009 Microsoft opens early testing on Office 2010SEATTLE — Microsoft Corp. is giving a select group of technology-savvy testers an early peek at Office 2010, but it's still keeping Web-based versions of Word, Excel and its other go-to programs under wraps.
Convert PDF Tables to Excel FormatMay 19th, 2009 At times you need to reuse the table with tabulated data from PDF format. Simply, you can't work on the PDF tables as you can do with Microsoft Excel.
Free WordPress Plugin To Remove Generator Meta Tag / Version Information From WordPress BlogsJune 30th, 2008 WordPress, in recent versions, have forces the display of WordPress as the generator in meta tags along with the version information in the header of your WordPress blogs -. Unlike previous versions there is not easy way to remove it.
July 28th, 2005 at 5:11 pm
This works much better if you use the “Freeze Pane” function in the “Window” menu.
February 13th, 2006 at 2:09 am
This is not frozen header. This is split windows.
July 6th, 2006 at 1:34 pm
who the fuck cares what it is, it works.
December 18th, 2006 at 11:01 am
Freeze pane… Thank you, Jenne.
Angsuman Chakraborty made a bit of a mistake there, methinks.
January 30th, 2007 at 7:27 am
het werkt toch…
Bedankt..!!!
May 20th, 2008 at 8:13 am
LOL YOU BUNCH IF NERDS
January 21st, 2009 at 11:16 pm
[...] I did some searching on the Internet and came up with this: <<This URL has a solution: http://blog.taragana.com/index.php/a…crosoft-excel/ And I found these steps: Highlight the row under the row that you want to remain on top and go to [...]
March 9th, 2009 at 11:45 am
Nice. Freeze Panes (freeze top row in latest version of excel) - works a treat.
October 20th, 2009 at 5:18 pm
Thank you SO MUCH! I have been trying for quite some time to figure out how to do this! And your working was perfect!!