Styjun

Applying for jobs with an obvious scar

Are there any Saints that have miraculously overcome death (should have died, but did not)?

Software need db owner permission to master database (sql2016)

How much water can a ship take on before sinking?

Is it legal for a supermarket to refuse to sell an adult beer if an adult with them doesn’t have their ID?

Is it possible to have a career in SciComp without contributing to arms research?

How slow can a car engine run?

Pauli exclusion principle - black holes

Why is Google approaching my VPS machine?

I have found a mistake on someone's code published online: what is the protocol?

Drawing a circle with nodes shift with Tikz

Can firbolgs cast their racial Detect Magic spell as a ritual?

Locked-up DOS computer beeped on keypress. What mechanism caused that?

What could make large expeditions ineffective for exploring territory full of dangers and valuable resources?

Round command argument before using

Why does a tetrahedral molecule like methane have a dipole moment of zero?

Word for something indicating the importance of guarding it properly

Which GPUs to get for Mathematical Optimization (if any)?

Who or what determines if a curse is valid or not?

Practical example in using (homotopy) type theory

Why do space operations use "nominal" to mean "working correctly"?

What are the basics of commands in Minecraft Java Edition?

Whipping heavy cream with melted chocolate

Why were these characters absent in Spider-Man: Far From Home?

how to import excel password file into python?

How do I check whether a file exists without exceptions?Calling an external command in PythonWhat are metaclasses in Python?How do I copy a file in Python?How can I safely create a nested directory?Does Python have a ternary conditional operator?How to get the current time in PythonHow can I make a time delay in Python?How do I list all files of a directory?Does Python have a string 'contains' substring method?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am importing excel password file into python and it's showing this error: No module named win32api. I've already installed pypiwin32.

import sys
import win32com.client

xlApp = win32com.client.Dispatch("Excel.Application")
print "Excel library version:", xlApp.Version
filename,password = 'C:UsersEbaseDocumentsPASSW.xlsx', '123456'
xlwb = xlApp.Workbooks.Open("C:UsersEbaseDocumentsPASSW.xlsx", False, True, None, "123456")

print(xlwb)

code here

python python-2.7

share|improve this question

edited Mar 26 at 9:53

Alderven

2,47044 gold badges1313 silver badges2828 bronze badges

asked Mar 26 at 9:48

yaswanthyaswanth

322 bronze badges

add a comment | 

0

I am importing excel password file into python and it's showing this error: No module named win32api. I've already installed pypiwin32.

import sys
import win32com.client

xlApp = win32com.client.Dispatch("Excel.Application")
print "Excel library version:", xlApp.Version
filename,password = 'C:UsersEbaseDocumentsPASSW.xlsx', '123456'
xlwb = xlApp.Workbooks.Open("C:UsersEbaseDocumentsPASSW.xlsx", False, True, None, "123456")

print(xlwb)

code here

python python-2.7

share|improve this question

edited Mar 26 at 9:53

Alderven

2,47044 gold badges1313 silver badges2828 bronze badges

asked Mar 26 at 9:48

yaswanthyaswanth

322 bronze badges

add a comment | 

I am importing excel password file into python and it's showing this error: No module named win32api. I've already installed pypiwin32.

import sys
import win32com.client

xlApp = win32com.client.Dispatch("Excel.Application")
print "Excel library version:", xlApp.Version
filename,password = 'C:UsersEbaseDocumentsPASSW.xlsx', '123456'
xlwb = xlApp.Workbooks.Open("C:UsersEbaseDocumentsPASSW.xlsx", False, True, None, "123456")

print(xlwb)

code here

python python-2.7

share|improve this question

edited Mar 26 at 9:53

Alderven

2,47044 gold badges1313 silver badges2828 bronze badges

asked Mar 26 at 9:48

yaswanthyaswanth

322 bronze badges

import sys
import win32com.client

xlApp = win32com.client.Dispatch("Excel.Application")
print "Excel library version:", xlApp.Version
filename,password = 'C:UsersEbaseDocumentsPASSW.xlsx', '123456'
xlwb = xlApp.Workbooks.Open("C:UsersEbaseDocumentsPASSW.xlsx", False, True, None, "123456")

print(xlwb)

share|improve this question

edited Mar 26 at 9:53

Alderven

2,47044 gold badges1313 silver badges2828 bronze badges

asked Mar 26 at 9:48

yaswanthyaswanth

322 bronze badges

share|improve this question

edited Mar 26 at 9:53

Alderven

2,47044 gold badges1313 silver badges2828 bronze badges

asked Mar 26 at 9:48

yaswanthyaswanth

322 bronze badges

edited Mar 26 at 9:53

Alderven

