Sample to read and write LibreOffice Calc fods file in JRuby 2021

sonota88/libreoffice-jruby-sample (tag: 20210102) https://github.com/sonota88/libreoffice-jruby-sample/tree/20210102

I wrote before ↓ This is an update and an operation report saying "It worked even at the beginning of 2021". Sample reading and writing LibreOffice Calc fods files in JRuby 2019

change point

--Upgrade of JRuby - 9.2.9.0 → 9.2.14.0 --Addition of functions: Sheet # used_row_index_max, Sheet # used_column_index_max --Get the maximum index of rows / columns in the range you are using --Changed to terminate using XDesktop.terminate () --Add sample files to repository --Docker compatible --Other minor changes, refactoring, etc.


I tried to support Docker. Based on Ubuntu 18.04.

If you make it Docker, you can see the necessary packages such as libreoffice-dev and JRE by looking at the Dockerfile, which is good.

#Build image
docker build -t my:libo-jruby .

#Run sample
docker run --rm -it -v "$(pwd):/root/work" my:libo-jruby \
  bash jruby.sh dump.rb sample.fods Sheet1

reference

Relation

-Sample 2021 reading and writing LibreOffice Calc fods files in Java -I tried to automate LibreOffice Calc with Ruby + PyCall.rb (Ubuntu 18.04) -Create a Docker image with LibreOffice Calc and run it headless

Recommended Posts

Sample to read and write LibreOffice Calc fods file in JRuby 2021
Sample to read and write LibreOffice Calc fods file in Java 2021
Sample to read and write LibreOffice Calc fods file in JRuby 2021
Sample to read and write LibreOffice Calc fods file in Java 2021
Let's introduce spock framework and write unit tests like test driven
Vuze plugin to write and enjoy
Read and generate QR code [Android]
Write keys and values in Ruby
Sample to unzip gz file in Java
<java> Read Zip file and convert directly to string
Gzip-compress byte array in Java and output to file
How to write comments in the schema definition file in GraphQL Java and reflect them in GraphQL and GraphQL Playground
[Rails5] japanMap link How to write parameters in js.erb file
Write DiscordBot to Spreadsheets Write in Ruby and run with Docker
How to read a file and treat it as standard input
Vuze plugin to write and enjoy
Read Java properties file in C #
[Rails] How to write in Japanese
Write keys and values in Ruby
Enable log output to both file and console using log4j in Eclipse.
Sample code to serialize and deserialize Java Enum enums and JSON in Jackson
The story of forgetting to close a file in Java and failing
How to read log4j configuration file in Java project summarized in jar file Memo