Password Encrypted Excel file Sorcee

[Ajith1]

Hi 

Could you please attached my Requirement file.

I need to be load a file Row 18 before Row data  I don't want it

Note: Source file I have a Password (Encrypted File) I'm not able to load Encrypted file in community 

Please Suggest to me........

[pedrodrfaria]

Can you provide a screenshot to how the data looks right after the R tool?

Is the configuration on the select records exactly where you wish to start the data?

[Ajith1]

@pedrodrfaria 

I'm getting attached screenshot result after R tool

[pedrodrfaria]

This was not the example you sent over last time. You were asking about how to begin from a specific row, in your case row 18. This example right now only has one row, so I'm confused about your ask. You loaded the encrypted file into Alteryx using R, but this file in this screen shot only has one row. 

Did you try to do this workflow with the encrypted file you mentioned in this post? I attached the file you sent over last time to make sure I'm being clear.

Pedro. 

[Ajith1]

@pedrodrfaria 

Yes this is my actual requirement begins from a specific row, in my case row 18 but it will be varying some time.

If I'm taking the same file also it will be shown the wrong data.

Note: by using the R tool it can't be taking blank Rows and Columns

Example :

Input :

Name	sal		Location
Ajith	raj		jskf
weqw	ewwq		eqw
ewqe	e		wew

But it will be returns

Name	sal
Ajith	raj

I have a few blank columns and rows

Output like the need for me 

Name	sal	Location
Ajith	raj	jskf
weqw	ewwq	eqw
ewqe	e	wew

[pedrodrfaria]

Hi @Ajith1 

This is something different that the original topic is. We do ask if you have different questions to open a new topic as it makes it easier for people to help you and for people to look for similar issues.

If you are simply trying to remove null columns and null rows you can add a Data Cleansing and remove these null values. Please see the configurations below:

[Ajith1]

Hi  @pedrodrfaria 

Good.....😊

If I have the same scenario but  my data with an Encrypted file (Password Protected Excel)

Could you please Suggest to me. how can I resolve this scenario

[pedrodrfaria · Accepted solution]

@Ajith1  You should do something like this:

Please, if you have any different questions unrelated to the original post, please assign a solution to this post and open a new post.

Pedro.

[Ajith1]

Hi@pedrodrfaria 

Could you please help me till I'm getting the same error.

FYR.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/R-Code-based-excel-file-reading/td-p/6...

[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