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

[MohammedNawazuddin613134]

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?

[Michael Pirson]

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

[Pete Wirfs]

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.

[Tran-Hoang_Hau_348]

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 :)