New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excel Support for Publishing and Consuming Tabular Data Packages #41

Closed
rufuspollock opened this Issue Apr 23, 2013 · 17 comments

Comments

Projects
None yet
9 participants
@rufuspollock
Contributor

rufuspollock commented Apr 23, 2013

  • Load a Tabular Data Package from a URL
  • [Bonus] Search the primary Data Package registry (data.okfn.org/data) and then load the selected Data Package

We should look at Web Query Files: https://support.microsoft.com/en-us/kb/157482

@rufuspollock rufuspollock changed the title from Excel Macro to import a datapackage from a URL to Excel Add-in / Macro to import a datapackage from a URL Aug 24, 2014

@rufuspollock rufuspollock changed the title from Excel Add-in / Macro to import a datapackage from a URL to Excel Support for Publishing and Consuming Tabular Data Packages Apr 23, 2015

@paulharris

This comment has been minimized.

Show comment
Hide comment
@paulharris

paulharris Jun 16, 2015

It would be good to be able to load a datapackage+CSV in Excel from local disk AND correctly set up Excel's formats (eg so it doesn't screw with the date format in the CSV).

paulharris commented Jun 16, 2015

It would be good to be able to load a datapackage+CSV in Excel from local disk AND correctly set up Excel's formats (eg so it doesn't screw with the date format in the CSV).

@rufuspollock

This comment has been minimized.

Show comment
Hide comment
@rufuspollock

rufuspollock Jun 16, 2015

Contributor

@paulharris +1 - that's exactly what is wanted. I guess this is macro style stuff (?) - i am not an excel user!

Contributor

rufuspollock commented Jun 16, 2015

@paulharris +1 - that's exactly what is wanted. I guess this is macro style stuff (?) - i am not an excel user!

@paulharris

This comment has been minimized.

Show comment
Hide comment
@paulharris

paulharris Jun 17, 2015

I'm not sure, I don't use excel much either,
But I know users who like to, and it would be nice if excel wouldn't mess
with the date format.

We use the iso date + time format, and excel likes to change it to either :

