Store data in Excel or DataTable to copy/replace in a Word file (more 255 characters)

Help Studio
, ,
1

Hello,

I want to store data in an Excel file or in a DataTable, and then replace same text (example: [text]) into a Word file.

Most of these data are longer then 255 characters, how can I do it?

Thanks,
Diego

2

@495713
ensure at least that the column length is configured properly.

Build DataTable edit column:
grafik

Add Data Column:
grafik

1 Like
3

Hi @ppr,

I will try your way and let you know…

and, what if I would like to store all my data in an Excel file?
Do you know a way to make it works in this alternative way?

Thanks,
Diego

4

@495713
May I ask you to give us a detail description of your scenario and based on this we can work out a solution adressing individually your case. Thanks

1 Like
5

Hi @ppr,
my final goal is to get a contract document in a Word format.

I receive an Excel template filled in by a Manager and then, based on the different kind of data I start the Onboarding.
Different kind of Onbarding has specific paragraphs in a specific order (different kind of contract have some paragraphs in common and some different).

I already know how to read the data from the Excel file (creating a Data Table of the excel range and then I use a Lookup activity).
But I need a way to store all the possibile paragraphs I am then thinking to organize with a serie of “if” activities.

Thanks,
Diego