How to properly export data from EDEM to Excel

Unknown
Unknown
edited December 2022 in Community Q&A

Hi all,

 

i want to export data from a EDEM run. I use the export -> Results data tab and create 4 queries which contain the diameter and x,y,z positions of my particles. After loading the data into Excel it shows the data for each particle in columns instead of rows. This gives me a headache, since Excel can only import a limited amount of columns, meaning the number of particles is restricted. Is there an easy work-around to this? I have so far not been able to see all the particle data in one Excel sheet.

Thanks!

Tagged:

Best Answer

  • RWood
    RWood
    Altair Employee
    edited December 2022 Answer ✓

    Hi,

    I don't know what settings you're using but the particle data should be stored by row, if you use the 'Standard' Query type. But, if that's not what you want then you can manipulate how many columns are used with the General > 'Line Break at    Columns' setting (from within the Export Results Data dialog). This defaults to 255 columns. 

    I haven't played around with these settings in a while but from memory that's about all you can control from here, as regards columns/rows. For more detailed data extraction you would probably be better off using EDEMpy.

    Richard

Answers

  • RWood
    RWood
    Altair Employee
    edited December 2022 Answer ✓

    Hi,

    I don't know what settings you're using but the particle data should be stored by row, if you use the 'Standard' Query type. But, if that's not what you want then you can manipulate how many columns are used with the General > 'Line Break at    Columns' setting (from within the Export Results Data dialog). This defaults to 255 columns. 

    I haven't played around with these settings in a while but from memory that's about all you can control from here, as regards columns/rows. For more detailed data extraction you would probably be better off using EDEMpy.

    Richard

  • Prasad Avilala_20558
    Prasad Avilala_20558
    Altair Employee
    edited November 2022
    Richard Wood_20774 said:

    Hi,

    I don't know what settings you're using but the particle data should be stored by row, if you use the 'Standard' Query type. But, if that's not what you want then you can manipulate how many columns are used with the General > 'Line Break at    Columns' setting (from within the Export Results Data dialog). This defaults to 255 columns. 

    I haven't played around with these settings in a while but from memory that's about all you can control from here, as regards columns/rows. For more detailed data extraction you would probably be better off using EDEMpy.

    Richard

    Hi Clemens,

    In addition to Richard comments, what I would recommend for the diameter data to export is Histogram.

    i.e in Analyst under graph section, you can plot the diameter vs particle number it gives you simplified data.

    Regarding co-ordinates position of particles there is no option except using standard option as Richard said.

    Thanks,

    Prasad A

Categories