I have an excel sheet containing multiple rows which have different dates, say 9/3/2020-15/3/2020. I have declared the data type as datetime. I added another column to write the date into it if a condition is met inside the excel loop. Here are two issues I’m facing trying to implement this process:
// My date column is datearrival and column I’m writing to is Testdate
// Date format in the excel file is DD/MM/YYYY
When I use if condition inside the excel loop as if datearrival.equals(9/3/2020), then some output, I don’t get the desired results. Every row fails this condition even though there are rows containing this date. Why is this happening? Is there any other condition which I should use or any specific date format that should be present?
Instead of writing to a column in the same excel sheet, I wanted to create a datatable and export as an excel sheet. But all the columns created in the excel file have the format: general and not the data type I specified in the AE platform. Is there a way to export using the data types used in the AE platform? If the type in AE is str, datetime, int32 the excel cell should also be str, date and number…
Thanks for the help.