Hello Forum, Today’s topic is divided into two questions about some issues I experienced today
FIRST ISSUE: READ RANGE STAYS PENDING
I was working with an excel file trying to use the “Read Range” on it to then convert it into a CSV, and started experiencing that it kept in the Partially Executed state forever. I don’t understand specifically why the problem comes with that excel file, because what I did was to copy all the info I needed to another excel file and the Read range finally worked as usual. I also tried using the other excel activities and the problem kept being the same. Staying in that state for as long as I patience reach, 10-15 minutes. As I said, I finally copied all the info to another file and the problem didn´t persist, but still persists when I try to use it in the Excel file where all initially started.
Has anyone experienced this before? Sure it has to have a specific reason.
SECOND ISSUE: DATE CONVERSION NOT DESIRED
Finally, when I copied all the info to the new Excel file and executed the flow you see on the first image on the First Issue. I noticed that the cells that have the date format as first image were changed to the format in second image. Why does it change the date format? how can I configure it so it doesn´t change the date format when I read the file?
Instead of using read range workbook activity use the read range activity which is the modern excel activity.
=> Take use excel file activity and pass the excel file path.
=> Inside use excel file activity insert the read range activity. In the properties of read range activity, Read formatting option is there select the raw value option which holds the same format of the cells and store in a datatable.
=> After that use the write csv file to write the datatable to csv file.
If you want to use only the read range workbook activity, Open the properties and check the Preserve format option which also holds the format in the excel.
Hello @Parvathy, Thank you very much for your response.
I have to admit I feel pretty embarrassed , Yesterday was a complicated day and I guess I still forget the basics and check the properties of the activities very carefully. I guess I have no trouble consulting the forum every time I need something.
Yet with the answers on the topic I started testing the different configurations available mostly for the Excel activities (That worked better for my case), and I reached interesting outputs that might be useful for you and the community to see. One of them being that even when I checked the Preserve Format property from the Read Range Workbook Activity still the date values were modified… These are the different outputs.
Date Format from Original File:
24/08/2023
Preserve Format (False)
08/24/2023 00:00:00
Preserve Format (True)
8/24/2023
Finally I realized that is better to use the excel activities for this kind of cases.
Hello @mkankatala Thank you very much for your response and for being so clear with your instructions, you definitely won the solution.
The only thing I have to address is that Raw Value wasn´t the correct configuration it was Display Value instead. I tested all the available configurations and this were my results.
Original Date Format from Source Excel File
24/08/2023
, Yesterday was a complicated day and I guess I still forget the basics and check the properties of the activities very carefully. 
I guess I have no trouble consulting the forum every time I need something.