want to write all the dates from current month in excel column
Hi @Vinit_Mhatre ,
Could you using this inside a For Each Activity and write the values one by one into Excel?
Enumerable.Range(1,DateTime.DaysInMonth(Today.Year,Today.Month)).Select(Function(s) New DateTime(Today.Year,Today.Month,s).ToString("dd-MM-yyyy")).tolist()
Kind Regards,
Ashwin A.K
Thanks for your help
Hey, i am trying to write the data to specific range “A6” in sheet1
rather than writing the data to this sheet1 its creating another new sheet1 into same excel sheet what to do?
Pass the correct sheet name you are showing Sheet1 and already present is Sheet 1.
Thanks
1 Like
Ohhh , thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.