Just the date (American style, which we don't use)
Or
Just the time (drop date and milliseconds)

Helpful!
On 16 Jun 2015 10:52 pm, "Rufus Pollock" notifications@github.com wrote:

@paulharris https://github.com/paulharris +1 - that's exactly what is
wanted. I guess this is macro style stuff (?) - i am not an excel user!


Reply to this email directly or view it on GitHub
#41 (comment).

paulharris commented Jun 17, 2015

I'm not sure, I don't use excel much either,
But I know users who like to, and it would be nice if excel wouldn't mess
with the date format.

We use the iso date + time format, and excel likes to change it to either :

Just the date (American style, which we don't use)
Or
Just the time (drop date and milliseconds)

Helpful!
On 16 Jun 2015 10:52 pm, "Rufus Pollock" notifications@github.com wrote:

@paulharris https://github.com/paulharris +1 - that's exactly what is
wanted. I guess this is macro style stuff (?) - i am not an excel user!


Reply to this email directly or view it on GitHub
#41 (comment).

@mattfullerton

This comment has been minimized.

Show comment
Hide comment
@mattfullerton

mattfullerton Jun 17, 2015

Should we just build a simple webservice that serves an Excel given a data package URL or posted data package as zip? i.e. ?url=mypackagelink.zip&output=xlsx

mattfullerton commented Jun 17, 2015

Should we just build a simple webservice that serves an Excel given a data package URL or posted data package as zip? i.e. ?url=mypackagelink.zip&output=xlsx

@rufuspollock

This comment has been minimized.

Show comment
Hide comment
@rufuspollock

rufuspollock Jun 17, 2015

Contributor

@mattfullerton that's export and i think import (consumption) is probably no 1. Also one probably does want it built in if you can rather than having to go through external service but external service would be nice too!

Contributor

rufuspollock commented Jun 17, 2015

@mattfullerton that's export and i think import (consumption) is probably no 1. Also one probably does want it built in if you can rather than having to go through external service but external service would be nice too!

@mattfullerton

This comment has been minimized.

Show comment
Hide comment
@mattfullerton

mattfullerton Jun 17, 2015

I know its nice to have it built in. I just figured export=import if the
service is easy. Can Excel open URLs?

Otherwise, the solution would probably be to write a plugin using Visual
Basic. We've done that here for CKAN->Webservice->MS Word and keep talking
about an Excel counterpart.

mattfullerton commented Jun 17, 2015

I know its nice to have it built in. I just figured export=import if the
service is easy. Can Excel open URLs?

Otherwise, the solution would probably be to write a plugin using Visual
Basic. We've done that here for CKAN->Webservice->MS Word and keep talking
about an Excel counterpart.

@paulharris

This comment has been minimized.

Show comment
Hide comment
@paulharris

paulharris Jun 18, 2015

It would need to be an off-line solution for me.
eg, XWiki had/has something you can install and it adds a button to MS Word.
Something like that. Then I imagine you'd click "Load Package" button, and/or "Load CSV".

paulharris commented Jun 18, 2015

It would need to be an off-line solution for me.
eg, XWiki had/has something you can install and it adds a button to MS Word.
Something like that. Then I imagine you'd click "Load Package" button, and/or "Load CSV".

@paulharris

This comment has been minimized.

Show comment
Hide comment
@paulharris

paulharris Jun 19, 2015

I personally would need a disconnect solution, because the users would be
opening datasets downloaded to their PCs.
Once downloaded, further network access is not guaranteed or and thus not
reliable.

On 18 June 2015 at 04:24, Matt Fullerton notifications@github.com wrote:

I know its nice to have it built in. I just figured export=import if the
service is easy. Can Excel open URLs?

Otherwise, the solution would probably be to write a plugin using Visual
Basic. We've done that here for CKAN->Webservice->MS Word and keep talking
about an Excel counterpart.

Matthew Fullerton
0176 5789 6501
Freiberuflicher Software Entwickler und EXIST Stipendiat beim
Gründungsvorhaben "Tapestry" - http://www.smartlane.de/
On 17 Jun 2015 9:48 pm, "Rufus Pollock" notifications@github.com wrote:

@mattfullerton https://github.com/mattfullerton that's export and i

think import (consumption) is probably no 1. Also one probably does want
it
built in if you can rather than having to go through external service but
external service would be nice too!


Reply to this email directly or view it on GitHub
<#41 (comment)
.


Reply to this email directly or view it on GitHub
#41 (comment).

paulharris commented Jun 19, 2015

I personally would need a disconnect solution, because the users would be
opening datasets downloaded to their PCs.
Once downloaded, further network access is not guaranteed or and thus not
reliable.

On 18 June 2015 at 04:24, Matt Fullerton notifications@github.com wrote:

I know its nice to have it built in. I just figured export=import if the
service is easy. Can Excel open URLs?

Otherwise, the solution would probably be to write a plugin using Visual
Basic. We've done that here for CKAN->Webservice->MS Word and keep talking
about an Excel counterpart.

Matthew Fullerton
0176 5789 6501
Freiberuflicher Software Entwickler und EXIST Stipendiat beim
Gründungsvorhaben "Tapestry" - http://www.smartlane.de/
On 17 Jun 2015 9:48 pm, "Rufus Pollock" notifications@github.com wrote:

@mattfullerton https://github.com/mattfullerton that's export and i

think import (consumption) is probably no 1. Also one probably does want
it
built in if you can rather than having to go through external service but
external service would be nice too!


Reply to this email directly or view it on GitHub
<#41 (comment)
.


Reply to this email directly or view it on GitHub
#41 (comment).

@Stephen-Gates

This comment has been minimized.

Show comment
Hide comment
@Stephen-Gates

Stephen-Gates Jun 19, 2015

Contributor

Here's something I tried to encourage Microsoft Australia to progress - no luck but for what it's worth...

Contributor

Stephen-Gates commented Jun 19, 2015

Here's something I tried to encourage Microsoft Australia to progress - no luck but for what it's worth...

@paulharris

This comment has been minimized.

Show comment
Hide comment
@paulharris

paulharris Jun 22, 2015

Wouldn't Libreoffice be more open/extendible?

On 19 June 2015 at 19:54, Stephen Gates notifications@github.com wrote:

Here's something
https://docs.google.com/document/d/1bJSQeY_jhwIpEgA4L64v_OEGV4ae8miU6vX8u-wtHMk/edit?usp=sharing
I tried to encourage Microsoft Australia to progress - no luck but for what
it's worth...


Reply to this email directly or view it on GitHub
#41 (comment).

paulharris commented Jun 22, 2015

Wouldn't Libreoffice be more open/extendible?

On 19 June 2015 at 19:54, Stephen Gates notifications@github.com wrote:

Here's something
https://docs.google.com/document/d/1bJSQeY_jhwIpEgA4L64v_OEGV4ae8miU6vX8u-wtHMk/edit?usp=sharing
I tried to encourage Microsoft Australia to progress - no luck but for what
it's worth...


Reply to this email directly or view it on GitHub
#41 (comment).

@akuckartz

This comment has been minimized.

Show comment
Hide comment
@akuckartz

akuckartz Jun 22, 2015

Wouldn't Libreoffice be more open/extendible?

Sure.

akuckartz commented Jun 22, 2015

Wouldn't Libreoffice be more open/extendible?

Sure.

@pwalsh

This comment has been minimized.

Show comment
Hide comment
@pwalsh

pwalsh Jun 22, 2015

Member

LibreOffice would be more open/extendible, but a solution that works with Excel would be many, many times more useful IMHO (think: government office workflows and so on).

Member

pwalsh commented Jun 22, 2015

LibreOffice would be more open/extendible, but a solution that works with Excel would be many, many times more useful IMHO (think: government office workflows and so on).

@mattfullerton

This comment has been minimized.

Show comment
Hide comment
@mattfullerton

mattfullerton Jun 22, 2015

mattfullerton commented Jun 22, 2015

@rufuspollock

This comment has been minimized.

Show comment
Hide comment
@rufuspollock

rufuspollock Jun 22, 2015

Contributor

@paulharris please open a separate issue for libreoffice support - that would be great :-)

Contributor

rufuspollock commented Jun 22, 2015

@paulharris please open a separate issue for libreoffice support - that would be great :-)

