How to open excel with a password?

Hi everyone!

Could you please help me with opening by Input an excel that has a password?

I would like to use workflow in Alteryx for a number of excels with password, so I prefer possibility to remove password/or possibility to read such file in Alteryx, rather than remove password in Excel every time I want to run workflow.

I know there are similar topics to this, but I don't know how to run macro in Alteryx.

Also, there is one advice to use Directory tool and then formula and R.

But I have no idea what to put in the formula tool to open excel.

I would be very grateful, I'm working on encrypted excels all the time.

Developer Tools

Input

R Tool

Accepted answers

rkapoor

@joanq try the attached workflow.

Input your password protected Excel sheet, in the formula tool update your password (now the workflow has it as "alteryx"), and run.

The browse tool will show you the data in your Excel sheet.

Excel.yxzp

All comments

rkapoor

@joanq try the attached workflow.

Input your password protected Excel sheet, in the formula tool update your password (now the workflow has it as "alteryx"), and run.

The browse tool will show you the data in your Excel sheet.

Excel.yxzp

joanq

thank you, can you please attached screen shots of this workflow and formula tool especially?

I can't open your Excel.yxzp file becasue I have older version of alteryx.

I'm using Designer x64.

Alexandra_Pops

Hellooo, RishiK!

Thank you so very much for your answer on this topic!

Nevertheless, I seem to be hitting a road block since when I click on Run, it flows to the R tool where it stays at 50% and this thing happens: these characters come one after another in a loop \ | / - no error, no nothing. I attach printscreen.

Do you think you could help with this?

P.S. As I was writing this, suddenly my excel file opened on my computer, outside Alteryx and it prompted the little window for the password. The percentage in Alteryx stayed at 50% still looping through those characters.

Thank you so very much!

Pops

R tool thinking.PNG

Smriti2107

The below solution works for MAC & Windows

Python based solution -

from ayx import Package

from ayx import Alteryx
Package.installPackages(['pandas','xlwings'])

import pandas as pd
import xlwings as xw

//place your path here

PATH = r'C:\Users\smrit\OneDrive\Documents\Alteryx\Book2.xlsx'

wb = xw.Book(PATH,password='12345')

// I renamed my sheet1 as sample
sheet = wb.sheets['sample']

df = sheet[sheet.used_range.address].options(pd.DataFrame, index=False, header=True).value
df

Please check the attached workflow -

New Workflow1.yxmd

tomekgagola

Would you have the same but with Python?

Also, any idea why the R scripts shows error as below?

Error: R (4): The R.exe exit code (3221225477) indicated an error.

sgaryali

I used this but I am facing this error-

What can be done to resolve this?

pcatterson

I think I have this working, but it just pulls the last sheet. Is there a way to change the instructions to specify which sheet to bring into alteryx?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280