DevOps Articles

Excel UI With Java Flexibility: Merging Spreadsheet Data in Keikai

We want to analyze, compare, and use the full dataset that we have gathered. If the data have been gathered in separate sheet and tables, sometimes with duplicated entries, we need to be able to merge all of it into a simple easy-to-use table.

Keikai operates in a Java web server, so we will improve our workflow by delegating the data manipulation to this layer.

Since the spreadsheet format is great for tabular data, we will simply take the list of entries and write them one by one in a table for each of our merged datasets.

This is almost identical to the reading process, except instead of using .getCellValue() to retrieve data, we will use .setCellValue() to write data back to the sheet.