Hello,
We are generating .xls worklist files using python - and we are unable to open the file in Venus before the Excel file has been opened and closed in Excel (even without saving). Does anyone know how to fix this issue?
Hello,
We are generating .xls worklist files using python - and we are unable to open the file in Venus before the Excel file has been opened and closed in Excel (even without saving). Does anyone know how to fix this issue?
Are you closing the Workbook/File in the python script after writing to the file?
Not really sure what to answer But we have made a generic code snippet of what the python script does (see below). The xls output file is not recognized/parsed, when using the Column Specification Helper in the “File Open - New” step:
But after opening and closing the output file in Excel, the file format is recognized/parsed:
Code snippet:
import pandas as pd
import xlwt
data1 = {
‘Name’: [‘Alice’, ‘Bob’, ‘Charlie’],
‘Age’: [25, 30, 35],
‘City’: [‘New York’, ‘Los Angeles’, ‘Chicago’]
}
df1 = pd.DataFrame(data1)
df1.to_excel(‘my_worklist.xls’, engine=‘xlwt’, index = False)