Export function

[airon90]

Is it possible to add an Export feature in order to save ods (or xls) file?
I extremely need it!
Thank you

[audreyt]

Hi! Currently there's no JavaScript-based SocialCalc-to-ODS/XLS writer; an possible workaround (as used here) is re-using Sheetnode's ODS/XLS exporter: https://drupal.org/project/sheetnode

[kradan]

Thanks Audry for this great work! There is node-odt (https://npmjs.org/package/odt), is this an option?

[Exceltoi]

Hello,

I think also that import or export to ods (or xls) will make Ethercalc more usable.
Export could be use for make a backup of a spreadsheet.

For import or export, is it possible to use and install these modules in Ethercalc and have you got a link to a description for that ?

 "Sheetnode Google Spreadsheets import/export module"   
 "Sheetnode PHPExcel import/export module"

[FunTimeCoding]

I would find this feature very nifty too. ods format that is, xls may cause licensing issues?
I tried to get along with the .csv export but if it wont export functions in a compatible syntax and instead just exports results without their formulae it may not be as useful. I mean.. how am I going to export a document that was collaboratively written, and at some point import it again? or is it just not meant to work that way?

[aspiers]

For reference, #51 covers .csv import/export.

[anarcat]

anyone working on this right now? this seems like a major blocker in adoption - we can import from xslx but not export... a little weird asymmetry...

[audreyt]

Hi @anarcat , I believe @SheetJS is working on a SocialCalc reader in https://github.com/SheetJS/j which uses https://github.com/SheetJS/js-harb — currently it supports simple values and formulas.

It doesn't yet use socialcalc's native parsing library ( which would yield something like https://ethercalc.org/_/g0v-cy/cells ), though. Ideally it might work by including a copy of SocialCalcModule.js to run ss.ParseSheetSave ( c.f. https://github.com/audreyt/ethercalc/blob/master/src/sc.ls#L254 ) to obtain the parsed sheet object.