Skip to main content

What can we help you with?

Search

Write Excel File

Ivan Kuznetsov
  • Updated

Description

This activity is used to write some data into an Excel file. It can be used for a wide variety of tasks when it is needed to save some structured data to a table, for example, when processing some business data. 

Studio Pro supports Microsoft Excel .xls and .xlsx file formats.

 

As of the 8.3 update, there are two ways of interacting with MS Excel - Microsoft Native and Generic. Navigate to the menu "Settings"  → "Microsoft activities" to choose a method.

Microsoft Native uses standard Microsoft methods to interact with the Excel application. It requires Excel to be installed on your computer and extends the capabilities of interacting with all Excel functionalities.
Generic does not require Excel to be installed and may have some Excel functionalities limitations.

 

Parameters

The first parameter here is Path which defines the Excel file you are going to modify. It is required.

 

mceclip0.png

Path parameter

 

The next one is Value. It defines what will be written to the Excel file. It is also required.

The Calculate a value option lets you form the value dynamically. Here is a usage example:

{
    "My List": [
        {
           "Country": "Russia",
           "Capital": "Moscow"
        },
        {
           "Country": "USA",
           "Capital": "Washington DC"
        }
    ]
}

"My List" is the table sheet name, "Country" and "Capital" are columns, "Russia", "USA", "Moscow" and "Washington DC" are the respective values that will be written to the columns.

 

mceclip1.png

An example of setting up the value using the Calculate a value option

 

This is how the result would look like.

 

mceclip3.png

The new data was written to the Excel file

 

The Save the previous step result can be used with the activities that return the contents of a table. For example, here we read a table and write its contents to the Excel file as shown in the example above.

 

mceclip1.png

Such a scheme can be used to copy the contents of one table to another. The Save the previous step result can be used in such cases

 

Excel Formulas

You can use this action to enter not only numeric or alphabetic data but also formulas for mathematical operations into Excel rows.

 

The Order in Formulas

The formulas you enter must be written on the same line as the data you want to enter in Excel. For example:

[“10”, “20”, “30”, “=SUM(A1:C1)”]

In this case, the values 10, 20, and 30 will be entered in cells A1, B1, and C1, respectively. Cell D1 will show the result of the formula, that is, the sum of these numbers.

 

Important: The formulas that you enter in Excel through ElectroNeek must be written in English only. Thus, you should use the formula=SUM(A1:C1)instead of=СУММ(А1:С1). Find the complete list of Excel formulas here.

 

Note. This activity adds information to Excel without formatting. 

Related articles