Excel: How to sort a range?

Hello, all. I have a bit of a problem.

I'm using Eclipse to make up a project which involves sorting a certain range in an excel file. I am using JXL and JExcel. I have this snippet:

import java.io.File;
import java.io.IOException;
import java.util.Locale;

import jxl.*;
import jxl.format.UnderlineStyle;
import jxl.write.Formula;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableCell;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
import jxl.Cell;
import jxl.CellType;
import jxl.Sheet;
import jxl.Workbook;
import java.util.Date;
import jxl.read.biff.BiffException;
import com.jniwrapper.win32.jexcel.*;

public void sort (WritableSheet sheet) throws ExcelException{
Application application = new Application();
File xlsFile = new File("C:\\Workbook.xls");
Workbook workbook = application.openWorkbook(xlsFile, true, "password");
}

And then I get the error of "Type mismatch: Cannot convert Workbook to Workbook"

I am using the tutorial as shown in this page, but even if I do it word-by-word, I can't seem to get it right.

JExcel Programmer's Guide

A solution would be most appreciated.

What is Application?
What class does openWorkbook return?

According to the link...

------------

Chapter 4. Excel Automation Basics

All these classes reside in the com.jniwrapper.win32.jexcel package.
4.1. Creating a New Application

Your work with Excel starts with the creation of a new Excel application. The JExcel library includes the Application class that represents an Excel application and provides related functionality. A new application is created by calling the Application constructor:

Application application = new Application();

-----------

I'm really a newbie about this, so perhaps you could help explain? Help is much appreciated.

So what class does openWorkbook return?

On top of that I've never used that architecture. I've only ever read in and written to a Sheet. I've never used Application.

Right, looking up the API for it, you are using two different things. You should either be using the Application side of things (which is intended by the looks of it for doing "general Excel application tasks"), or using jxl, which is for reading and writing Excel files.

According to the link you showed, openWorkbook would return an opened workbook...

Other than that, I cannot check because at the last line, I always get the error I mentioned when I try to save.

The link I posted goes to the API for Application.
openWorkbook() returns a com.jniwrapper.win32.jexcel Workbook, and not a jxl.Workbook. This is what I mean by the two packages not looking (to me) like they were intended to work together.

ETA: You want the former, if you are working through that tutorial...since it's about JExcel and mimicing Excel functionality in Swing. Get rid of the jxl imports.

So, how do I cast it to a com.jniwrapper.win32.jexcel Workbook? I'd appreciate it if you could help me. I'm not quite the expert. Thanks.

You can't.
Don't mix the two.
As the intro for Chapter 4 says:

Quote:

---

This chapter discusses the functionality of the following JExcel classes:

* Application
* Workbook
* Worksheet
* Window

All these classes reside in the com.jniwrapper.win32.jexcel package.

---

Do not use the jxl stuff.

So I have to revamp my code with using JExcel only if I want to do it?

Well, you do have two different frameworks here.
One intended to mimic Excel as a Swing component, and the other for reading and writing Excel files. I have no idea exactly which one you want to work with, but a JExcel Workbook is not a jxl Workbook.