@jamiekt

This comment has been minimized.

Show comment
Hide comment
@jamiekt

jamiekt Mar 9, 2016

Hi folks,
Just wanted to say that the extensibility model for Excel these days is no longer COM addins nor Visual Basic. VBA is still supported (I think) however Microsoft are now pushing the Office add-in spec (codename agaves). The nice thing about agaves is that the dev language is javascript, here's an example: https://msdn.microsoft.com/en-us/library/office/jj220065.aspx. Another nice thing is that (AFAIK) add-ins work across the traditional Excel client, Excel Online, Excel on Mac, Excel on iOS & Excel on Android.

That is all.

jamiekt commented Mar 9, 2016

Hi folks,
Just wanted to say that the extensibility model for Excel these days is no longer COM addins nor Visual Basic. VBA is still supported (I think) however Microsoft are now pushing the Office add-in spec (codename agaves). The nice thing about agaves is that the dev language is javascript, here's an example: https://msdn.microsoft.com/en-us/library/office/jj220065.aspx. Another nice thing is that (AFAIK) add-ins work across the traditional Excel client, Excel Online, Excel on Mac, Excel on iOS & Excel on Android.

That is all.

@danfowler

This comment has been minimized.

Show comment
Hide comment
@danfowler

danfowler Mar 10, 2016

Contributor

Hi @jamiekt thanks for the update!

Contributor

danfowler commented Mar 10, 2016

Hi @jamiekt thanks for the update!

@danfowler danfowler closed this Aug 8, 2016

@danfowler danfowler removed the backlog label Aug 8, 2016

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment