how to create Excel sheets automatically every day?

91
July 04, 2018, at 9:30 PM

I want to create Excel sheets with apache poi every day, while saving the other sheets if there are already some.

workbook.cloneSheet(0);
workbook.setSheetName(1, DateUtils.getDate());
    XSSFSheet sheet = workbook.getSheetAt(1);

I have a template on the first sheet, I would like to copy the template every day and then change the name of it (date of the day) then complete the template with data (which I already know how to do).

But I don't know how to automate that(new sheet every day), can you help me?

READ ALSO
Formatting a number as hexadecimal using MessageFormat in Java

Formatting a number as hexadecimal using MessageFormat in Java

How do I use MessageFormat to format a number in hexadecimal? I have an existing MessageFormat pattern, and the customer wants to change it from a decimal number to a three-digit hex numberIs this possible using MessageFormat? Or do I have to switch to a more powerful...

97
will data sent/received through a socket written in different languages be understood both ends?

will data sent/received through a socket written in different languages be understood both ends?

If i use a socket to connect two programs(c++ and java script using nodejs in my case) written in different languages

87
Expanding all collapsible sections on a web page

Expanding all collapsible sections on a web page

I am interested in finding out if there is a way to expand all the collapsible sections on a webpage simultaneouslyA relevant section on the webpage I am looking at looks like this:

19
How to create a jQuery function (a new jQuery method or plugin)?

How to create a jQuery function (a new jQuery method or plugin)?

I know that in JavaScript the syntax is as follows:

26