sankeymatic icon indicating copy to clipboard operation
sankeymatic copied to clipboard

Support pasting of values from Excel

Open nowthis opened this issue 9 years ago • 0 comments

Instead of insisting on the SankeyMATIC format for specifying flows, allow people to just copy some cells from a spreadsheet and paste them in & get the results they expect.

I believe the right way to support this would be to expect three columns of pasted data.

  • Figure out which column has the numeric values. Could be column 1 or 2 or 3
  • Once we know which two columns are not the values, presume the first column of the two is the Source & the second is the Target.
  • Rearrange the values into the SankeyMATIC syntax
  • Paste the result into the data-editing field.
  • Handle sensing & skipping a header row, maybe.

nowthis avatar Sep 06 '15 23:09 nowthis