hello, i am trying to understand working with Excel files WITHOUT having Excel application installed locally.
from what I understand, i can use xlsx file without having Excel installed as per, https://www.uipath.com/kb-articles/excel-integration-approaches
“Through this app integration approach you are able to read/write Excel documents. If the document is newer than 2007, with .xlsx extension, you can work directly with the file. Otherwise, if it has .xls extension, Microsoft Office is a must. This is the default behaviour for all Excel activities but you can opt to work with the Excel Application.”
also unchecking “visible” option in Excel App activity, is supposed to allow to work with excel files with Excel installed, https://activities.uipath.com/docs/excel-application-scope
"Visible - When selected, the Excel file is opened in the foreground while performing actions on it. When it is cleared, all operations are done in the background, and you can run a workflow without having MS Office Excel installed on the machine"
it doesnt work for me… any insight? thanks