Excel Pivot Table & Dates

Help Studio
1

Hi, I have a problem with an excel workbook and its pivot table.

I have to write Dates in format dd/MM/yyyy into the excel file. And I normally use write Range from workbook activities, but because it has a pivot table the workbook activities create errors. So I’m using the excel activities.

I’m trying to do something simple like write some cells, to see if it’s working. Like this:

image
image443×623 7.27 KB

When the execution is finished, I open the file and the dates are in MM/dd/yyyy format and not in dd/MM/yyyy format
image

How could I solve this without deleting the pivot table?

I choose in excel to have the column in personalized format dd/MM/yyyy but it doesn’t work.

2

if your excel column format is in text then just( ’ single quote) to your date so that it will write as text and format will be in same
Regards

3

I’h tried this before and it works, but later this excel have to be processed in SAP and I don’t know if the single quote creates another problem. I’ll keep in mind though. Thank you.

4

i guess mostly excel interprets based on system date , may be that could be the reason
Regards

1 Like
5

Fix it!
The datatable came from another Read range excel.
When It reads the column, looks like it’s reading it as a text.
This way, the write cell interprets the text however it knows. Taking it like a MM/dd/yyyy format.

What I’m doing right know is:

  1. Read Range first excel.
  2. for each row
    2.1 Assign row(“dateColum”) = datetime.parseexact(Indicate the format)
  3. Write Range

And it works. :smiley:

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.