Unanswered

Error write data information in excel.

(0) Share

Report

Posted on by roniercassio

Could you guys help me with a subject, I'm trying to create a simple flow to update a database in Excel from a csv file... I created the flow correctly but I have a bug that when the action will record the csv information in Excel the date column goes to Excel in the format of another region... for example in the csv the date is 02/05/2024 (DD/MM/YYY) however when the automate writes it to excel it changes to 05/02 /2024(MM/DD/YYY). Does anyone know how to solve it?
NOTE: My Region is PT-BR, I use this format in Excel (DD/MM/YYY).

csv file:

In Excel after execution automate:

Categories:

Power Automate Desktop

I have the same question (0)

All responses (11)

Answers (0)

Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@roniercassio

What is your system date format? I believe that also in "MM/DD/YYY" while you write date in excel file through PAD it will write date based on system date format only. If you want to change them, please consider some macro function for the same.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
roniercassio 12 on at

Like (0)

Report

My system format is dd/mm/yyy pt-br.

Was this reply helpful? Yes No
roniercassio 12 on at

Like (0)

Report

Any Solution for this question?

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2025 Season 2 on at

Like (0)

Report

Hi @roniercassio ,

Please Convert DateTime to text and then write it to the excel as shown in below image.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report
@roniercassio

Follow the below approach:
My CSV file looks like this

My flow screenshot:

Tip: Write current item value as text and replace with empty string like below:

Output:

Code:
File.ReadFromCSVFile.ReadCSV CSVFile: $'''C:\\Boot\\CSVTable.csv''' Encoding: File.CSVEncoding.UTF8 TrimFields: True FirstLineContainsColumnNames: True ColumnsSeparator: File.CSVColumnsSeparator.SystemDefault CSVTable=> CSVTable Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CSVTable.ColumnHeadersRow Column: $'''A''' Row: 1 LOOP FOREACH CurrentItem IN CSVTable Excel.GetFirstFreeRowOnColumn Instance: ExcelInstance Column: $'''A''' FirstFreeRowOnColumn=> FirstFreeRowOnColumn Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: $'''\'%CurrentItem['DataEntrega']%\'''' Column: $'''A''' Row: FirstFreeRowOnColumn END Excel.FindAndReplace.FindAndReplaceAll Instance: ExcelInstance TextToFind: $'''\'''' TextToReplaceWith: $'''%''%''' MatchCase: False MatchEntireCellContents: False SearchBy: Excel.SearchOrder.Rows Cells=> Cells Excel.SaveExcel.SaveAs Instance: ExcelInstance DocumentFormat: Excel.ExcelFormat.OpenXmlWorkbook DocumentPath: $'''C:\\Boot\\ConvertedCSVExcel''' Excel.CloseExcel.Close Instance: ExcelInstance

How to copy/paste the above code into your power automate desktop?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
roniercassio 12 on at

Like (0)

Report

Thank you so much for trying to help me!! The suggested solution worked partially, however my csv spreadsheet has several columns 3 of these columns count dates, I don't know how to update in a database in excel in specific columns and respecting the date information (dd/MM/YYYY).

Your Solution Work for simples Convertion But last step read and replace dont work there.

Write and Replace Action

Final Result: in Excel the " ' "

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@roniercassio

Could you pls share screenshot of your complete csvtable?

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report
@roniercassio

Please find the updated approach:
Note: Find and replace is not required right now

Code:

File.ReadFromCSVFile.ReadCSV CSVFile: $'''C:\\Boot\\CSVTable.csv''' Encoding: File.CSVEncoding.UTF8 TrimFields: True FirstLineContainsColumnNames: True ColumnsSeparator: File.CSVColumnsSeparator.SystemDefault CSVTable=> CSVTable Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CSVTable.ColumnHeadersRow Column: $'''A''' Row: 1 SET Rowcounter TO 2 LOOP LoopIndex FROM 0 TO CSVTable.RowsCount - 1 STEP 1 Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CSVTable[LoopIndex]['DataEntrega'] Column: $'''A''' Row: Rowcounter Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CSVTable[LoopIndex]['DataXYZ'] Column: $'''B''' Row: Rowcounter Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CSVTable[LoopIndex]['DataABC'] Column: $'''C''' Row: Rowcounter SET Rowcounter TO Rowcounter + 1 END Excel.FindAndReplace.FindAndReplaceAll Instance: ExcelInstance TextToFind: $'''\'''' TextToReplaceWith: $'''%''%''' MatchCase: True MatchEntireCellContents: False SearchBy: Excel.SearchOrder.Rows Cells=> Cells

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
roniercassio 12 on at

Like (0)

Report

Tank you.. but dont work there ;/

My csv file Estructure.
i need put all this informations in a base. in Collum C:M. its have many rows about 2k+

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Super User 2025 Season 2 on at

Like (0)

Report

@roniercassio

Please elaborate what is not working ?

Was this reply helpful? Yes No