Apply Format to all Excel File in the Folder

Help Studio
, ,
1

Hi, Is there a way I can apply a specific format/ style to all of the excel?

image
image1190×574 43.9 KB

2

Hi @raisonne, you can record a macro for your need in one of the excels and use that script across all your files. Below are for your reference.

3

You can use Format Cells if you are using Modern Excel Activity

It would do that to all files, if used in a for each loop as example.
If you can share more details about your workflow, we can try to help you in a more specific way.

4

I’m using this
image
to generate these csv files
image

5

Where do you get your item.Key & Value from and are they formatted correctly?

Is your goal only to input a datatable and format it and output it like shown in your initial screenshots?
There are probably quite a few different approaches, the one I’d try are:

Approach 1: Use Modern Excel Activity;

  • Use Excel File and in it’s scope:
  • Format Cells (for Header and Columns)
  • Write DT to Excel

Approach 2:

  • Build DT as .xlsx Template File with Bold Headers like in your Screenshot 2
  • Write specific Data to that without adding the Header