Importing data from excel files in D3 js

Question

I am working on D3 js collapsible tree layout, i want to know is there any way we can directly feed the data from excel file rather than using json object file?

An Excel file has the extension .xlsx, so the answer is no. Using Excel you can save the file as CSV, and then load it using d3.csv. There are other JS libraries that parse xlsx spreadsheets, though. — Gerardo Furtado
– Gerardo Furtado, Commented Jan 29, 2018 at 6:06
On top of that, a tree layout uses hierarchical data... good luck encoding the hierarchical data in a CSV! — Gerardo Furtado
– Gerardo Furtado, Commented Jan 29, 2018 at 6:08
So my specific problem is there is folder present in sharepoint and i want to reflect the directory tree of that folder in d3 js collapisble tree. Any suggestions how should i proceed? — Tiru
– Tiru, Commented Jan 29, 2018 at 6:43

ctt · Accepted Answer · 2018-07-27 06:41:45Z

3

D3.js doesn’t have built-in Excel file format parser. It does, however, have a CSV format data parser. You can save your worksheet as CSV and use the resulting text as a source for the D3.js visualization.

edited Jul 27, 2018 at 6:41

ctt

1,4459 silver badges19 bronze badges

answered Jul 27, 2018 at 4:55

vaibhav pawar

811 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Importing data from excel files in D3 js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related