hi
i need to create an excel with every week one day like
today 22/10/2020 in the A1 and 29/10/2020 in the A2 like that it should go one for every month
can anyone suggest me how can we do it
Hi @lakshmi3,
You can use a Do While (with the condition on where to stop, e.g. when the year ends)
Chose a startDate and then have a counter
Write in the cell “A” + counter the startDate.AddDays(7 X (counter-1))
Or similarly Assign startDate to a variable Date and in each loop you Assign
Date=Date.AddDays(7)
1 Like
i’ve tried this but with the assign activity it is showing
‘is not a memeber of integer’
Opt1:
In the Cell Space there is “A”+Counter.ToString
Opt2:
In the bottom you see how the variables are defined
thankyou for the reply
in the variable unable to give the start date as it states value integer cannot be converted to date
Can you screenshot how you are assigning the start date?
You should not use the quotes
Use
Datetime.ParseExact(“20/10/2020”,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)
This Works for sure
You can do one of the following:
- Put the Assign before the write Cell
- Start from Counter=1 or 2
hi
thankyou for the reply
it worked with the date
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.