src/openpyxl/compat/strings.py
1# Copyright (c) 2010-2024 openpyxl
2
3from datetime import datetime
4from math import isnan, isinf
5import sys
6
7VER = sys.version_info
8
9from .numbers import NUMERIC_TYPES
10
11
12def safe_string(value):
13 """Safely and consistently format numeric values"""
14 if isinstance(value, NUMERIC_TYPES):
15 if isnan(value) or isinf(value):
16 value = ""
17 else:
18 value = "%.16g" % value
19 elif value is None:
20 value = "none"
21 elif isinstance(value, datetime):
22 value = value.isoformat()
23 elif not isinstance(value, str):
24 value = str(value)
25 return value