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
#1
Hi guys, I am trying to read data from a xlsb file using the code below
import win32com.client
excel = win32com.client.Dispatch("Excel.Application")
excel.DisplayAlerts = False
excel.Visible=False
#doc1 = excel.Workbooks.Open.
doc = excel.Workbooks.Open("O:\xxx\xxx\xxx.xlsb")
doc.SaveAs(Filename="O:\\xxx\\xxx\\xxx.csv",FileFormat=6)
doc.Close()
excel.Quit()
The problem is that it does appear a mask with
Error:
RunTimeError '1004' Cannot Run the macro....
Is there any way just to read the data in Excel without the need to run any macro?

Thanks
Reply


Messages In This Thread
win32com Trying to open a xlmb file with macros - by diegoctn - Jan-14-2019, 03:23 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Open/save file on Android frohr 0 388 Jan-24-2024, 06:28 PM
Last Post: frohr
  file open "file not found error" shanoger 8 1,330 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 942 Aug-14-2023, 05:04 PM
Last Post: snippsat
  I cannot able open a file in python ? ted 5 3,653 Feb-11-2023, 02:38 AM
Last Post: ted
  testing an open file Skaperen 7 1,469 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,453 May-06-2022, 01:44 PM
Last Post: Larz60+
  Dynamic File Name to a shared folder with open command in python sjcsvatt 9 6,267 Jan-07-2022, 04:55 PM
Last Post: bowlofred
  win32com — How to resolve “AttributeError: xlUp” for Excel files? JaneTan 2 4,358 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,010 Jul-26-2021, 06:25 PM
Last Post: Alfalfa
  Open an excel file Newbie1114 1 2,375 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