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 450 Jan-24-2024, 06:28 PM
Last Post: frohr
  file open "file not found error" shanoger 8 1,569 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,092 Aug-14-2023, 05:04 PM
Last Post: snippsat
  I cannot able open a file in python ? ted 5 4,025 Feb-11-2023, 02:38 AM
Last Post: ted
  testing an open file Skaperen 7 1,639 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,507 May-06-2022, 01:44 PM
Last Post: Larz60+
  Dynamic File Name to a shared folder with open command in python sjcsvatt 9 6,520 Jan-07-2022, 04:55 PM
Last Post: bowlofred
  win32com — How to resolve “AttributeError: xlUp” for Excel files? JaneTan 2 4,494 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,131 Jul-26-2021, 06:25 PM
Last Post: Alfalfa
  Open an excel file Newbie1114 1 2,417 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