Installing jxls

I'm using Eclipse.

If you need the functionaliy described below, you'll also need to have jxls-reader-1.0-RC-2.jar
in your classpath or in your project. Chances are you would not need it

In addition to Excel generation functionality jXLS also contains jxls-reader module which provides a great help if you need to parse Excel files created in a predefined format to pull in the data. jXLS-reader allows you to describe parsing rules in a simple XML and all the other work on reading Excel file and population of your Java objects will be done automatically.

I don't need the reader. Just need to create xls files with charts.

When I try the code on http://jxls.sourceforge.net/samples/chartsample.html,
I get an errors saying "Syntax error on token "add", = expected after this token" on line 2.

Please let me know if I have to post this as a different question.

This code is just a snippet - you need to put it within the class, etc.
Did you place it in a classwith main method .etc?

I did.

Perhaps, something like that:

public class TestJXL{
public TestJXL(){
List staff = new ArrayList();
				        staff.add(new Employee("Derek", 35, 3000, 0.30));
				        staff.add(new Employee("Elsa", 28, 1500, 0.15));
				        staff.add(new Employee("Oleg", 32, 2300, 0.25));
				        staff.add(new Employee("Neil", 34, 2500, 0.00));
				        staff.add(new Employee("Maria", 34, 1700, 0.15));
				        staff.add(new Employee("John", 35, 2800, 0.20));
				        staff.add(new Employee("Leonid", 29, 1700, 0.20));
				        Map beans = new HashMap();
				        beans.put("employee", staff);
				        XLSTransformer transformer = new XLSTransformer();
				        transformer.markAsFixedSizeCollection("employee");
				        transformer.transformXLS(templateFileName, beans, destFileName);
}
public static void main(String [] args){

new TestJXL();
}
}

Select allOpen in new window

Post your whole code, I'll have a look

Not sure why mine did not work. Yours does. Thanks!

Great!

Thanks all!

If possible, please answer this: https://www.experts-exchange.com/questions/27049585/Creating-charts-with-jxls.html