def _values_to_row(self, values, row_idx):
"""
Convert whatever has been appended into a form suitable for work_rows
"""
cell = WriteOnlyCell(self)
for col_idx, value in enumerate(values, 1):
if value is None:
continue
try:
cell.value = value
except ValueError:
if isinstance(value, Cell):
cell = value
else:
raise ValueError
cell.column = col_idx
cell.row = row_idx
if cell.hyperlink is not None:
cell.hyperlink.ref = cell.coordinate
yield cell
# reset cell if style applied
if cell.has_style or cell.hyperlink:
cell = WriteOnlyCell(self)
def _create_cell(self, worksheet: WriteOnlyWorksheet, data: dict) -> WriteOnlyCell:
cell = WriteOnlyCell(ws=worksheet, value=data.get('value'))
cell.column = data.get('column')
cell.row = data.get('row')
cell.font = self._create_cell_font(data.get('font'))
cell.alignment = self._dict_to_object(data.get('alignment'), Alignment)
cell.border = self._create_cell_borders(data.get('border'))
return cell
