Convert text file into excel using studio x

Help StudioX
,
1

hi, anyone can help me with workflow on how to convert text file into excel using studio x community.

2

Hi @Nur_Amin
You can
Use “Read text file” to get data as String
Use "Generate data " to convert String to Data table
Use "Write range " to write data table to Excel file
Flow Image

image
image1493×831 38.4 KB

Hope it help
Regards,
LNV

3

Hi @Nur_Amin

To convert the text to datatable and write to excel. Follow the below process.
=> Read Text File" activity: This will read the content of the text file. Output - String Variable

=> “Generate Data Table” activity: This will create a data table to store the text data - output - Datatable Variable

=>“Excel Application Scope” activity: This will open an Excel instance to write the data.
“Write Range” activity: This will write the data table to an Excel file. Output - Excel file

Note - In the generate datatable activity you have to give the sample text and you can preview how the text is extracting as datatable. Here based on your requirements you can configure things.

Hope it helps!!

4

@Nur_Amin

Use “read text file” to read the data in a string variable
Use “Generate datatable activity” Pass the string based on your data specify the format of the data you want to store in the datatable
Use Write range activity.

5

Hi @rlgandu ,
Right, activity "Read text file " has output is String variable
Need convert to data table by “Generate data table”
then write back Excel file by “Write range”
Regards,
LNV