Hi All, I need one help while formatting text file data to excel file. Can anyone help me please

Help Studio
, ,
1

In a text i have data.

Now i want to write entire text file data into excel file.

Can anyone help me please.

2

Hi @PriyaReddy

Please check the below workflow:

Main.xaml (39.2 KB)
Testing.xlsx (8.0 KB)

Output:

image
image1021×667 16.5 KB

Let me know if you have any queries.

Regards

3

Hi,
image
I am getting this error in second multiple assign can you please help me.

4

Hi @PriyaReddy

Have you changed anything in the code?

Regards

5

No. Nothing i have changed. Now i have more data than in given text file will that be an issue?

6

image
image1110×457 71 KB

7

Hi,
It seems fixed format. Can you try the following?

image
image913×3378 217 KB

Sample
Sample20240320-2a (2).zip (5.4 KB)

Note: Please add STATUS column because it requires condition to judge.

Regards,

8

image
image804×243 9.59 KB

I am getting object reference error but all variables are initialized under scope only.

9

Hi,

Did you run the above sample as it is? Or modified then run? In my environment, the above works well.

Regards,

10

Hi yoichi, Can you please try with this text file and let me know. coz, I am getting errors.

11

Hi,

In my environment (Studio2023.10.3), it works without error.

Sample20240320-2av3.zip (45.0 KB)

Regards,

12

my version is 2022.10.10, still getting that object reference error.

13

HI,

Can you check/share content of the variable at Locals panel when the error occurs?

Regards,

14

image
image1825×609 45.2 KB

That is the error i am facing.

15

Hi @PriyaReddy

Can you try this:
Main (1).xaml (39.1 KB)
Testing.xlsx (47.7 KB)

If you still face any error, please Go to Manage Packages-> Select UiPath.System.Activities → Downgrade the package to lowest version by keeping RunTimeRule As Lowest As Applicable and save. After that again Go to Manage Packages-> update the same package to latest version without changing the RunTime Rule. This should help you.

Regards

16

Hi,

I mean Locals panel as the following.

image
image727×621 13.9 KB

Regards,

17

image
image1294×774 145 KB

Yoichi here also same issue i think. If i am having data as 3550 kb then i am getting object reference error else it is working fine. Can you please suggest a solution for this.

18

i have 3554 kb data if i have less data it is working fine. so, now again it’s not working. I am getting multiple assign issue.

19

I will check and let you know @PriyaReddy

Regards

20

In my environment, it works without error and returns 13054 records as result.

Sample20240320-2aV3.zip (374.4 KB)

Does your PC have enough memory?

Regards,