Upload/download of .xls instead of .ivenn only

[heberleh]

Users can download/upload as .ivenn, but it makes much more sense to upload/downlod .xls (Excel) tables since Biologists use that software.

They copy/paste the sets, currently, from a spreadsheet to the InteractiVenn. Then they decide if they want to save the result by downloading the .ivenn.

An option to upload XLS could follow the standard:

• each column is a set
• first row is the set name
• follow rows are elements
• the first 6 columns are parsed into sets (can have fewer columns, can have more, but only up to six are read)
• values in cells must be "trimmed"
• values must be unique (a test must be run and alert a pop-up or show a modal when duplicates are found, and tell users that we ignored duplicates, therefore the total number of elements is smaller than what they find in the spreadsheet)

[saket-shukla]

Hello,

I'm interested in contributing on this project. Please let me know if this issue is still open.

[heberleh]

Hi @saket-shukla, it is still open. Thanks for reaching out! There is a dev branch that you can use to contribute. It is an ongoing migration to React.

I gave it another thought and I consider that .xls/xlsx will be much better than .csv because Biologists use Excel in general and .csv is not very compatible with Excel, not without importing and converting standards to their native language.

To contribute, you can make use of https://www.npmjs.com/package/exceljs to read/save .xls instead of .ivenn. Reading .ivenn however needs to be still supported in case users have those files saved already.

The project needs to still be migrated to use NPM too. You are welcome to define the scope of your contribution.

[heberleh]

Not necessary for your contribution but good to know: in the dev branch I added an interactivenn folder with a basic idea of the new structure of the project in Typescript with React and npm using create-react-app.