# Exporting BSplineFunction to Excel

I am trying to export the data from a B Spline Function to a table in excel. I have tried exporting as many different file types (.xls, .txt, .dat), but all of them show up in excel as all of the data in one cell.

Currently, all I have successfully done is this, showing a plot of "data1", a set of ordered pairs that I imported, and the B-spline fit for this data set.

f = BSplineFunction[data1]
Show[
ListLinePlot[data1, PlotStyle -> Red],
ParametricPlot[f[t], {t, 0, 1}]]


I would like to export the data from the B-spline function in a way that can be viewed as a table in Excel.

• Can you give us some idea of what data1 looks like? – bill s May 30 '13 at 14:36
• data1 is a set of about 500 of these ordered pairs, with the x-coordinate ranging from 0.3 to 12, in varying step sizes: {0.3, 0.0558}, {0.302, 0.0556}, {0.304, 0.0554}, {0.306, 0.0552}, {0.308, 0.0552}, {0.31, 0.055}, {0.312, 0.0548}, {0.314, 0.0546}, {0.316, 0.0544},... – Mattie May 30 '13 at 14:46
• Now I don't understand: what do you mean the "data" from the Bspline... this is an interpolating function, it is not data. Do you want values of the f (the B-spline function) at certain points? – bill s May 30 '13 at 15:14
• Yes. sorry about that. I am looking for the values of f – Mattie May 30 '13 at 15:37

RandomInteger[{1, 10}, {20,2}];