Automic Continuous Delivery Automation

Expand all | Collapse all

How to capture data from Excel(.xls),text(.txt) file into automic vara

Jump to Best Answer
  • 1.  How to capture data from Excel(.xls),text(.txt) file into automic vara

    Posted 04-09-2018 05:18 AM
    For accelerator  I need to develop a re-usable code such that data from Excel(.xls),text(.txt) file is captured in automic and it is stored in vara. What is the starting procedure to capture data from  Excel(.xls),text(.txt) file is captured in automic and then in vara.For capturing data from  Excel(.xls),text(.txt) file which object I need to use?


  • 2.  How to capture data from Excel(.xls),text(.txt) file into automic vara

    Posted 04-09-2018 12:54 PM
    I would look into this marketplace solution. I have not tested it but this would be a good starting point to see an example:

    https://marketplace.automic.com/details/vara2csv-csv2vara




  • 3.  How to capture data from Excel(.xls),text(.txt) file into automic vara
    Best Answer

    Posted 04-09-2018 01:55 PM
    Txt files can be easily read via the prep_process_file() script function.  Xls however is an MSOffice file format.  In my opinion, it would be better to translate the xls to a csv prior to importing into Automic.  Csv can also be easily read via the prep_process_file() script function.


  • 4.  How to capture data from Excel(.xls),text(.txt) file into automic vara

    Posted 04-09-2018 11:17 PM
    Hi Mohammed Nawazuddin 

    If you are using ARA, or AWA you can use the Excel Action pack

    https://marketplace.automic.com/details/microsoft-excel-action-pack

    I used to test this action :)