Python Forum
win32com Trying to open a xlmb file with macros
Thread Rating:
  • 2 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
win32com Trying to open a xlmb file with macros
#4
Hi guys, I am now using the code below:
import xlrd
file_location='O:\xxx\xxxxxx\xxx.xlsm'
workbook = xlrd.open_workbook(file_location)
#sheet = workbook.sheet_by_index(2)
xl_sheet =workbook.sheet_by_name("B Data")

for rownum in range(xl_sheet.nrows):
print (xl_sheet.row_values(rownum))

It reads the data from an Excel file which uses a third part add in that update the data. The point is that I only see the original data but not the updated. Let's say that the Cell 1 Col A has 20 as value, this is what Python shows me. Now, if I see the file on the machine with the plug in installed the value is 22 but the code in Python still shows me 20. Any idea how can I set a process to see the data when it is changed and not only the original one?

Thanks
Reply


Messages In This Thread
RE: win32com Trying to open a xlmb file with macros - by diegoctn - Jan-16-2019, 11:26 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Open/save file on Android frohr 0 434 Jan-24-2024, 06:28 PM
Last Post: frohr
  file open "file not found error" shanoger 8 1,480 Dec-14-2023, 08:03 AM
Last Post: shanoger
  How can i combine these two functions so i only open the file once? cubangt 4 1,054 Aug-14-2023, 05:04 PM
Last Post: snippsat
  I cannot able open a file in python ? ted 5 3,936 Feb-11-2023, 02:38 AM
Last Post: ted
  testing an open file Skaperen 7 1,608 Dec-20-2022, 02:19 AM
Last Post: Skaperen
  I get an FileNotFouerror while try to open(file,"rt"). My goal is to replace str decoded 1 1,494 May-06-2022, 01:44 PM
Last Post: Larz60+
  Dynamic File Name to a shared folder with open command in python sjcsvatt 9 6,454 Jan-07-2022, 04:55 PM
Last Post: bowlofred
  win32com — How to resolve “AttributeError: xlUp” for Excel files? JaneTan 2 4,443 Aug-18-2021, 05:27 AM
Last Post: snippsat
Exclamation win32com: How to pass a reference object into a COM server class Alfalfa 3 5,081 Jul-26-2021, 06:25 PM
Last Post: Alfalfa
  Open an excel file Newbie1114 1 2,406 Jun-16-2021, 09:11 PM
Last Post: Gribouillis

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020