How can I export a stream network to Excel?

[wschwanghart]

This is a question that came up in the blog: "Dear wschwanghart,
I want to apply the best fit curve to the longitudinal profile of a drainage basin, but how can I transfer long profile data to Excel?"

[wschwanghart]

Well, first of all, please reconsider why you want to have the data in Excel. Ok, you might be more familiar with Excel and its possibilities such as curve fitting, but please note that these are functionalities that MATLAB performs much better.
Still, if you really want to do it, here's how provided that you have a DEM and a STREAMobj S.

t = table;
[t.x,t.y,t.z,t.d] = STREAMobj2XY(S,DEM,S.distance);
writetable(t,'yourexcelfile.xlsx')

If your network consists of several rivers then t will contain rows with nans (so-called nan-punctuated vectors) to separate the river network into individual reaches.
In addition to the x and y coordinates of the network, the above code adds elevations and river distance to the table. You can add any other GRIDobj or node-attribute list such as flow accumulation grids.