Jump to content

trouble with dots in output file

Paul Gleichmann

Recommended Posts


Ive been having this problem in PVsyst output files.

The hourly data file in the .csv format contains numbers with dots, so far so usual. But excel recocnizes some of those numbers with dots that count as a comma, and some with dots that count as a european delimiter (as in 10.000 m).

This results in completely unrealistic values. 150.36 kW of electrical power inserted to the grid on a certain hour can be read as 150,3 kW or 150.360 kW

I tried to convert the .csv file into an usual .xls file

I also tried in excel: File < Options < advanced < Use delimiter character accordingly to OS language setting, but the problem keeps on occuring.

Is there a solution to this subject?



Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...