writing to a excel file from java program

[priyankabhar]

Hi,

I want to create and write to a excel file from a java program. I found a tutorial online and wrote a java file as under:

import java.io.File;
import java.util.Date;
import jxl.*;
import jxl.write.*;

public class jExcel{

	WriteableWorkbok workbook = Workbok.createWorkbook(new File("output.xls"));

	public static void main(String args[]){
		WriteableSheet sheet = workbook.createSheet("First Sheett",0);

		Label label = new Label(0,2,"A label record");
		sheet.addCell(label);

		Number number = new Number(3,4,3.1459);
		sheet.addCell(number);

		workbook.write();
		workbook.close();
	}
}

But when I compile this file, I get errors telling that package jxl does not exists and so on. Do I need to download it ? I am really new to it but I need to do the job. Please give some ideas.

Thanks,
Priyanka

[mary]

You can download from here
SourceForge.net: Files

[Cortexiphan]

When I follow the link, and I select JexcelAPI it shows me several different versions.

Do I just download the newest one?

[ozzyman]

I'd just like to point out that any package NOT starting with one of these:
java.
javax.

is a custom/community package i.e. not standard and thats why you will need to download them yourself

also its usually best to download the latest and most stable version. look for user feedback and if the latest version doesnt have any serious bugs then you should use that one.

[only_java]

For creating .xls files from java. One of the good API is jXl API.
You can find more details from following URL
JExcelApi

[basavaraj4375]

Can someone please tell what is the equivalent for Label in Apache Poi???


Thanks,
Basavaraj

[Tolls]

Aren't they just Cells with a cell type of CELL_TYPE_STRING?