• State Resolved
  • Locked Locked
  • Replies 2 replies
  • Subscribers 53 subscribers
  • Views 860 views
  • Users 0 members are here
Support feedback
Options
Options
Similar topics

This thread has been locked.

If you have a related question, please click the "Ask a related question" button in the top right corner. The newly created question will be automatically linked to this question.

Best way to move data from expression window to Excel or text file for analysis.

stevenh
Guru 20035 points

Hello,

My code has several large arrays (5 of them each of size 500) and I am copying the arrays from the expression window to excel for analysis.

Each array is broken up into groups of 99 elements, so for 5 arrays I have to expand 25 groups and then copy all groups at once to an excel spreadsheet. After copying them to excel, I have to format them so each of the array's value is shown in a separate column.

The copying and formating process is rather laborous.

Is there an easier way?

Thanks,
Stephen 

  • 0
    TI__Guru**** 451251 points

    Hi Stephen,

    Honestly, I'd just write a small DSS javascript that I can run from the scripting console to save all the values to a csv file in whatever format you wish. If you are not familiar with DSS or javascript, that would cause a bit of a learning curve however. But you have the most control over how the data is exported.

    If I think of an easier solution, I'll let you know.

    Thanks

    ki

  • 0 in reply to Ki
    Guru 20035 points

    Hello Ki,

    Thanks.

    Stephen