DEV Community

Yusuke arakawa
Yusuke arakawa

Posted on

2 1

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.

AWS Security LIVE!

Join us for AWS Security LIVE!

Discover the future of cloud security. Tune in live for trends, tips, and solutions from AWS and AWS Partners.

Learn More

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay