Hi Could you please attached my Requirement file.
I need to be load a file Row 18 before Row data I don't want itNote: Source file I have a Password (Encrypted File) I'm not able to load Encrypted file in community Please Suggest to me........
@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.
Hi @Ajith1
You can select the range if there is a specific range you want to pull data from
Or you can select you want to begin from line X. See option #7 in the configuration.
@pedrodrfaria But in my requirement, I have an Encrypted Excel File.Note: Due Alteryx Community Guidelines I'm Not able to load the Sample file please attached my file.
The below solution works for MAC & Windows
Python based solution -
from ayx import Package
from ayx import AlteryxPackage.installPackages(['pandas','xlwings'])
import pandas as pdimport 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 samplesheet = wb.sheets['sample']
df = sheet[sheet.used_range.address].options(pd.DataFrame, index=False, header=True).valuedf
