Facing issue while writing data from data table to Excel

(0) Share

Report

Posted on by neerajpokh

159

Hi,

I am facing a weird issue while using "Write to excel" activity and writing data from data table using sql script, but zeros are removing.

i have records are like - 00013

and using sql script to read data

after that using "write to excel" activity but its not writing original data, means removing zeros

can you please help on this urgently as stucked from last 3 days

Categories:

Power Automate Desktop

I have the same question (0)

All responses (15)

Answers (1)

Sort by

ryule 929 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Have you confirmed it's reading the data correctly? It could just be an Excel issue (cell type) where you are writing the data, if it is reading it correctly.

Was this reply helpful? Yes No
neerajpokh 159 on at

Like (0)

Report
Copy link

Link copied!

yes everything is correct, datatable has correct data only changing while writing

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try putting a single-quote ' in the input before your data in the Write input.

Was this reply helpful? Yes No
neerajpokh 159 on at

Like (0)

Report
Copy link

Link copied!

i have thousand record, loop can't apply for that

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What...?

How does your Write to Excel action look?

Was this reply helpful? Yes No
neerajpokh 159 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Try adding the single quote to the datatable column to see if it fixes the formatting.

Method:

SET Datatable TO {['R1C1', 'R1C2'], ['R2C1', 'R2C2'] }
LOOP LoopIndex FROM 0 TO Datatable.RowsCount - 1 STEP 1
SET Datatable[LoopIndex][0] TO $'''\'%Datatable[LoopIndex][0]%'''
END

Was this reply helpful? Yes No
neerajpokh 159 on at

Like (0)

Report
Copy link

Link copied!

i am using below script
SELECT [Employee ID],[Legal Name - Last Name], [Legal Name - First Name], [Company], [Benefit Group], [Benefit Plan], [Hire Date], [Date of Birth], [Age], [Coverage] FROM [Sheet1$] WHERE ([Benefit Group] <> 'Union'

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Yes, and that SQL statement produces a datatable, which I would like you to loop through and modify:

1 people found this reply helpful.

Was this reply helpful? Yes No
neerajpokh 159 on at

Like (0)

Report
Copy link

Link copied!

actually i have thousands rows, so loop is not possible with huge records

Was this reply helpful? Yes No