loading...

Why I want to use JSON in LibreOffice Calc.

arachan profile image Yusuke arakawa ・1 min read

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.

Posted on by:

arachan profile

Yusuke arakawa

@arachan

IT section: Access VB.net FileMaker Citirx informix JaserReports Java Python3

Discussion

markdown guide