All geek questions in one place

Saving various csv files as different sheets in one Excel workbook

In connection with this question , how to save many different csv files in one Excel workbook with one sheet per csv? I would like to know how to do this programmatically in Java.

+3
source share
3 answers

You will need a library to access Excel with Java. A Google search turned this:

http://j-integra.intrinsyc.com/support/com/doc/excel_example.html

An alternative is to use the Excel XML format, which appeared in Office 2003. As a result, you get an XML file, but you can open it in Excel and view different sheets.

http://www.javaworld.com/javaworld/jw-07-2004/jw-0712-officeml.html

+2
source

, CSV

, ( CSV , XLS.

+1

Take a look at Aspose products, I used them before while working with Excel, and they saved me a lot of headache and time. Excel has several quirks that can make importing and exporting tables difficult.

Aspose.Cells

0
source

Source: https://habr.com/ru/post/1698641/

More articles:


All Articles