LibreOffice Calc function

[tlevine]

As a LibreOffice Calc user, I want a Calc function that lets me query treasury.io so I can load treasury data into Calc. The call might look like this.

=TREASURYIO('SELECT * FROM t1')

and it would populate as many cells as the table has.

You can write Calc functions in Python, so this will be pleasant.

[tlevine]

@EricSchles might do this in Python. I'm gonna try it in Basic now. This page was helpful.

[EricSchles]

Thanks Tom! I'll be working on this today in the afternoon. Working on
another project this morning.

On Thu, Jul 4, 2013 at 8:35 AM, Thomas Levine [email protected]:

@EricSchles https://github.com/EricSchles might do this in Python. I'm
gonna try it in Basic now. This pagehttp://www.open-of-course.org/courses/file.php/86/Calc/H12/H12.htmlwas helpful.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/72#issuecomment-20483034
.

[tlevine]

Awesome!

And do Python. Parsing JSON in OpenOffice Basic looks painful, and making web requests looks almost as bad. I was mainly doing it so I could port it to Excel for issue #61 .

[EricSchles]

Thanks for the advice. Will do!

On Thu, Jul 4, 2013 at 9:23 AM, Thomas Levine [email protected]:

Awesome!

And do Python. Parsing JSON in OpenOffice Basic looks painful, and making
web requests looks almost as bad. I was mainly doing it so I could port it
to Excel.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/72#issuecomment-20485053
.

[cezary4]

For those of us who are Microsoft Office buffs, what is LibreOffice Calc?
Is it like an add-in module that helps you call the data directly in a
spreadsheet?

Cezary

On Thu, Jul 4, 2013 at 12:23 PM, Thomas Levine [email protected]:

Awesome!

And do Python. Parsing JSON in OpenOffice Basic looks painful, and making
web requests looks almost as bad. I was mainly doing it so I could port it
to Excel.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/72#issuecomment-20485053
.

Cezary Podkul
mobile: 708 228 1319

[EricSchles]

It's an open source version of microsoft excel. Its basically the same
thing. Does all the same stuff.

On Thu, Jul 4, 2013 at 2:27 PM, cezary4 [email protected] wrote:

For those of us who are Microsoft Office buffs, what is LibreOffice Calc?
Is it like an add-in module that helps you call the data directly in a
spreadsheet?

Cezary

On Thu, Jul 4, 2013 at 12:23 PM, Thomas Levine [email protected]:

Awesome!

And do Python. Parsing JSON in OpenOffice Basic looks painful, and
making
web requests looks almost as bad. I was mainly doing it so I could port
it
to Excel.

—
Reply to this email directly or view it on GitHub<
https://github.com/csvsoundsystem/federal-treasury-api/issues/72#issuecomment-20485053>

.

Cezary Podkul
mobile: 708 228 1319

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/72#issuecomment-20494013
.

[mhkeller]

@EricSchles if you still want to do this that would be cool. otherwise moving to close