Monthly ArchiveApril 2009
Web 17 Apr 2009 02:40 pm
Copying HTML Table Data into Excel
I’m currently using Excel XP (2003) and having been learning some tricks to get data out of HTML tables into an Excel document. I stumbled onto a cool feature last night…
Go to the Data menu > Import External Data > New Web Query. What you get is effectively a web browser that lets you enter a web page or even login and navigate to a page of your choice. The browser places little icons next to the tables in the web page, allowing you to copy that data across to your Excel spreadsheet. This option also comes up when you have justed tried to paste table data and get the little popup to do with formatting.
Also, if you’re interested, I see that in Firefox you can CTRL-Click on individual table cells and copy out the data from just those cells. I’m sure you’ve found like me that it can be tricky copying just the column or row of data you need from a web page, and this might help you one day.
Habanero 15 Apr 2009 10:31 am
Guji in Habanero Land #2: Diving into Code and Saving
The stage has been set and now its time to code… or is it? Habanero comes with Firestarter, a tool that will allow me to set up the Business objects and their relationships before generating code, user interfaces and tests. How cool is that?! Using the Firestarter tutorial as a guide I added Use Case Step, Use Case, Package and Project.
