Bottom Page

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
You like this post
Quote
#2
Use code tag,i have added in your post.
win32com is now very little used for excel connection,now is XLSB a binary Microsoft Excel format.
There is a library for this pyxlsb that read XLSB.
Then can also read into pandas,for greater power if need edit.
Common Excel Tasks Demonstrated in Pandas
import pandas as pd
from pyxlsb import open_workbook as open_xlsb

df = []

with open_xlsb('some.xlsb') as wb:
    with wb.get_sheet(1) as sheet:
        for row in sheet.rows():
            df.append([item.v for item in row])

df = pd.DataFrame(df[1:], columns=df[0])
You like this post
Quote
#3
Thanks a lot snippsat,I am an absolute beginner, only working in Python in a week.
However, I changed the file to xlsm and now I am using xlrd

import xlrd
file_location='O:\xxx\xxxx\xxx Python.xlsm'
workbook = xlrd.open_workbook(file_location)
sheet = workbook.sheet_by_index(1)
sheet.cell_value(0,0)
sheet.nrows
sheet.ncols
for col in range(sheet.ncols):
print (sheet.cell_value(3, col))

It's reading the data without triggering the macro, but now I need to write the data to a csv file and struggling to understand how using the for. Is there a way to give a range to set a loop in print (sheet.cell_value(3, col)) and to use a variable instead of print?

Many Thanks
You like this post
Quote
#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
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  with os.open? Skaperen 3 362 May-30-2019, 07:33 AM
Last Post: heiner55
  open a file for noobs jhn 1 85 May-28-2019, 04:38 PM
Last Post: buran
  Run macros of excel sheet from python scripts shubhamjainj 3 382 May-01-2019, 08:40 AM
Last Post: buran
  ReShapping error while using open cv in python barry76 0 109 Apr-03-2019, 12:40 PM
Last Post: barry76
  How to open and interact with an app SheeppOSU 1 149 Feb-17-2019, 05:06 PM
Last Post: Larz60+
  testing if open to a terminal Skaperen 0 179 Feb-01-2019, 04:48 AM
Last Post: Skaperen
  replacing the open function Skaperen 2 227 Jan-27-2019, 02:45 AM
Last Post: Skaperen
  Help with try and open 6.txt file and print as perfect or not Pleiades 13 580 Jan-03-2019, 10:14 PM
Last Post: Pleiades
  Unable to open file ayaz786amd 7 541 Nov-21-2018, 05:31 AM
Last Post: ayaz786amd
  PyPDF2 Hanging When Trying to Open Corrupted PDF bmccollum 6 641 Nov-09-2018, 10:40 AM
Last Post: Larz60+

Forum Jump:


Users browsing this thread: 1 Guest(s)