Need to read data table from .lin file

[shreyash_shirbhate]

Hi Guys,

I have the file with extension .lin and you can see the below data when I open it with excel.

I want the file data in data table format. But while reading this using Read Range it is giving me error as it needs .xlsx or xslm.

Anyone has done earlier this kind of stuff please suggest the approach.

Thanks in Advance.

[pravin_calvin (pravin kumar)]

Hi @

Can we rename the file extension and with xlsx or xlsm format and try using read range!

Change many file extension in one folder

Hi Delf, I am able to recreate scenario you have described, Actually this is failing as file name after rename is already exists. in order to resolve this issue there are two options Overwrite the file (just select overwrite property of move file activity Handle through try-catch or logically, there are multiple ways in this option like moving duplicate file to new location, renaming with different name etc. PFA revised workflow, Hope this works for you [Revised] [Capture]FileNameRe…

How to Change file format

Hi Guys, Now i am trying to change the file format name. If any file newly create or download to a particular folder in .html format RPA can convert the .html file to .xlsx file. Now i can monitor the folder but i can 't change the file format using RPA. I Try another method if the File download to the folder it automatically move to another folder with .xls format but unfortunately this is also not working… Thanks in advance

Regards

[supermanPunch (Arpan)]

Hi @shreyash_shirbhate ,

Have you tried using the Excel Activities?

Excel Application Scope and Read Range should be able to read the file since the file is also being able to be opened in Excel Application.

[shreyash_shirbhate]

Hey Arpan @supermanPunch

Nope it is not working.

[shreyash_shirbhate]

Hey @pravin_calvin,

I have renamed it but it is not working, it is saying the file is corrupted and it is not able to read.

[shreyash_shirbhate]

Hi @kirankumar.mahanthi1 @ppr @Palaniyappan @Gokul001 @Pablito

Can you guys take a look and help me on this?

[liu_shubin (Shubin)]

Can you check what is the real data file format for your .lin file? Is it text file? If so, you can use “Read CSV” activity to read data into datatable.

You can open .lin file using Notepad to check the file format.

[shreyash_shirbhate]

Hey @liu_shubin Thanks for quick revert.

It looks like below after opening with the notepad.

Can you please help.

Thanks in Advance.

[liu_shubin (Shubin)]

It is not text file.

In that case, you can read data to datatable by following the steps below.

1. Run Excel.exe
2. Open .lin file by Excel.exe (use UI activity to open the .lin file)
3. In Excel, use Save As to save it to normal Excel file with file extension .xlsx
4. Use Read Range to read .xlsx file to datatable.

[Shivaraju (UipathLearner)]

@shreyash_shirbhate , Can you try with ReadTextFile activity to read data from text file.

[shreyash_shirbhate]

I am able to read that file using Excel Application Scope. Somehow it was not working earlier because I was not giving the full path.

It worked after giving the full path.

Earlier I was giving below path, which was not working for me.

Thanks for your help guys!

[ppr (Peter Preuss)]

@shreyash_shirbhate

I am able to read that file using Excel Application Scope.

EAS is more tolerant on derivates (will correct e.g. metadata) instead of the WorkBook read range activity.

In case of you are handling an autocad LIN file the recommendation would be to handle it as text-filtered/CSV file