Have a look at the attached links for help to your query : https://github.com/chintanp/python_abaqus/blob/master/simply_supported_script.py

https://www.youtube.com/watch?v=lco-r5CgvhY

https://www.youtube.com/watch?v=a5hT9oSPJKQ

Dear Syed Hasan Askari Rizvi

You can import the pandas python library to your environment code reference.

for the example:

import pandas as pd

from pandas import ExcelWriter

from pandas import ExcelFile

df = pd.read_excel('File.xlsx', sheetname='Sheet1')

for more information:

https://pythonspot.com/read-excel-with-pandas/

Hi Syed Hasan,

Abaqus python doesn't have pandas library, xlrd or other. I guess your Abaqus python version is 2.7 and hence has numpy only. I order to use data from excel file you will have to do a work around.

I did this

Created master script to read data from excel using regular python and saved my variables of interest and pickle files.

I then called the Abaqus python script using subprocess.call() .

In my Abaqus script i loaded the pickle file and used it there.

If you want to have a look at my code, you can email me.

Hope this helps.