Won't upload excel to ethogram or download ethogram to excel

[jmacntu2021]

An error has occured!

to improve the software please report this problem at:
https://github.com/olivierfriard/BORIS/issues

Please no screenshot, the error message was copied to the clipboard.

Thank you for your collaboration!

BORIS version: 8.27.1
OS: Windows 10 10.0.22631
CPU: AMD64 Intel64 Family 6 Model 186 Stepping 3, GenuineIntel
Python 3.11.2 (64-bit)
Qt 5.15.2 - PyQt 5.15.10
MPV library version: 2.1
MPV library file path: C:\Users\macha\BORIS\Lib\site-packages\boris\misc\mpv-2.dll

Error succeded at 2024-08-09 17:20

Traceback (most recent call last):
File "C:\Users\macha\BORIS\Lib\site-packages\pandas\core\indexes\base.py", line 3805, in get_loc
return self._engine.get_loc(casted_key)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "index.pyx", line 167, in pandas._libs.index.IndexEngine.get_loc
File "index.pyx", line 196, in pandas._libs.index.IndexEngine.get_loc
File "pandas\_libs\hashtable_class_helper.pxi", line 7081, in pandas._libs.hashtable.PyObjectHashTable.get_item
File "pandas\_libs\hashtable_class_helper.pxi", line 7089, in pandas._libs.hashtable.PyObjectHashTable.get_item
KeyError: 'COLOR'

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "C:\Users\macha\BORIS\Lib\site-packages\boris\project.py", line 308, in
menu.triggered.connect(lambda x: self.import_ethogram(action=x.statusTip()))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\macha\BORIS\Lib\site-packages\boris\project.py", line 462, in import_ethogram
project_import_export.import_behaviors_from_spreadsheet(self)
File "C:\Users\macha\BORIS\Lib\site-packages\boris\project_import_export.py", line 580, in import_behaviors_from_spreadsheet
load_dataframe_into_behaviors_tablewidget(self, df)
File "C:\Users\macha\BORIS\Lib\site-packages\boris\project_import_export.py", line 428, in load_dataframe_into_behaviors_tablewidget
behavior[x] = row[ethogram_header[x].upper()] if str(row[ethogram_header[x].upper()]) != "nan" else ""
~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\macha\BORIS\Lib\site-packages\pandas\core\series.py", line 1121, in getitem
return self._get_value(key)
^^^^^^^^^^^^^^^^^^^^
File "C:\Users\macha\BORIS\Lib\site-packages\pandas\core\series.py", line 1237, in _get_value
loc = self.index.get_loc(label)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\macha\BORIS\Lib\site-packages\pandas\core\indexes\base.py", line 3812, in get_loc
raise KeyError(key) from err
KeyError: 'COLOR'

System info

Host Name: JULIAS_LAPTOP
OS Name: Microsoft Windows 11 Home
OS Version: 10.0.22631 N/A Build 22631
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Workstation
OS Build Type: Multiprocessor Free
Registered Owner: [email protected]
Registered Organization: HP
Product ID: 00342-21152-52607-AAOEM
Original Install Date: 2/26/2024, 5:23:09 PM
System Boot Time: 8/5/2024, 8:43:32 PM
System Manufacturer: HP
System Model: HP Laptop 14-ep0xxx
System Type: x64-based PC
Processor(s): 1 Processor(s) Installed.
[01]: Intel64 Family 6 Model 186 Stepping 3 GenuineIntel ~1300 Mhz
BIOS Version: Insyde F.07, 11/15/2023
Windows Directory: C:\windows
System Directory: C:\windows\system32
Boot Device: \Device\HarddiskVolume1
System Locale: en-gb;English (United Kingdom)
Input Locale: en-us;English (United States)
Time Zone: (UTC+00:00) Dublin, Edinburgh, Lisbon, London
Total Physical Memory: 7,903 MB
Available Physical Memory: 1,242 MB
Virtual Memory: Max Size: 21,215 MB
Virtual Memory: Available: 10,296 MB
Virtual Memory: In Use: 10,919 MB
Page File Location(s): C:\pagefile.sys
Domain: WORKGROUP
Logon Server: \JULIAS_LAPTOP
Hotfix(s): 6 Hotfix(s) Installed.
[01]: KB5039895
[02]: KB5027397
[03]: KB5031274
[04]: KB5033055
[05]: KB5040442
[06]: KB5039338
Network Card(s): 2 NIC(s) Installed.
[01]: Bluetooth Device (Personal Area Network)
Connection Name: Bluetooth Network Connection
Status: Media disconnected
[02]: Realtek RTL8852BE WiFi 6 802.11ax PCIe Adapter
Connection Name: WiFi
DHCP Enabled: Yes
DHCP Server: 192.168.0.1
IP address(es)
[01]: 192.168.0.18
[02]: fe80::148f:99c6:a349:e51c
Hyper-V Requirements: A hypervisor has been detected. Features required for Hyper-V will not be displayed.