Consulting

Results 1 to 5 of 5

Thread: Pyhton Script Called by xlwings Addin

  1. #1
    VBAX Newbie
    Joined
    Oct 2017
    Posts
    1
    Location

    Pyhton Script Called by xlwings Addin

    I am attempting to use a basic example of xlwings. I have the following VBA script:


    Sub Test()
            RunPython ("import VBAtester; VBAtester.test()")
            MsgBox ("Script has run.")
        End Sub

    Which is in the same directory as the python script VBAtester.py:

    import xlwings as xw
    def test():
    wb = xw.Book.caller()
    wb.sheets[0].range('A1').value = 'TEST VALUE'


    The VBA script runs and outputs the message box; but *'TEST VALUE'* does not show in cell A1, or elsewhere. I know the python script is being called as if I purposefully put errors in my python script VBA will callback these errors when I run the VBA script that calls the python script.

    What is the error in my understanding or my approach?

    Moderator Edit: https://www.xlwings.org/
    Last edited by SamT; 10-29-2017 at 05:47 PM. Reason: Formatted Code

  2. #2

  3. #3
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,812
    Location
    VBA doesn't do scripts. VBA does source code. It compiles.
    vbs does scripts

    As far as your python script, I don't know if anybody here uses Python. Wait and see

    However
    wb.sheets[0].range('A1').value

    Might need to read
    wb.sheets[1].range('A1').value

    Even better would be to pass the Name of the Worksheet, the numerical index depends on it's tab position.

    Also, I am clueless if 'A1' will reach the Excel Workbook as "A1". The lack of capitalization of the Collections will probable by OK.



    What is the error in my understanding or my approach?
    Hard to say... You haven't given us your entire "approach."
    Last edited by SamT; 10-29-2017 at 05:39 PM.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  4. #4
    I am new to python, could someone help with the same example of xlwings?

  5. #5
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,812
    Location
    xlwings is a third party App for Python. See: https://www.xlwings.org
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •