async def _store_hotel(self,
sheet: Worksheet,
row: int,
parsed_columns: List[HotelField],
hotel: HotelContentRow) -> None:
parsed_header: HotelField
# 由 Columns 尋訪，並找出資料欄位
for col, header in enumerate(parsed_columns):
if header is HotelField.Url:
url = hotel[header]
url = self._normializa_url(url)
link_style = {"color": "blue", "underline": 1, "font_size": 12}
link_format = self._workbook.add_format(link_style)
sheet.write_url(row, col, url, link_format)
elif header is HotelField.Rooms:
number_style = {"font_size": 12}
number_format = self._workbook.add_format(number_style)
sheet.write_number(row, col, int(hotel[header]), number_format)
else:
# 如果資料為 None 改成空字串
field_data = hotel[header] if hotel[header] else ""
sheet.write_string(row, col, field_data)