2,47044 gold badges1313 silver badges2828 bronze badges

edited Mar 26 at 9:53

Alderven

2,47044 gold badges1313 silver badges2828 bronze badges

asked Mar 26 at 9:48

yaswanthyaswanth

322 bronze badges

asked Mar 26 at 9:48

yaswanthyaswanth

322 bronze badges

1 Answer
1

active

oldest

votes

0

Did you try:

Excel_wb = xlApp.Workbooks.Open(filename, False, True, None, password)

It worked for me.

If this doesn't work,
Check this link for more details about the Open() method

Open takes two types of password, namely:

Password: password required to open a protected workbook.
WriteResPassword : password required to write to a write-reserved workbook

So in your case , is it write protected or protection on open?

To open reserved excel file try:

app.Workbooks.Open("filename.xls", 2, True, None, None, "secret")

share|improve this answer

edited Mar 26 at 10:05

answered Mar 26 at 9:52

Suraj MSuraj M

37099 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  showing error in importing files .what are the files require to import to run the code .i already installed pywin32
  
  – yaswanth
  Mar 26 at 10:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You have to pass absolute path to win32, when you open the excel file,Not relative path..
  
  – Suraj M
  Mar 26 at 10:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What error showing..?, did you close excel application at end xlwb.Save() and xlApp.Application.Quit()
  
  – Suraj M
  Mar 26 at 10:31
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55354075%2fhow-to-import-excel-password-file-into-python%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Did you try:

Excel_wb = xlApp.Workbooks.Open(filename, False, True, None, password)

It worked for me.

If this doesn't work,
Check this link for more details about the Open() method

Open takes two types of password, namely:

Password: password required to open a protected workbook.
WriteResPassword : password required to write to a write-reserved workbook

So in your case , is it write protected or protection on open?

To open reserved excel file try:

app.Workbooks.Open("filename.xls", 2, True, None, None, "secret")

share|improve this answer

edited Mar 26 at 10:05

answered Mar 26 at 9:52

Suraj MSuraj M

37099 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  showing error in importing files .what are the files require to import to run the code .i already installed pywin32
  
  – yaswanth
  Mar 26 at 10:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You have to pass absolute path to win32, when you open the excel file,Not relative path..
  
  – Suraj M
  Mar 26 at 10:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What error showing..?, did you close excel application at end xlwb.Save() and xlApp.Application.Quit()
  
  – Suraj M
  Mar 26 at 10:31
  
  

  
  
  
  

add a comment | 

0

Did you try:

Excel_wb = xlApp.Workbooks.Open(filename, False, True, None, password)

It worked for me.

If this doesn't work,
Check this link for more details about the Open() method

Open takes two types of password, namely:

Password: password required to open a protected workbook.
WriteResPassword : password required to write to a write-reserved workbook

So in your case , is it write protected or protection on open?

To open reserved excel file try:

app.Workbooks.Open("filename.xls", 2, True, None, None, "secret")

share|improve this answer

edited Mar 26 at 10:05

answered Mar 26 at 9:52

Suraj MSuraj M

37099 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  showing error in importing files .what are the files require to import to run the code .i already installed pywin32
  
  – yaswanth
  Mar 26 at 10:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You have to pass absolute path to win32, when you open the excel file,Not relative path..
  
  – Suraj M
  Mar 26 at 10:14
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What error showing..?, did you close excel application at end xlwb.Save() and xlApp.Application.Quit()
  
  – Suraj M
  Mar 26 at 10:31
  
  

  
  
  
  

add a comment | 

Did you try:

Excel_wb = xlApp.Workbooks.Open(filename, False, True, None, password)

It worked for me.

If this doesn't work,
Check this link for more details about the Open() method

Open takes two types of password, namely:

Password: password required to open a protected workbook.
WriteResPassword : password required to write to a write-reserved workbook

So in your case , is it write protected or protection on open?

To open reserved excel file try:

app.Workbooks.Open("filename.xls", 2, True, None, None, "secret")

share|improve this answer

edited Mar 26 at 10:05

answered Mar 26 at 9:52

Suraj MSuraj M

37099 bronze badges

Excel_wb = xlApp.Workbooks.Open(filename, False, True, None, password)

Password: password required to open a protected workbook.
WriteResPassword : password required to write to a write-reserved workbook

app.Workbooks.Open("filename.xls", 2, True, None, None, "secret")

share|improve this answer

edited Mar 26 at 10:05

answered Mar 26 at 9:52

Suraj MSuraj M

37099 bronze badges

answered Mar 26 at 9:52

Suraj MSuraj M

37099 bronze badges

answered Mar 26 at 9:52

Suraj MSuraj M

37099 bronze badges