Hi All,
while reading the excel cell ex 0095 as text though advance excel it is skipping 00 and reading 95 in outsystems,How to not skip 00.
Regards
Hi @ujwala
I created a new spreadsheet in Excel and added the value 0095 in a cell formatted as text. I also added '0095 in an unformatted cell.
Using Cell_Read action to read both cells twice, once with ReadText = True, once with ReadText = False, the result is always returned 0095.
Are you perhaps setting the result in an integer variable?
Hanno
Thank you Hano,
No,the format is we dont set in excel as text then it takes as 95 instaed of 0095,
So we need to convert to text and then upload excel,
I was looking for this extra step to be avoided.
Thank you
How is the excel file generated before you read it with Advanced Excel?
using cellwrite we are creating from table rows and before downloading as excel we want to format all the cell as excel,eventhough it is text but when we dowload the excel the format of the cell is coming as general.
We are checking the option to format the cell as text automatically.