search

csvsoundsystem / federal-treasury-api

The scraper, parser, and database creation scripts for Financial Management Service daily U.S. Treasury statements.
www.treasury.io/
105 stars 27 forks source link

LibreOffice Calc function #72

Open tlevine opened 11 years ago

tlevine commented 11 years ago

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 commented 11 years ago

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

EricSchles commented 11 years ago

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 notifications@github.comwrote:

@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/csvsoundsystem/federal-treasury-api/issues/72#issuecomment-20483034 .

tlevine commented 11 years ago

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 commented 11 years ago

Thanks for the advice. Will do!

On Thu, Jul 4, 2013 at 9:23 AM, Thomas Levine notifications@github.comwrote:

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/csvsoundsystem/federal-treasury-api/issues/72#issuecomment-20485053 .

cezary4 commented 11 years ago

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 notifications@github.comwrote:

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/csvsoundsystem/federal-treasury-api/issues/72#issuecomment-20485053 .

Cezary Podkul mobile: 708 228 1319

EricSchles commented 11 years ago

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 notifications@github.com 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 notifications@github.comwrote:

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/csvsoundsystem/federal-treasury-api/issues/72#issuecomment-20494013 .

mhkeller commented 7 years ago

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