You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In [46]: r=fastexcel.read_excel("tmp/ex_broken_minimal.xlsx")
In [47]: r.load_sheet(0)
---------------------------------------------------------------------------CalamineCellErrorTraceback (mostrecentcalllast)
CellIn[47], line1---->1r.load_sheet(0)
File/usr/local/lib/python3.9/site-packages/fastexcel/__init__.py:256, inExcelReader.load_sheet(self, idx_or_name, header_row, column_names, skip_rows, n_rows, schema_sample_rows, dtype_coercion, use_columns, dtypes)
205defload_sheet(
206self,
207idx_or_name: int|str,
(...)
216dtypes: DType|DTypeMap|None=None,
217 ) ->ExcelSheet:
218"""Loads a sheet lazily by index or name. 219 220 :param idx_or_name: The index (starting at 0) or the name of the sheet to load. (...) 253 or dict of dtypes with keys as column indices or names. 254 """255returnExcelSheet(
-->256self._reader.load_sheet(
257idx_or_name=idx_or_name,
258header_row=header_row,
259column_names=column_names,
260skip_rows=skip_rows,
261n_rows=n_rows,
262schema_sample_rows=schema_sample_rows,
263dtype_coercion=dtype_coercion,
264use_columns=use_columns,
265dtypes=dtypes,
266eager=False,
267 )
268 )
CalamineCellError: calaminecellerror: #NUM!Context:
0: couldnotdeterminedtypeforcolumn8
The #NUM! value is parsed by calamine just fine, it just raises CellErrorType::Num
This was fixed for #N/A errors in #180 . We could add the same handling for CellErrorType::Num perhaps?
The text was updated successfully, but these errors were encountered:
Consider the following example file:
fixture-invalid-cell-value-num.xlsx
This currently fails with:
The
#NUM!
value is parsed bycalamine
just fine, it just raisesCellErrorType::Num
This was fixed for
#N/A
errors in #180 . We could add the same handling forCellErrorType::Num
perhaps?The text was updated successfully, but these errors were encountered: