Reading Values with % from Excel Using PowerShell

Asked Jan 15 '21 at 08:28

Active Jan 15 '21 at 10:22

Viewed 42 times

I have a requirement where I have to read data from Excel and write it to another excel.

In my excel I have one column as below screeshot.

When I read it Using powershell using the below command

$WorkSheet.Cells.Item(12,47).Value2

The value 0.9% is read as 0.00931.Is it possible that I can read the value as 0.9%

edited Jan 15 '21 at 10:22

Itchydon

asked Jan 15 '21 at 08:28

Ashutosh Rai

multiply it by 100. Why are you using powerpoint to do this? – Solar Mike Jan 15 '21 at 08:54
@Solar Mike I want to read the value as "0.9%" .And i am using powershell not PowerPoint – Ashutosh Rai Jan 15 '21 at 08:58
2

So why does the title specify Powerpoint? – Solar Mike Jan 15 '21 at 08:59
0.00931 = 0.931%. Nothing wrong with that. Just multiply by 100 when printing and you'll get the percent value – phuclv Jan 15 '21 at 10:31
2

Perhaps also have a look at [What is the difference between .text, .value, and .value2?](https://stackoverflow.com/questions/17359835/what-is-the-difference-between-text-value-and-value2) – Theo Jan 15 '21 at 12:41

0 Answers0