Import existing excel data

Ignition
1

Hi ,

Is it possible to use column values from an existing excel in Ignition (which is on my own computer)?

Thanks

2

You would have to use a file upload component to push it into Ignition. You would then typically load the bytes of the file in the Apache POI library (provided with Ignition) to extract what you wish from the spreadsheet. Then push that information into tags or database tables that the rest of Ignition can use.

3

What are you trying to accomplish with the file?

Write the column values to a database? Use in a component?

More information goes a long way towards directing the solution.

4

I want to run an API for loop with the column values and use the data from the API response
example in python:

excel_file = 'data.xlsx'
df = pd.read_excel(excel_file)

column_values = df['A'].tolist()

api_url = 'https://api.example.com/data'

for value in column_values:
    response = requests.get(f"{api_url}?param={value}")