How to properly export data from EDEM to Excel

Clemenslischka

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!

RWood

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