Documents

Export to XLSX

6min
procesio allows you to work with several types of files, one of the most popular files used within the business world is xlsx, a microsoft excel open xml format spreadsheet file scenario the user wishes to use the process to export data in the form a excel file how to https //docs procesio com/duplicate identification#lm how to https //docs procesio com/list filter simple#oy how to https //docs procesio com/list filter#s9 how to step 1 create a new process and give it a name step 2 add the needed variables for the process used in our example we will require the following variables <%data%> <%data%> the input list\<object> variable that will store the json <%export%> <%export%> the output variable of type file step 3 click the export to xlsx action and add the following configuration object to export will hold the <%data%> <%data%> variable column delimiter will ask for the type of delimiter used in the newly created file export header the checkbox gives us the option to also export the headers file name will be the name of the exported file, the extension will be added by procesio output file will contain the fil variable we created in step 2 the file name should be the same as the output file name check the screenshot below step 4 save , validate and run the process step 5 you will be prompted to add the data for our input variable the input will be of type json click run \[{ "id" 1, "first name" "james", "last name" "godain", "email" "jgodain0\@liveinternet ru", "gender" "male" }, { "id" 2, "first name" "ansel", "last name" "bard", "email" "abard1\@go com", "gender" "female" }, { "id" 3, "first name" "sutherland", "last name" "oriel", "email" "soriel2\@google cn", "gender" "male" }, { "id" 4, "first name" "kim", "last name" "mackelworth", "email" "kmackelworth3\@europa eu", "gender" "female" }, { "id" 5, "first name" "evelyn", "last name" "folliott", "email" "efolliott4\@icio us", "gender" "male" }] step 6 to verify the process click check instance step 7 in the output section we can see the <%export%> <%export%> variable and by clicking the export button located in the bottom right of the above screenshot we can download the data in xlsx format