I have a 3D table that I'm able to plot using ListPlot3D, but when I export the table to an excel file and try to import the saved data, the format is different. The imported table seems to have additional commas everywhere, e.g.:
TableT = Parallelize[
Table[{x, y, Func[x, y]}, {x, -5.0, 5, 0.1}, {y, -5.0, 5, 0.1}]];
Export["C:\\Users\\Desktop\\Research \
Folders\\Rich\\MATHEMATICA ROUTINES\\Table.xls", TableT, "Table"];
SampleTable =
Import["C:\\Users\\Desktop\\Research \
Folders\\Rich\\MATHEMATICA ROUTINES\\Table.xls", "Table"];
And a sample of the output looks like:
{{"{-1.,", "-1.,", "-1.682941969615793}", "{-1.,", "-0.7,",
"-1.4481056235651328}", "{-1.,", "-0.4,", "-1.0839143149837285}",
"{-1.,", "-0.10000000000000009,", "-0.6229001688139496}", "{-1.,",
"0.19999999999999996,", "-0.10624420571720333}", "{-1.,", "0.5,",
"0.4199022358543263}", "{-1.,", "0.7999999999999998,",
"0.9085400612713314}"}, {"{-0.7,", "-1.,", "-1.4481056235651328}",
When I use this approach for 2D plots, it seems to work fine. Can someone explain why this isn't working for my 3D data?
$HomeDirectory
) for future code examples, this will be more convenient for users not sharing your exact directory structure. $\endgroup$