I want my ABAQUS script to read values from excel (these values will be used to create the FE Model). After the analysis, I want to extract the results (for example, maximum displacement) and save it in another excel file.
there are several python libraries to read/write excel. install them in abaqus python
Excel is not a file format. The spreadsheet can simply be saved/exported as csv or tsv which can be used as any other normal file in any script.
Saving the excel file in csv format works. Just need to add the following lines to the script:
import csv
with open('data.csv') as f:
{
x = csv.reader(f)
values = list(x)
}
Note that "values" is a list containing each row of data.csv as individual lists.
You can modify the input file with the help of a python script. The script can be executed using Abaqus Python. For reading and writing purposes, you can use OpenPyXL, xlrd, xlwt, XlsxWriter etc. modules. You have to install a few of these modules.
Dear Siddharth Srivastava
Yes it's possible to import the pandas python library into your environment code reference.
Example :
import pandas as pd from pandas import ExcelWriter from pandas import ExcelFile df = pd.read_excel('File.xlsx', sheetname='Sheet1') print("Column headings:") print(df.columns)
- Badges
- Science topic