This means that we don‘ t have any version of Excel on the platform, because Excel does not run on Linux. The first thing that was immediately evident was that it is on Linux.

The automation would entail the process of Excel file creation, calculation of the formulas and saving the files on the client side.Ī t aioneers we use Databricks for the automation of data science processes, and therefore we wanted to do the automation of Excel file creation on Databricks.ĭatabricks, however, has some additional challenges that are specific to the platform. As for some customers there are lots of different departmens receiving these types of files, we need to automate this process of using Excel and VBA (the programming language in Excel), because doing it manually would take too long. Taking into account that we want to build some kind of a product, we actually need to automate the process of Excel file creation, calculation of the formulas and saving the files on the client side. On top of this, we can also use different styles of formatting, colors and visualizations in Excel, so that it looks better and makes the data easier to understand for our clients. A benefit Excel has over CSV is that it has a user interface and you do not need to spend a lot time developing. Most of us already have it installed on our computer, which means no additional solutions or licenses have to be bought. This can for instance be information on different SKUs, such as how long they have been in stock, how they are selling, and so on.įor our customers, it may be easier to receive this data in Excel, as excel is a tool a lot of people are familiar with. On a weekly basis, we exchange large amounts of data with our clients.

Openoffice excel recalculate