Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
I can't export my results to excel file when the results contains more than one matrics .
I am generating excel files for some results using the function(WRITEXCEL). When the matrics is vector which means has only one colunm it easily export it to excel file. However, when the results has more than one colunm like shown below it doesn't work. this error is on page 33. how can I solve that?
It shows error
Hi @YA_10963798,
Thank you for your question!
I’d like to recommend to bring more context to your initial inquiry.
Please refer to this guideline to make your questions more likely to receive a quick and useful answer.
Furthermore, please consult this Community Search guideline as well, which boosts up your chances of finding a resolution to your topic(s) much faster. Making use of our Knowledge Base.
Thank you for your participation and please let me know if you need further assistance!
Best regards,
So, you are using Prime 9. Should have mentioned that.
1st error: You cannot have the vertical bar character "|" in a file or path name.
2nd error. The variable is undefined. Make sure it is defined. If A.beta is a function (like you use it in the WRITEEXCEL call), then you must use it as a function in the expression above as well. OR vice versa.
3rd error. Q.CPT is a vector of vectors that is a nested array. WRITEEXCEL accepts only flat arrays. You may need to flatten it first.
Success!
L:uc
Hi,
Here is one way to flatten a nested matrix, Works only if nested matrix is only one level and all nested matrices are the same size like L.inters
Recovering the data from a flattened matrix file you need to know the stride as well as the data.
Cheers
Terry
Hi Terry,
I really appreciate your help. I tried to do the same however it did not work. Still showing the same error message.
How can I export the data of such vector to excel.
it should look like the following table: