Convert string to decimal and write it to Excel

Help
1

Hi,

I am using below code to convert string to decimal and it is working as expected. But when i write values to Excel it is not writing it as decimal values

convert.ToDecimal(inputString) and also tried String.Format(“{0:0.00}”,CDbl(inputString))

When i print the value i am getting the expected output but issues happens when it writes it to Excel.

Did anyone faced similar situation?

1 Like
2

@sathwik19

You have to change Column format in Excel file and then it will show decimal value.

3

how to automate it to change the column format from backend?

4

do you have any example

5

@sathwik19

I also faced same issue. I created one template Excel file with all columns of required type and then writing into that file. It’s solved my issue.

6

Okay thanks that might not work in my case i have to create a file daily and that should be seamless.

7

@sathwik19

No need to create file daily if the columns are same .