hexagon logo

how to read op2 files into excel

how to read op2 files into excel
Parents
  • @Guillermo Salgado​ Sanjay makes an important point about the HDF5 output file available starting with Nastran 2016. HDF5 is more than a file format; it's a data model with an open source library (API). The HDF5 Group provides a Java browser you can use to open and view your data. From there, you can copy/paste the data to another application (like Excel). That's faster than writing a program (and is a lot easier!) If you need to do this frequently, or need to automate, you can use various APIs to access the data. Examples are provided in the 2016 and 2017 Release Guides. Note: Nastran H5 file includes both results and input data. Also, H5 file can be attached to Patran 2017, and has much better performance compared to XDB, OP2 (old) and OP2 (new).
Reply
  • @Guillermo Salgado​ Sanjay makes an important point about the HDF5 output file available starting with Nastran 2016. HDF5 is more than a file format; it's a data model with an open source library (API). The HDF5 Group provides a Java browser you can use to open and view your data. From there, you can copy/paste the data to another application (like Excel). That's faster than writing a program (and is a lot easier!) If you need to do this frequently, or need to automate, you can use various APIs to access the data. Examples are provided in the 2016 and 2017 Release Guides. Note: Nastran H5 file includes both results and input data. Also, H5 file can be attached to Patran 2017, and has much better performance compared to XDB, OP2 (old) and OP2 (new).
Children
No Data