Read csv01

I want to read value from csv,but in cell value show different value and actual value see in above.

Hey,
Please provide us more details what issue you have. But if you problem is only related with displaying value then try change type of cell to a number and will be ok.


@vishal22landge

Use Read CSV activity and create a datatable variable

Hope this will help you

Thanks

How to change run time cell formats in csv

Store the all value in datatable

@vishal22landge

Yes, the variable you create in Read CSV file will hold all the values

then you can retrieve whatever value you required

Thanks

Getting value in Dt but format is not correct format.

Hi,

Use below expression to change the exponential value to normal integer. Please refer the below thread for more guidance. Thanks.

intvariable = Decimal.Parse(yourexponentialvalueindatatable, System.Globalization".NumberStyles.Any)

It’s working

Glad it worked. Nice connecting with you.

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