Excel auto fil

Help StudioX
,
1

I have a report and got some data(scan time)

I need to enter the scan time on that current date row.

Date Scanning Time
20-02-2023
21-02-2023
22-02-2023
23-02-2023
24-02-2023
25-02-2023

today did my scan and entered my scan time in todays date
then then next day- need to enter that date scan time

I tried but its overwriting on same row itself

c94bdd3a52487cc9e1baea08df4cedbc93c56e9d_2_1035x580
c94bdd3a52487cc9e1baea08df4cedbc93c56e9d_2_1035x5801035×580 40 KB

2

Hi @YUGAN_NITHISH_KUMAR, please check the attached workflow. Please replace the excel I used with yours.
Main.xaml (11.0 KB)

3

21.10.7+Branch.support-v21.10.Sha.4fc9759469a976c6aff9aff581b459a31fa01cd9

The project ‘C:\Users\yugan\Downloads\project.json’ could not be opened: Project is incompatible with StudioX profile. You can open it in Studio and fix the errors.
Missing namespaces: clr-namespace:UiPath.Activities.System.Binding;assembly=UiPath.System.Activities

Can you please send in studiX

When i try to open in studio also its error
21.10.7+Branch.support-v21.10.Sha.4fc9759469a976c6aff9aff581b459a31fa01cd9

Document is invalid

Open Document Error: UiPath.Studio.Contracts.RecoverableException
—> UiPath.Studio.Contracts.RecoverableException: The item ‘C:\Users\yugan\Downloads\Main.xaml’ could not be opened: Document is invalid.
—> RemoteException wrapping System.IO.InvalidDataException: Document is invalid

4

Hi @YUGAN_NITHISH_KUMAR, PFA.
NewBlankTask1.zip (57.4 KB)

6

if i use same in studioX it will work or need to change any ?

7

I have built that in StudioX and shared the same. All you need to change is the excel file path/ name.

8

I tried but negative

can i share my whole project file and with xlsx file?

9

Sure. Please share it and exclude and confidential data

10

it have whole my project
should i share?

it is possible to share to ur mail or inbox?

11

may I know what is not working here?

13

working bro?

15

OK
thank you

can you help me on email sending with attachment

i completed that date part

16

I see that you’re using a variable “Threats detected” which is empty so you’re not seeing anything in the excel. Instead of that, use ‘Date.Now’ and it works.

image
image682×583 17.5 KB

17

yes got it

i used email and its sending mail
but everytime i need to click allow manually how to do that ?

18

What is that you’re manually clicking on ‘Allow’. Can you share any screenshot?

19

Thanks for your time bro @Vamsi_Krishna_Gogineni
cleared my error