Working WITHOUT Excel Application, visible option unchecked

excel
activities

#1

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


#2

hi, here is another example. I have an .xlsx file, the visible option is unchecked and i get the “must install Excel” error message. from the help section, UIPath is supposed to work under these conditions…


#3

@JR1
Follow below link once


#4

i guess you didnt read my post. I DONT HAVE EXCEL INSTALLED. UI PATH is supposed to work withOUT having Excel installed. re-read my posting…thanks


#5

Hi,

I guess that’s an error in documentation. Reading from https://activities.uipath.com/docs/excel-excel-application-scope

  1. This activity can only be used if the Microsoft Excel application is installed on your machine.
  2. …and you can run a workflow without having MS Office Excel installed on the machine.

Both should not be able to be true at the same time :wink:

If you want to work with Excel files without Excel installed, you could use Workbook activities instead. (https://activities.uipath.com/docs/file-workbook)

image


#6

Hi Antti,

The documentation was updated. The link you provided is an old version.
Please check this:


#7

Hei @Antti

Not sure where you got that link from, but that’s an outdated version of that activity. I recommend always using the search portal at https://activities.uipath.com for the updated version of the guides.

https://activities.uipath.com/docs/excel-application-scope - here’s the correct page for that activity.

Cheers!


#8

Hi @ovi / @Tech_Scribe

Thanks, didn’t see that the link was outdated, just used the same link that was on the first post :slight_smile:


#9

Yes, we’re investigating so that it is redirected to the right page. Thanks for pointing it out anyways!


#10

all information I found regarding Excel App activity and details and based on public searches.

1 link that connects UI activities with help via F1 key while in UI seems to be updated since I posted. The other link done by a search is still outdated, https://www.uipath.com/kb-articles/excel-integration-approaches

thanks for clarifying. to finalize, Excel MUST BE INSTALLED, the “Visible” option only pertains if you want Excel to open itself and be visible to user, or unchecked to work in background unopened.


#11

Hey Man,

I am running through a similar issue.
So you are saying we must have excel application isntalled is it? I don;t have the excel application installed in server, would that be an issue?


#12

Aloha UIPath
My customer has MS Excel MS Office 2016 install with no active licence. What I would like to do is use XLSX file integration without Excel. I am not sure that un-checking visible will do this. What is needed here is to bring back the deprecated Use Excel checkbox that was on the old Open Workbook activity.

Mahalo