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

[Proposal] Import from document editor #105

Open
ocdtrekkie opened this Issue Aug 22, 2014 · 9 comments

Comments

Projects
None yet
4 participants
@ocdtrekkie

ocdtrekkie commented Aug 22, 2014

One thing both Excel and Google Sheets have in common notably, is the fact that you can create a spreadsheet document outright, and then import data into it. Whereas EtherCalc's current flow is to either import a document or create a document.

The implementation I am using inside Sandstorm, basically has a single new document option, so it goes directly to the document editor. I'm dubious of my own ability to implement this, but it'd be great if there was a way to access the data import functionality from inside the spreadsheet editor. With, I assume, a warning about the incoming data overwrite if you proceed.

A use case for this that would also apply to ethercalc.org was if you had a shared EtherCalc URL for sharing data with someone, but you have been editing via a desktop app, like Excel, and wanted to update the entire sheet, at the same URL with what you've been working on offline.

@audreyt audreyt added the enhancement label Aug 23, 2014

@audreyt

This comment has been minimized.

Owner

audreyt commented Aug 23, 2014

That's a good idea. We need to factor the relevant code out of start.html and make index.html use it too. Before that gets implemented, one viable workaround may be import-to-create and then copy the spreadsheet into an existing spreadsheet (using the Clipboard tab one can also keep formulas.)

@audreyt

This comment has been minimized.

Owner

audreyt commented Dec 27, 2014

There is now an API for importing an Excel file to a specific room:

curl -i -X PUT --data-binary @file.xlsx http://HOST/_/ID

The limitation of this REST API is, however, that only the first sheet in the XLSX file is used.

I'll work on a multi-sheet aware importing UI as part of #138 ; closing this one as duplicate.

@audreyt audreyt closed this Dec 27, 2014

@ocdtrekkie

This comment has been minimized.

ocdtrekkie commented Dec 27, 2014

Cool! Will you be able to implement this through a file picker for the Sandstorm port? I am very excited about the possibility of migrating away from Google Drive.

@audreyt

This comment has been minimized.

Owner

audreyt commented Jan 2, 2015

Re-opening for Sandstorm file picker and server-side importing option (for clients that can't afford to convert XLSX in JS).

@audreyt audreyt reopened this Jan 2, 2015

@OliverHi

This comment has been minimized.

OliverHi commented May 12, 2016

I have a similiar (or the same?) question: I want to import an excel file into an ethercalc grain in sandstorm. New one or existing one doesn't really matter for me.
Is that possible yet? I couldn't find out how.

@ocdtrekkie

This comment has been minimized.

ocdtrekkie commented May 12, 2016

@OliverHi You can! Drag the file you want to import onto the "Sheet1" tab on the bottom of your EtherCalc window! It'll overwrite the existing sheet contents.

@OliverHi

This comment has been minimized.

OliverHi commented May 12, 2016

Ah thank you a lot!! Working fine for me :)
I would still suggest to make that more obvious (as well as the download button).

@ocdtrekkie

This comment has been minimized.

ocdtrekkie commented May 12, 2016

Yeah, my personal opinion is it makes sense to have a menu option somewhere up top that lets you open a file selection dialog and stuff. But I'm glad I was able to help you figure out how to use the feature that exists as it does now!

@loleg

This comment has been minimized.

loleg commented Dec 2, 2018

The import on the homepage is easy to miss (i.e. not very user friendly) and currently broken (#651), and on top of that users may want to upload into an existing sheet. The trick with dropping onto the Sheet1 tab sounds cool, but definitely needs UI work to be discoverable.

I've started a bounty on this issue in hope that this work resumes at https://www.bountysource.com/issues/3992780-proposal-import-from-document-editor

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