Values from CSV file is written to 1st row and 2nd row of csv also writing to 1st row of expense site

excel
activities

#1

Hi Experts,
I am reading a csv file and trying to fill the value in our office expense site.The steps are getting executed successfully.The first row from csv file are written to expense site where as the 2nd row from csv file is also read but it is getting overridden in the first row of expense site itself and it is not going to the second row.Can you please provide your advice?How value can be written to second row.I have used for each


#2

Hi,
Could you please upload workflow.


#3

Timesheet workflowand readCSVfile.zip (5.9 KB)


#4

Can’t download zip file due to company security concern. :stuck_out_tongue:
Could you please attach xaml and excel.


#5

ReadCSV_Timesheet.xaml (39.3 KB)
ReadCSV_Timesheet.xaml (39.3 KB)


#6

Hi,
Looks like you attached xaml twice.
Missing the csv file.
You could just pass
dtTimesheets.Rows.Count.ToString to check whether datatable contains 2 rows or not.


#7

I cant upload a csv file so attached the screenshot


#8

Where I need to pass dtTimesheets.Rows.Count.ToString .Can you suggest


#9

inside For each row
dt


#10

Count


#11

Count is correct


#12

yes.It is reading properly i didn’t get what’s the trouble here.
you said its overridden in the first row of expense site i can’t suggest much without looking into target application.


#13

It is reading properly but in my timesheet the 2nd row of the csv should write to 2nd row instead of writing to 2nd row it is overwriting the 1st row of my timesheet.


#14

Is their any way I can share my target system.


#15

ok cool.
How your writing into expense site.
I don’t see that in workflow.
Which activity you used.
So i can assist you better. :slight_smile: