Excel data formatting automatically

Help Studio
, ,
1

Hi Team,

I have a scenario where I need one column of the Excel file to have only Text values. How can I set the Format of that particular column in the template file, so whenever we enter any data it should convert to Text automatically.

TIA

2

Hi @MEGHA_cs

Use Format Cell Activity for formatting the particular column

image
image655×648 16.9 KB

3

Thanks,

I want to set the format in template only by using any formula or something like that… Cannot change in code.
can you please help.

4

@MEGHA_cs,

Set the format of the column to text in excel manually.

While writing the data to the template use write cell.

Write range will overwrite the format.

Thanks,
Ashok :slightly_smiling_face:

5

@MEGHA_cs

Format the Columns directly in the Template manually or create the rule for particular column

6

Thanks,

But is there a way can we do this without doing any changes in the code.

7

Thanks,

But this is not working as we are using Write range

1 Like
8

@MEGHA_cs,

Yes, update the template only if your code already have write cell activity to write the data.

Thanks,
Ashok :slight_smile:

9

@MEGHA_cs,

You will require code change. No other option.

Thanks,
Ashok :slight_smile:

10

Hi @MEGHA_cs I have built a sample code , where the Columns in template file is Configured for specific datatypes, kindly go through it and let us know if it helped

Column_Datatype_Check.zip (23.0 KB)