Is there a way to achieve this?

[Kokecena]

Hello, first of all, excellent library, I just found it and I am using it for an internal project at my work.

I am trying to make an excel document with different spreadsheets for all the days of the month, using this format

here's my template:

I was guided by the example provided in the each section.
and I would like to achieve the spreadsheets by date, as shown in the multisheet section

but I can't figure out how to generate it, my information is like this

List<Employees>

Employees has List<Employee> cachedEmployees and String date

and in Employee there are all the attributes that are seen in the template

Following the example I assumed it would be something like

data.put("employees",lists.stream().map(Employees::getCachedEmployees).toList());
data.put("titleSheet",lists.stream().map(Employee::getDate).toList());

but obviously it doesn't work, so it generated an excel for each day, it works for me for now, but I would like to know if it is possible to achieve what I mention.

this is my code

thanks and sorry for my bad english :p

[SoltauFintel]

The multisheet attribute in jx:each is missing. jx:each(multisheet="sheetnames" ...)

data.put("sheetnames", <List with "1", "2", "3", ... "31">);

[Kokecena]

I really appreciate that you answered me.

And yes, that is what I had understood from the documentation for multi-spreadsheets and if I did it, here is the code.

This is the result I expected

Instead what I got was this xD

This is my "Empleados" class, basically the employee incidents are received from the repository and a list of "Empleados" is created that contains the list of "Empleado" and the date attribute of the incidents of the day

I was wondering how I could achieve this because the class I use to contain the employees is the same list, that's why my solution, the one I put at the beginning, was to generate an excel file for each day and my goal was to fill everything in a single excel

Sorry if I was very explicit, I just felt that I didn't explain very well what I wanted to achieve.

In any case, if it is not possible, there is no problem.

Thank you for your help and attention

[SoltauFintel]

Is there a getArea() ?

[SoltauFintel]

I can probably only help if you provide a Github repository with an example.

Maybe I don't even understand what the problem is.

[SoltauFintel]

Try to change "private Area area" to "private String area" + getter. I'm not sure if Area works. I use JXLS with maps and not with classes.

[SoltauFintel]

One thing I forgot to mention: please remove sheetStreaming="true". I recommend that newbies don't use any optimization until everything works.