DEV Community

Yusuke arakawa
Yusuke arakawa

Posted on

Why I want to use JSON in LibreOffice Calc.

Recently, Web Service exports JSON.
It is not SOAP, not XML.
Web Data is JSON.

  • Address search from PostalCode
  • Weather

....etc

If Calc can use JSON and WebAPI,
Calc borrow Functions from Web.

Use Python, It is easy.
Is it need to use by calc?

No.
Office Worker don't use Python.
They said.
VLOOKUP is wonderful!
VBA is awesome!
Python? what's?
I'm not a Programmer.

It is need to deal JSON and WebAPI in Calc for us.

Excel can use JSON.
Connect to a json file
LibreOffice don't have this function.

You make this function.

So, I develop underline Calc extensions.

It may be not enough.
ParseJSON don't work :-(

Finally, I want to make Calc Standerd Function them.

Top comments (0)