How Can BoxLang Be Used for Data Processing Like Excel?

BoxLang
1

Hello

I’ve been exploring BoxLang and I like how it’s designed as a modern JVM language. :slightly_smiling_face:One thing I wonder is whether it can handle structured data tasks that people often do in Excel, like organizing, filtering, and transforming information. :innocent:

This could be useful for teams who want to move away from Excel macros and use a more scalable language. :innocent:

Does BoxLang have built-in support or libraries to read spreadsheets, process the data, and then export the results back into a file or database? :thinking: I also found Excel Interview questions which was quite helpful.

I checked the BoxLang documentation but didn’t find much about this topic, so I’d love to hear if anyone here has tried it in practice. :innocent:

Thank you !! :slightly_smiling_face:

2

Great question! I think eventually we’ll prollyk implement the spreadsheet module, but for now most people have just been using POI or another similar Java lib directly.

Here’s a blog post on doing some CSV parsing, and I assume this lib also work on Excel files

Here’s another library which I’m pretty sure works on Boxlang which is a POI wrapper

I need to reach out to Jullian and ask him to update the readme if Boxlang is now supported.

3

We have also two modules for our plus version in development

  1. BX-Csv
  2. Bx-spreadaheet

Both coming in weeks