I cannot print some data while printing data

Help Activities
, ,
1

I cannot print some data while printing data.

2
Log record on Get Text activity

1
When I print to my Excel file, I cannot print the number 0

2

Hey @tolgademir

While writing into the excel keep the Column “Posta Kodlan” as String type
If it is Int type then it removes the Beginning zeroes

Below is the example screenshot
The String type column works
But the INT32 type column i.e. Age… Removes the beginning zeroes as shown in the screenshot
Screenshot 2023-07-11 014408

3

412
My related column and variable in Excel are already in string data type.
Adsız
I’m using a counter when printing the data, do you think this has any effect?

4

@tolgademir

For that you can add a single quote in front of the number so that it is considered as string and 0 also would be shown

Cheers

5

@tolgademir
You are using which activity to write into Excel?

Also, can you show the screenshot of type of that column

And no the counter is not a problem

6

forum1
I’m using an excel file directly, I’m sure it’s a string


forum2

7

Hi @tolgademir

Try like this

image
image899Ă—718 31.1 KB

I hope it helps!!

8

@tolgademir

As @Anil_G answered, add a single quote like below screenshot

image
image859Ă—267 15.7 KB

The Single apostrophe treats the data as a text format

Hope it helps

9

@tolgademir

Try this method also as @Anil_G said

image

I hope it helps!!

10

1
I made sure that the type of my column is string.

11

@tolgademir

Yes, if it doesnot work

try this method

12

This method worked, but I don’t understand why I should use single quotes, can you explain why we use it?

13

@tolgademir

A single quote before a number or string…makes the excel read that value as string instead of number…when it reads as number it would remove leading zero…so to make exce read as text or string we add a single quote…

Cheers

14

@tolgademir

The number starting with 0 so it doesnot take it, if it is starts with ’ so it acts like a string

15

I want to make a correction. When I formatted the cells in my Excel table as strings, the problem was solved without the need for other methods. Previous data format was general format
Adsız

1 Like
16

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