Text file to excel

HI,
I want to copy data from a text file into an excel sheet. How do i achieve this ? I cannot use generate datatable because there are no proper separators. Is there any code or some activity that i can use to do this ?

2 Likes

Hi
but even the code will find it difficult if there is no separator…
can i have sample of it if possible
Cheers @shibani

2 Likes

@shibani
I think its very hard for the components to determine how it will works ,First the textfile doesnt has a proper format specially for the separator,It we can determine the format of the textfile maybe we can comeup with the logic.

cheers :smiley:

Happy learning :smiley:

3 Likes

Hi @shibani,

Can you share the sample file to investigate.

Regards
Balamurugan.S

1 Like

@Palaniyappan @Palaniyappan @balupad14
HI
I have attached the text file along. Sorry for the delay

sample.txt (29.5 KB)

Regards

1 Like

Main.xaml (4.8 KB) This seemed to work for me as the file was actually Tab delimited.

2 Likes

Hi @shibani,

Here is the output screen.

image

@cwedl is exactly true. It is tab delimited csv file.

I have attached my sample.

Shibani.zip (50.5 KB)

Regards
Balamurugan.S

4 Likes

@balupad14 Thank you so much !! This worked.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.