Create Excel File With Limited Libraries in Java

Question

I'm working in a framework that makes extensive use of excel documents, but the only imports it's using to do so are listed below:

java.io.*;
java.util.*;
java.util.regex.*;
java.util.zip.*;
javax.xml.parsers.*;
javax.xml.transform.*;
javax.xml.transform.dom.*;
javax.xml.transform.stream.*;
org.w3c.dom.*;

Because my workplace may not allow me to get the apache poi jar, how would I even begin to assemble an excel document using the above libraries?

The framework I'm working in is PRPC 7.x - most of the code it uses is proprietary and either hidden or incredibly inconvenient to get to, so it's rough trying to follow the breadcrumbs and mimic existing functionality.

score 1 · Answer 1 · answered May 31 '16 at 11:26

1

If you're not allowed to use apache you could still look at how they do it and mimic that code.

answered May 31 '16 at 11:26

sproketboy

8,967
18
65
95

That depends on why he is not allowed to use apache - if over licensing or patent worries then they might object to even reading the code – mmmmmm May 31 '16 at 11:58

score 1 · Accepted Answer · answered May 31 '16 at 11:54

There are two kinds of Excel files. The one is BIFF (Binary Interchange File Format) saved as *.xls files. The other is Office Open XML, a ZIPed directory structure containing XML files saved as *.xlsx files. The latter you can assemble using the showed libraries.

You can simply create a simple *.xlsx file using Excel. Then open this *.xlsx file using a ZIP software. Now you can have a look at the directory structure of that ZIP archive and at the content of the XML files in it.

Now the challenge is to create the needed XML files keeping the proper relationships between them and to pack them as an ZIP archive using the proper directory structure and then naming that ZIParchive *.xlsx.

Belive me, it is a challenge ;-).

https://en.wikipedia.org/wiki/Office_Open_XML

score 0 · Answer 3 · answered Jun 13 '16 at 07:05

0

go through their OOTB activtiy MSOParseExcel activtiy ... there they zip the excel file -> unzip it and then parse the data.

answered Jun 13 '16 at 07:05

nishanreads

93
5

score 0 · Answer 4 · edited Jun 20 '20 at 09:12

0

There are 2 OOTB activities using which we can generate the XLS. - ExportToExcel in @baseclass - ViewExportToExcel in Rule-Obj-HTML.

One of this should help, let me know if you need any more info.

RULESWARE

edited Jun 20 '20 at 09:12

Community

1
1

answered Jun 13 '16 at 16:53

Sai Tamada

1
1

Create Excel File With Limited Libraries in Java

4 Answers4

RULESWARE