Open ocdtrekkie opened 10 years ago
audreyt
commented
10 years ago 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
commented
9 years ago 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.
ocdtrekkie
commented
9 years ago 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
commented
9 years ago Re-opening for Sandstorm file picker and server-side importing option (for clients that can't afford to convert XLSX in JS).
OliverHi
commented
8 years ago 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
commented
8 years ago @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
commented
8 years ago 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
commented
8 years ago 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
commented
5 years ago 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
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.