The Data menu in Calc has the entry Data Provider. It provides a dialog with a drop-down list Data Format. The type CSV works in principle (besides tdf#169019 or tdf#169036, for example). Has someone working examples for HTML, XML or SQL?
previous attempt(s) → What is Data Provider option in LibreOffie- Calc and how to use that one? - #3 by sv.thiyagarajan
→ LibreOffice Calc crashes when clicking on "Data Provider"
It does not crash for me in a current daily build.
Hello!
In my version 25.2.6.2 Win 10, this command opens a dialog without crashing (even though the command is missing from the Data menu).
Offtop. Data Provider purpose is similar to implementing a subset of Microsoft Power Query. Why play catch-up when you can get way ahead with Python under the hood?
1 Like