search

valentinitnelav / img-with-box-from-excel

boxcel: Integrate Excel with Python for visualizing images with their corresponding bounding boxes for object detection annotation workflows
BSD 3-Clause "New" or "Revised" License
3 stars 0 forks source link

Windows - cannot open the xlsm created file; works on Linux though #12

Closed valentinitnelav closed 1 year ago

valentinitnelav commented 1 year ago

On Windows, when trying to open the newly created xlsm file with Excel I get this error message Excel cannot open the file '...xlsm' because the file format or file extension is not valid. There is no problem on Linux & LibreOffice.

A xlsm test file was created with:

C:\Users\vs66tavy\Documents\img-with-box-from-excel\src\boxcel>python start_project.py C:\Users\vs66tavy\Downloads\hymenoptera_sample.xlsx
xlwings version: 0.28.3
Writing sheet Andrenidae to xlsm file C:\Users\vs66tavy\Downloads\hymenoptera_sample\hymenoptera_sample.xlsm
Writing sheet No family to xlsm file C:\Users\vs66tavy\Downloads\hymenoptera_sample\hymenoptera_sample.xlsm
Writing sheet _xlwings.conf to xlsm file C:\Users\vs66tavy\Downloads\hymenoptera_sample\hymenoptera_sample.xlsm
Path to the current executed python file is: C:\Users\vs66tavy\Documents\img-with-box-from-excel\src\boxcel\display_images.py
Copied the Python code from C:\Users\vs66tavy\Documents\img-with-box-from-excel\src\boxcel\display_images.py to C:\Users\vs66tavy\Downloads\hymenoptera_sample\hymenoptera_sample.py
All good!