Creating And Styling Excel Document
  • Updated on 24 Dec 2014
  • 4 minutes to read
  • Print
  • Dark
    Light

Creating And Styling Excel Document

  • Print
  • Dark
    Light

This tutorial demonstrates how to Create an Excel Document in the Flow . Additionally, this tutorial demonstrates how to apply different Styles to this Excel Document . Create New Excel File step can be found underData > List > Excel and CSV category in the ToolBox in the Flow Designer . Different Style Steps that can be applied to the Excel Document located in the Data > List > Excel and CSV > Styling category in the ToolBox .

Example:
We begin in the Designer Folder with clicking Create Flow button on the Folder Actions panel.
create-flow...454545.jpg

Next, we name our Flow and click Create to proceed to the Flow Designer.
2018-07-13_134823.jpg

In theFlow Designer we use Flow Designer Wizard to add Create New Excel File step from All Steps [Catalog] > Integration > Excel and CSV category.
2018-07-13_134952.jpg

Next, we add Set Values In Row step from the same category in the Flow Designer Wizard.
2018-07-13_135032.jpg

Then, we select Create New Excel File step on the workspace and configure it using Inputs Layer. We select Constant Mapping type for fileName and sheetName fields and provide these fields with desirable Values .
2018-07-13_135148.jpg

In the properties panel we map data to the Set Values in Row as follows. We use the Excel File that was created in the First Step in our Flow as an input field. Other fields defined Constant . Then, we click Ok to save and close Mapping Editor.
2018-07-13_135427.jpg

Back in the Flow Designer we add Set Values In Column step from All Steps [Catalog] > Integration > Excel and CSV category.
2018-07-13_135543.jpg

Next, in the properties panel we map data for this step in the similar manner we mapped data forSet Values In Row step.
2018-07-13_135737.jpg

Next we are going to apply some styles for our Excel Document. We expand All Steps [Catalog] > Integration > Excel and CSV > Styling category in the Flow Designer Wizard and add Increase Font Size step to our Flow .
2018-07-13_135853.jpg

We open Mapping Editor for this step.
2018-07-13_135952.jpg

In the Mapping Editor we connect file field to the Excel File that was created in the First step in our Flow . We define other fields Constant and provide them with desirable Values . Click Ok to close and save Mapping Editor.
2018-07-13_140211.jpg

Next, we add Set Background Color step from All Steps [Catalog] > Data > List > Excel and CSV > Styling category.
2018-07-13_140253.jpg

And map data in the following manner using Mapping Editor.
2018-07-13_140357.jpg

From the same Styling category, we add Set Bold step.
2018-07-13_140429.jpg

Then, we call Mapping Editor a nd map data for this step.
2018-07-13_140518.jpg

Finally, we add Set Font Color step from Styling category.
2018-07-13_140618.jpg

Open Mapping Editor a nd map data.
2018-07-13_140710.jpg

Every time we make changes to the Excel File in the Flow we need to update it. For this purposes we add Update File With Data step from All Steps [Catalog] > Integrations > Excel and CSV category in the Flow Designer Wizard.
2018-07-13_140756.jpg

We open Mapping Editor for this step and map data in the following manner… We use the Excel File that was created in the First step in our Flow as an input field to this step. When finished, we save and close Mapping Editor.
2018-07-13_140838.jpg

Lastly, we add Download File Form step from Flows, Rules, Forms and Reports > Forms[Interaction] > [Parent Folder] > Using Run Flow for CSV Step category in the Flow Designer Wizard.
2018-07-13_140914.jpg

This Form was predesigned for this tutorial. It simply has an Action Button control andFile Download control. It was designed for user to be able to download the Excel Document that we have created.
2018-07-13_133338.jpg

Next, we select this Form step on the workspace and configure data mapping using Step Information Layer. For Download File Mapping type we choose Select Value . Then, using Value Picker we select the File that we have created in the First Step in this Flow .
2018-07-13_141204.jpg

We connect all steps in the Flow as follows… This completes our Flow . We can clickDebug link from the Top panel of the Flow Designer to test our Flow .
2018-07-13_141257.jpg

When our Form opens in the Debugger we clickDownload File.
2018-07-13_141358.jpg

We confirm that we want to save the File . Then, we select the location for our File , Name it and Save .
And we click Done button on the Form in the Debugger to close the Form .
Flow Diagram in the Debugger indicates that our Flow ran to the End Step with no errors.
Next, we can locate and open Excel Document to confirm that all the styles applied as we have designed.

2016-12-12_161256.png

Was this article helpful?