Saturday 26 October 2019

Creating a web app in node to host and deliver misc Excel Reports

Hey, what's up? At my work, we currently use a Grails/Groovy project to host a website where managers and other employees can log in and download reports and if they wish, subscribe to reports that are outputted into Excel. Outputting the raw data is easy enough, but sometimes we get report quests that pretty much simulate what Pivot Tables do in Excel. This is where it is currently tedious as we are grouping the raw data into hashmaps then outputting that data in a similar format using nested key:value pairs. We currently have to keep track of row indexes and column indexes and it can quickly become confusing.We are leaning toward using Node for the future and I was reading a little about excel4node and xlsx. My question is what do you guys think about moving toward Node and also if there is any library or framework I can use (maybe excel4node?) that could make pivot tables easier to handle and output. Sorry if this is confusing as I am pretty new to the project. Thanks.

Submitted October 26, 2019 at 08:37PM by shevaneltaketwo

No comments:

Post a Comment