[gohwaikien]

Hi,

I was trying to open excel file and text file using ANSA scripting with
utils.XlsxOpen and it didn't work. Does anyone have any idea?

[acurley31]

Make sure your import statements are correct. You may also want to check your file path that you are trying to open from within the script to make sure it actually exists.

# Importing just ansa
import os
import ansa

filename = "/path/to/my/xlsx/file"
fileExists = os.path.exists(filename)    # Check to make sure the file exists

xl_element = ansa.utils.XlsxOpen(filename)
ansa.utils.XlsxClose(xl_element)

# Importing ansa.utils
from ansa import utils

xl_element = utils.XlsxOpen(filename)
utils.XlsxClose(xl_element)