I know this exists for pulling a .clb into Excel, but is there a script/macro/etc to go the other way? I have a table of settings in an Excel sheet, and I’d like to import it into LightBurn. I saw this, but it seems to be going the other way, bringing the .clb into Excel.
TIA!!
Unfortunately, I don’t have a perfect solution for you, although I’m very familiar with Excel and now also a bit with Lightburn. In any case, a library is a very simple, well-structured XML file that can be edited with any editor (e.g., Notepad). Perhaps this will work for you:
Look at an existing library with an editor to understand the structure. Then export your Excel sheet as an XML file and edit it with an editor if necessary.
This is just an idea of mine; I haven’t tried it yet.
Would you be able to post an example CSV or Excel file to have a play with?
I can only offer a screenshot of nodepad++ displaying my materialbibliothek,clb
an the file itself
materialbibliothek.clb (6,4 KB)
There is a tutorial on how to import and export XML Files with Excel …
Exportieren von XML-Daten - Microsoft-Support
You have to change language … this is an example in German, see de-de part of the link.
I’ve now followed the Microsoft instructions and imported the material library into Excel.
This Excel file was created:
materialbibliothek.txt (13,5 KB)
Please rename file-extension from txt to xlsx
ChatGPT was able to do this for me. I created a dummy so it would have the xml format and it converted it. I converted the values from the manual into Excel using a photo import, then had ChatGPT do the conversion.
