Tag Archives: excel

Daily del.icio.us for January 9th

Posted on by
  • enunciate – Enunciate is a Web service deployment framework. It is not another Web service stack implementation. Rather, Enunciate leverages existing Web service technologies to provide a mechanism to build, package, deploy, and to clearly, accurately deliver your We
  • Ryan Heaton’s Blog: Web Service Programming for the Masses, Part I: Developing the Web Service API – This is the first part of a tutorial will walk you through developing a Web service API that could meet the requirements of all of the above-mentioned use cases. For the sake of clarity and brevity, we’ll keep the operations simple, but by the time we’re
  • Bob Rhubart’s Blog: The SOA Governance Prescription – A significant part of getting your SOA to do what it’s supposed to do is getting the people involved in the SOA to do what they’re supposed to do
  • Pinaki Poddar’s Blog: Slice: OpenJPA for Distributed Databases – Slice is a OpenJPA plug-in for horizontally-partitioned, distributed databases. As distributed databases are being increasingly common in enterprise IT ecosystem, I considered extending OpenJPA to transact against a set of databases instead of a a single
  • Top 10 SQL Server Integration Services (SSIS) and DTS tips – Whether you plan to migrate SQL Server Data Transformation Services (DTS) packages to SQL Server Integration Services (SSIS) or run DTS packages in SQL Server 2005, this expert advice can help
  • How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server – SQL Server Central – In this article, I will show you how to create a new Excel output file and populate the file with discrete spreadsheets containing specific data from a database. We will Integration Services for the task
  • Application Development Trends – SpringSource Offers Spring.NET 1.1 – SpringSource is offering the final release of Spring.NET 1.1. Spring.NET 1.1 supports the ASP.NET Framework for Web development. It enables dependency injection for pages, controls, modules and providers
  • InfoQ: Bruce Johnson discusses Google Web Toolkit – Google Web Toolkit (GWT) tech lead Bruce Johnson discusses the design of GWT, how GWT converts Java into JavaScript, community involvement with GWT, new features in GWT 1.4, and the philosophy behind GWT.
  • Book Review: Google Web Toolkit Applications – Google Web Toolkit, by Ryan Dewsbury, is an excellent book for those looking to use GWT to good advantage, covering most areas of GWT functionality in exceptional detail. It covers software engineering, server integration, custom component composition, CS
  • Adobe – Developer Center : Using BEA Workshop Studio and Java to create Flex-based RIAs – In this tutorial, I walk you through the steps to creating an RIA using Java for the back-end business logic and Flex for the front-end view of the application. I will use the BEA Workshop Studio (Flex Bundle) to create a simple Java mid-tier and a simple
  • smarturls-s2 – Google Code – SmartURLs-S2 is a Struts 2 plugin that provides a rich set of convention based handling for web applications. In addition, it also provides a component framework for developing web application components in separate codebases and the deploying them into a
  • Building Struts 2 Apps Without XML Gluecode – In this article, we jettison XML gluecode for “convention over configuration”. Using the SmartURLs plugin for Struts 2, we can autowire Action classes to page templates with search-engine-optimized URIs.
  • Embedding Flickr Photos – In this article, I’ll explain how to fetch data from Flickr using a proxy client library and displaying the data in a Visual Web Application page.
  • Atlassian Developer Blog – How to build an Atlassian plugin – There’s a single command that will download Tomcat, install Confluence or JIRA, start them up, load sample data, then install your plugin for testing. And once you’ve started the application once, you can just leave it running while you uninstall and rein

Daily del.icio.us for Dec 03, 2007 through Dec 04, 2007

Posted on by
  • Ext JS LiveGrid Component – The Ext JS LiveGrid Component is a user extension that’s build upon the wonderful Ext JS Framework. The component allows to read chunks of data from an underlying storage (common use case: a database) without the need of paging. Means: You can virtually d
  • Ext JS Blog – » Ext 2.0 Final Released – The Ext team is proud to announce that the official release of Ext v2.0 is available for download. Ext 2.0 is a dramatic step forward from all previous versions of Ext, providing increased performance, ease of configurations, flexibility and UI capabiliti
  • Adobe Debuts Flash Media Server 3 – Slashes Price – The Flash Media Interactive Server includes the debut of streaming HD video. FMS3 will offer H.264 video streaming, as well as support for High Efficiency AAC (HE-AAC) audio that can be streamed to Flash player, AIR applications, or Adobe’s Media Player a
  • NetBeans Magazine – To coincide with the launch of 6.0, this latest issue of NetBeans Magazine features 62 pages of in-depth articles. NetBeans IDE 6.0 features Ruby/JRuby/Ruby on Rails support, enhancements for improved Swing development, a new Visual Game Designer, updated
  • Setting up a GWT project in IntelliJ IDEA 7 – IntelliJ IDEA 7 has built in support (in the form of a bundled plugin) for GWT projects. This tutorial will walk you through the steps of creating a GWT project in IDEA 7.
  • Marc’s Musings: Spreadsheet Component – I’m working on a spreadsheet like component for AgileAgenda that I might end up turning into a general-purpose flex component at some point.
  • Tech Per: 10 Tips on JPA Domain Modelling – This post is a collection of tips on what I think is good advice, when domain modelling in Java with JPA as ORM mapping technology.
  • Scal v0.2 Documentation | Scal – Scal is a simple, javascript calendar/date picker based on the Prototype js library
  • Ext JS Blog – » Extended Filtering Using the Grid Filter Plugin – Steve Skrla has created the Grid Filter plugin which has quickly become one of the most popular user extensions in the Ext community
  • Datejs – A JavaScript Date Library – Datejs is an open-source JavaScript Date Library with a ton of syntactic sugar

