Excel « Graphics Desktop « Java Articles

1.	Build Deploy
2.	Class
3.	Core Library
4.	Data Types
5.	Database JDBC
6.	Design
7.	Development
8.	File Input Output
9.	Graphics Desktop
10.	J2EE Enterprise
11.	J2ME Wireless
12.	JVM
13.	Language
14.	Library Product
15.	Network
16.	Security
17.	SOA Web Services
18.	Test
19.	Web Development
20.	XML

Java Articles » Graphics Desktop » Excel

1. The Java-Excel solution revisited

Second, you can also consider importing the spreadsheet into Access, MS SQL, or another full-featured database. In my opinion, this represents the more practical solution compared to reading an Excel file directly through JDBC.

2. It's Excel-lent

Yes, you can read Microsoft Excel files from Java. Microsoft provides an ODBC driver for Excel, thus allowing you to use JDBC and the Sun JDBC-ODBC driver to read Excel files.

3. It's POI-fect

n "It's Excel-lent" (JavaWorld, June 2001) I showed how to read and write to Microsoft Excel spreadsheet documents using Java's JDBC (Java Database Connectivity). As a follow-up, in "The Java-Excel Solution Revisited" (JavaWorld, August 2001) I answered additional questions and presented a few JDBC alternatives.

4. Hacking Excel, Part 1

Editor's note: Excel Hacks offers a collection of "100 Industrial-Strength Tips and Tools" that even the most experienced Excel users may never have thought of doing. Take today's hack, for example. Excel's Chart Wizard doesn't offer a speedometer chart, so that's the end of the road, right? Not to Andy Pope, who contributed this hack to the book. Here's how to create a "speedo" chart and have fun while you're doing it. Who says you can't be creative with Excel?!

5. Reading and Writing Excel Files with POI

Files are modified by reading and rewriting. Example 3 takes in an Excel file and changes the values based on rules specified in a .property file.

6. Hacking Excel, Part 2

Note: Excel 97 doesn't provide the option of searching the entire workbook, but you can search all worksheets in a workbook by grouping them. You do this by right-clicking any Sheet Name tab and choosing Select All Sheets. In later versions of Excel, Find… and Replace… provide the option of searching within the sheet or workbook.

7. Performing Web Queries in Excel 2003

Editor's note: It may not seem as though much has changed in Excel 2003, but if you're an Excel VBA programmer, you will want to know about some new programming features. Excel 2003 Programming: A Developer's Notebook will get you up to speed quickly on working with lists and XML data, securing Excel applications, using Visual Studio Tools for Office, collecting data with Infopath, and more--in the form of hands-on labs that address specific programming problems. This sample lab on performing web queries offers a glimpse at the sort of projects you'll find in the book, which is due for release in late August 2004.

8. Writing Excel Files with Apache POI HSSF

Recently, you explored how users could provide data to Java applications using Excel workbooks in "Reading Excel Files with Apache POI HSSF." Now, look at how you can give data to users in the same format.

9. Reading Excel Files with Apache POI HSSF

Providing non-technical users the ability to submit data in the form of Microsoft Excel files is a win-win solution for both developers and users. The POI project makes this a practical approach for any J2EE web project with their HSSF and XSSF APIs.

10. Useful Resource: Software Engineering Tools from Excel

February 15, 2002 -- This week, our favorite resource from our Resources and Downloads directories is Excel Software's Linux, Macintosh, and Windows Tools, a slew of software models, design methods, and CASE tools.