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.
Hi @
Can we rename the file extension and with xlsx or xlsm format and try using read range!
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…
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
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.
1 Like
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.
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.
1 Like
Hey @liu_shubin Thanks for quick revert.
It looks like below after opening with the notepad.
Can you please help.
Thanks in Advance.
It is not text file.
In that case, you can read data to datatable by following the steps below.
Run Excel.exe
Open .lin file by Excel.exe (use UI activity to open the .lin file)
In Excel, use Save As to save it to normal Excel file with file extension .xlsx
Use Read Range to read .xlsx file to datatable.
Shivaraju
(UipathLearner)
February 10, 2022, 10:00am
10
@shreyash_shirbhate , Can you try with ReadTextFile activity to read data from text file.
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)
February 10, 2022, 10:36am
12
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
system
(system)
Closed
February 13, 2022, 10:36am
13
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.