Daily del.icio.us for Jul 30, 2007 through Aug 03, 2007

Posted on by
  • InfoQ: System Integration Testing Using Spring – When it comes to system integration testing Spring adds real value. In this session, Rod Johnson discusses: integration testing and the support that Spring provides for it, issues around testing the persistence layer, testing web applications.
  • InfoQ: BEA and Oracle incorporate Sun’s Project Tango – In a recent article, Sun’s director for SOA products, Kevin Schmidt mentioned the fact that both Oracle and BEA have incorporated Sun’s Web Services stack, Project Tango. Tango is MS .NET 3.0 interop
  • InfoQ: Using Java to Crack Office 2007 – With Office 2007, no third-party libraries are necessary-a Java application can now read and write any Office 2007 document, because Office 2007 documents are now nothing more than ZIP files of XML documents known as the OpenXML
  • Welcome to jXLS – jXLS is small and easy-to-use Java library for generating Excel files using XLS templates. Also jXLS can be used to read XLS files and populate Java beans with spreadsheet data according to XML configuration file
  • How To Read / Write Excel Spreadsheet From Java – Both JExcelAPI and Jakarta POI (HSSF) are open source software to read & write data from / to Excel spreadsheet even on non-Microsoft platforms. In my tests HSSF came out to be the clear leader and recommended solution because of robustness and features.
  • Eloquent JavaScript – Eloquent JavaScript is a hyper-book providing a comprehensive introduction to the JavaScript programming language. Apart from a bookful of text, it contains plenty of example programs, and an environment to try them out and play with them.
  • http://www.ietf.org/internet-drafts/draft-ietf-atompub-protocol-17.txt – The Atom Publishing Protocol (APP) is an application-level protocol for publishing and editing Web resources. The protocol is based on HTTP transfer of Atom-formatted representations. The Atom format is documented in the Atom Syndication Format.
  • F1 News – Grandprix.com – One of the big problems with the ongoing Stepneygate Affair is that there is a huge amount of hearsay, but not a great deal of fact
  • YUI 2.3.0: Six New Components and a Prettier Face » Yahoo! User Interface Blog – We’re pleased to announce the release of YUI version 2.3.0. This release features six new additions to the library as well as a new skinning architecture and a new visual treatment for most of our UI controls – plus 250 enhancements and bug fixes
  • Greg the Architect : Episodes – Find out what happens when Greg tries to swallow three different SOA pitches in one day. Will he save the day, or will Greg have to chuck the project?
  • Dr. Dobb’s | Java Message Service | July 2, 2007 – SOAP-based web-service development continues to grow, and uses XML and HTTP to remove the implementation details from remote procedure calls. But while SOAP has broken new ground in distributed computing, message-oriented middleware such as the Java Messa
  • Plans for the Rich Web Application Backplane – Both mashups and Ajax are now firmly entrenched in the Web landscape. Put them together and you have the makings for Rich Web applications. This article explains the Rich Web Application Backplane, currently a W3C Note, which is designed to bring standard
  • 10 things I learned about using Hibernate/JPA successfully by SpencerUresk – I decided to share a few things I learned about using Hibernate/JPA in a large project with a complicated database setup
  • OpenJPA no longer requires bytecode processing – Historically, OpenJPA required that you either run a post-compilation tool or run your application with a javaagent. The latest build of OpenJPA removes this restriction by providing various levels of support for unenhanced classes.

Daily del.icio.us for Jul 29, 2007 through Jul 30, 2007

Posted on by

Daily del.icio.us for May 30, 2007 through May 31, 2007

Posted on by

Google hits a home run with Google Spreadsheet

Posted on by

I just got my invite to play with the latest offering from Google, the Google Spreadsheets and my initial reaction after playing with it for the past hour is incredibly positive. Unlike some of the duds Google has launched recently, this is a pretty nice, robust and useful offering.

I started off by creating a simple spreadsheet and tried out some simple formulas and it worked – I shouldn’t be surprised but I was. Tying in =(a1 – a2) actually worked and that’s pretty cool. Here are 2 simple screen-shots from my playing with the formula.

google-spreadsheet1

After I hit enter, the results are plopped into the cell.

google-spreadsheet2

The other neat thing was that the formula was saved in my document and the numbers updated when I changed one of the columns involved in the formula. I know it sounds pretty simple but it’s great to have a web application behave like a fat-client application.

Google Spreadsheets have a ton of other formulas that you can apply and it seems to offer all the functionality I use out of Excel. The collaborative feature also has great possibilities but that’s limited to people who have Google Accounts only at this point. Weird but I guess that’s something that they are working on to include anyone with an email address.

google-spreadsheet3

A couple of other nice features include options to export to Excel (xls), CSV and HTML. The Excel export works great and I was able to open up the exported spreadsheet in Excel as you would expect. The HTML export also works but the generated HTML does not validate which seemed odd but I know this is beta [insert your own joke here] software.

In addition to creating new spreadsheets, you can import existing Excel documents and this application did a great job of importing the spreadsheet with a ton of data and some complex formulas. I am very impressed with the overall functionality and overall usability of this application. Would I dump Excel to start using this? No – The accessibility and collaboration features are great but there are privacy concerns that would not make me comfortable using this application with some personal and confidential data. Maybe when GDrive launches, we will feel more comfortable about how data is encrypted in storage, segregated from other users and protected from hackers. Till then, I’m sticking with Excel for my rudimentary needs.