B4J Question Where are the XlUtils?

[B4JExplorer]

Hi,

I have the POI dependencies in the additional libraries folder. But I'm having some difficulty locating the base XLUtils library itself. The first google searches point to Python libraries.

If I try a google search like

XLUtils java download


, it returns sites like

https://www.qedgetech.com/download/XLUtils.java

and

xlutils documentation — xlutils 2.0.0 documentation

, but so far I don't see any site that specifically contains the XLUtils Jar files.

 

[DonManfred]

Search Results

www.b4x.com

1. Searchresult

 

[Erel]

If I try a google search like

Don't. The built-in search engine is better (when searching for B4X related material of course).

 

[B4JExplorer]

Of course I did the search on the forum first. But the main place where the link should be, is not there. At least not where I can see it. And I looked at a few other results, although not every one of them. And there's no link, at least not that I can see.

So e.g. the first result is here:

XLUtils / jPOI 5 - Read and write MS Excel workbooks

As written here, I plan to make it easier to read and write Excel workbooks. The solution is based on three components: - Apache POI - https://poi.apache.org/ Large open source project that provides APIs for Microsoft documents. Note that the files are accessed directly, it doesn't depend on the...

www.b4x.com

- Download POI dependencies and put them in the additional libraries folder: www.b4x.com/b4j/files/poi5_dependencies.zip
- Download XLUtils. It includes the updated jPOI. Put them in the additional libraries as well.

The above has the link to the dependencies, but no link to the XLUtils.

What am I doing wrong? Can someone either forward the specific page that has the link, or the link itself?

 

[B4JExplorer]

Ok, I just looked further down the page, where there are several attacments, separate from the poi link at the top.

I think this is the library, but it's not a jar. I'm not familiar with the b4xlib extension.

https://www.b4x.com/android/forum/attachments/xlutils-b4xlib.116603/

 

[B4JExplorer]

Ok, I tried just copying the .b4xlib file to the AdditionalLibraries folder where the poi and other libraries are.

I think everything's ok. The Example.zip doesn't finish compiling, because it's looking for something in the C:\PERSON~2\B4J\Share Files\ folder, which it can't find.

I tried searching for PERSON in the project, but the quick search box doesn't seem to accept any string. <Ctrl-F> opens the Quick Search box, but it doesn't accept any input.

Anyway, I should be able to tweak this to work with my spreadsheet, thanks.

 

[udg]

I'm not familiar with the b4xlib extension.

[new feature] b4xlib - a new type of library

As B4X matures, more and more reusable components are written in B4X directly. In most cases it is simpler to implement the logic in B4X directly and the code can be cross platform. Especially with the relatively new XUI library. Standard libraries will never be cross platform as they are...

www.b4x.com

Have a read; it's really powerful.

 

[B4JExplorer]

[new feature] b4xlib - a new type of library

As B4X matures, more and more reusable components are written in B4X directly. In most cases it is simpler to implement the logic in B4X directly and the code can be cross platform. Especially with the relatively new XUI library. Standard libraries will never be cross platform as they are...

www.b4x.com

Have a read; it's really powerful.

Thanks udg,

But I already read most of it. What I didn't catch the first time around was "b4x libraries appear like all other libraries in the Libraries tab."

Anyway, it's not that relevant to my problem, because XLUtils won't compile in console mode.

 

[B4JExplorer]

We're going to do this in Groovy. But let me provide a little context, for future developers looking to generate excel spreadsheets, and who are curious about the requirements.

I wrote a VBScript routine about a year ago, that takes in a .tsv tab delimited file ; converts it to xlsx ; does some formatting including a greenbar appearance and filters ; then emails the spreadsheet to a client from Monday through Friday. A batch file calls the vbscript, and the batch file is in a loop that runs before 7 every morning.

It's been working fine. Completely stable.

The problem is, that we want this to run on a server which does NOT contain Microsoft Office. The VBScript is dependent on the Excel.Application object which in turn is dependent on Excel, and so we're looking at alternatives that don't require it.

 

[Erel]

nyway, it's not that relevant to my problem, because XLUtils won't compile in console mode.

It is a bug. It should run in non-ui apps. It will be fixed in a few minutes.

 

[Erel]

Fixed in v2.06: https://www.b4x.com/android/forum/threads/xlutils-jpoi-5-read-and-write-ms-excel-workbooks.129969/

 

[B4JExplorer]

Fixed in v2.06: https://www.b4x.com/android/forum/threads/xlutils-jpoi-5-read-and-write-ms-excel-workbooks.129969/

Ah, ok. Thanks, champ.