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
#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])
Reply


Messages In This Thread
RE: win32com Trying to open a xlmb file with macros - by snippsat - Jan-14-2019, 04:36 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,416 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