how to create excel file from HTML

Question

There are too many examples how to create EXCEL file, like this: create Excel with xPages

But I really need Excel xlsx format not xls. Just defining xlsx file extension and change content type doesn't help:

response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");

It seems like, lotus notes Domino server doesn't support new doc formats like xlsx — BSeitkazin
– BSeitkazin, Commented Jan 3, 2019 at 3:37
nope, your example about xPages, it is similar to JSF from Java World. xPages to generate files, uses Apache POI framework under the hood. JS code just interprets by the server — BSeitkazin
– BSeitkazin, Commented Jan 3, 2019 at 3:44
Take a look at Apache POI and XSSFWorkbook which is used to generate Excel spreadsheets in the xlsx format — Per Henrik Lausten
– Per Henrik Lausten, Commented Jan 3, 2019 at 7:11

stwissel · Accepted Answer · 2019-01-03 05:22:37Z

4

Vlad, Setting the content type to xls or xlsx has the same effect: it tells the browser to hand over to Excel. It still would send HTML that excel renders. It is up to the user to save as xlsx.

If you really need a ready made xlsx you need to create an XAgent that renders the binary xlsx format. The easiest way is Apache POI library, which is available for XPages through OpenNTF.

Check the samples there. They should do what you need.

answered Jan 3, 2019 at 5:22

stwissel

20.5k6 gold badges63 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to create excel file from HTML

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related