Results 1 to 6 of 6

Thread: Calling VFP COM

  1. #1
    Senior Member
    Join Date
    Jan 2014
    Posts
    351

    Calling VFP COM

    Hi All

    I have a some 3rd party VFP classes that I dont have the source to convert.

    One such is VFPxWorkBookXLXS.VCX which I use to call to update XLSX workbook celle without MS Excel

    Was thinking to create a VFP COM to call the VFPxWorkBookXLXS.VCX

    Just to check if anyone can share your experience of calling VFP COM from Lianja server procedures.

    Your advice most appreciated

    Thanks & Best Regards

  2. #2
    Senior Member
    Join Date
    Apr 2012
    Location
    Dubai, United Arab Emirates
    Posts
    485
    Does vfpxWorkbookXLXS.VCX not have the source code, the copy on github seems to

  3. #3
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,769
    I would recommend you use python which is fully integrated for desktop and web apps.

    https://www.datacamp.com/community/tutorials/python-excel-tutorial
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  4. #4
    Lianja MVP
    Join Date
    Dec 2012
    Location
    Croatia, Zagreb
    Posts
    1,099
    Hi tekhong,

    I have just tried VFPxWorkBookXLXS.VCX and it works well as a COM in Lianja. It seems like a nice VFP class.

    But I would rather that you try it first with Python and then show us how to make it entirely in Lianja.
    This way we will all learn something new about using Lianja in full.
    COM need to be our last resort.

    If it takes too long for you to get the result using Python, I'll be glad to post VFP COM solution here, as a plan "B".

    Josip
    Last edited by josipradnik; 2020-02-17 at 13:32.

  5. #5
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,942
    TH,

    Here's the Github URL for the project: https://github.com/ggreen86/XLSX-Workbook-Class

    The code reads the XML but also uses the shell api. That in turn means that if you go down this path you will need to substitute for those calls. As for making it a COM object: if you haven't done a few of those I would not suggest it. You would be better off learning to use the Python library Barry pointed to.

    Hank

  6. #6
    Senior Member
    Join Date
    Jan 2014
    Posts
    351
    Hi All

    Thanks for your advice!! Will explore Python library for XLSX automation

    Best Regards

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us