I encountered a type conversion error

[Gaoyongxian666]

Error is reported when big numbers are set to date format

 Traceback (most recent call last):
    File "qutils\xlsx2txt\xlsx2csv.py", line 838, in handleCharData
  OverflowError: Python int too large to convert to C int
  
During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "qutils\xlsx2txt\xlsx2txt.py", line 67, in process
  File "qutils\xlsx2txt\xlsx2txt.py", line 60, in xlsx2txt
  File "qutils\xlsx2txt\xlsx2csv.py", line 281, in convert
  File "qutils\xlsx2txt\xlsx2csv.py", line 352, in _convert
  File "qutils\xlsx2txt\xlsx2csv.py", line 781, in to_csv
  File "C:\A\34\s\Modules\pyexpat.c", line 272, in CharacterData
  File "qutils\xlsx2txt\xlsx2csv.py", line 874, in handleCharData
qutils.xlsx2txt.xlsx2csv.XlsxValueError: Error: potential invalid date format.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "qutils\xlsx2txt\xlsx2csv.py", line 838, in handleCharData
OverflowError: Python int too large to convert to C int

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "qutils\searchthread.py", line 120, in write_temp
  File "qutils\util.py", line 306, in get_text
  File "qutils\xlsx2txt\xlsx2txt.py", line 71, in process
  File "qutils\xlsx2txt\xlsx2txt.py", line 38, in xlsx2txt_win32
  File "qutils\xlsx2txt\xlsx2txt.py", line 60, in xlsx2txt
  File "qutils\xlsx2txt\xlsx2csv.py", line 281, in convert
  File "qutils\xlsx2txt\xlsx2csv.py", line 352, in _convert
  File "qutils\xlsx2txt\xlsx2csv.py", line 781, in to_csv
  File "C:\A\34\s\Modules\pyexpat.c", line 272, in CharacterData
  File "qutils\xlsx2txt\xlsx2csv.py", line 874, in handleCharData
qutils.xlsx2txt.xlsx2csv.XlsxValueError: Error: potential invalid date format.

#REF! show Error

Traceback (most recent call last):
  File "qutils\xlsx2txt\xlsx2csv.py", line 857, in handleCharData
ValueError: could not convert string to float: '#REF!'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "qutils\xlsx2txt\xlsx2txt.py", line 67, in process
  File "qutils\xlsx2txt\xlsx2txt.py", line 60, in xlsx2txt
  File "qutils\xlsx2txt\xlsx2csv.py", line 281, in convert
  File "qutils\xlsx2txt\xlsx2csv.py", line 352, in _convert
  File "qutils\xlsx2txt\xlsx2csv.py", line 781, in to_csv
  File "C:\A\34\s\Modules\pyexpat.c", line 272, in CharacterData
  File "qutils\xlsx2txt\xlsx2csv.py", line 874, in handleCharData
qutils.xlsx2txt.xlsx2csv.XlsxValueError: Error: potential invalid date format.

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "qutils\xlsx2txt\xlsx2csv.py", line 857, in handleCharData
ValueError: could not convert string to float: '#REF!'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "qutils\searchthread.py", line 120, in write_temp
  File "qutils\util.py", line 306, in get_text
  File "qutils\xlsx2txt\xlsx2txt.py", line 71, in process
  File "qutils\xlsx2txt\xlsx2txt.py", line 38, in xlsx2txt_win32
  File "qutils\xlsx2txt\xlsx2txt.py", line 60, in xlsx2txt
  File "qutils\xlsx2txt\xlsx2csv.py", line 281, in convert
  File "qutils\xlsx2txt\xlsx2csv.py", line 352, in _convert
  File "qutils\xlsx2txt\xlsx2csv.py", line 781, in to_csv
  File "C:\A\34\s\Modules\pyexpat.c", line 272, in CharacterData
  File "qutils\xlsx2txt\xlsx2csv.py", line 874, in handleCharData
qutils.xlsx2txt.xlsx2csv.XlsxValueError: Error: potential invalid date format.

[Gaoyongxian666]

Here are some examples.

Thanks.

could not convert string to float_formula.xls could not convert string to float_ref.xlsx could not convert string to float_str_error.xlsx date format.xlsx

could not convert string to float NA.xlsx