search

nickmckay / LiPD-utilities

Input/output and manipulation utilities for LiPD files in Matlab, R and Python
http://nickmckay.github.io/LiPD-utilities/
GNU General Public License v2.0
28 stars 9 forks source link

Failed to open Excel workbook: LakeIznik.Ulgen.2012, Excel xlsx file; not supported #92

Open NQ-ITP opened 1 week ago

NQ-ITP commented 1 week ago

I encountered an issue when using LiPD in Python to convert an xlsx file to the lpd format. The conversion failed with the error: Failed to open Excel workbook: LakeIznik.Ulgen.2012, Excel xlsx file; not supported. The same error occurs when trying to convert the example file LiPD-utilities/Examples/MD982176.Stott.2004.xlsx My Python version is 3.12.4. This is the xlsx file: LakeIznIk.Ulgen.2012.xlsx 1732263396364

nickmckay commented 1 week ago

We're in the process of superseding the functionality in this package with a new package, pylipd although I'm not certain whether the excel translation will be replaced. @khider , can you answer that?

In the meantime (or as an alternative), you might consider using http://lipd.net/playground to create the file, which is our recommended pathway at this point.

khider commented 1 week ago

Correct, we won't be supporting a specific Excel template but give tutorials on how to use the new python toolbox to create LiPD files. In the meantime, I suggest using the playground for a single file.