Can lists be used with excel files?

[nitin2003]

Hi,

Can lists be used with the excel files? I tried to bind an excel file to lists but it seems it is not working.




If lists can't be used with excel files, can anyone please propose a solution to remove duplicates from an excel file?


Thanks,
Nitin

 

[rostonix]

You can Read as via File action, put data to variable, put this variable to temorary list, delete duplicates and save to wherever you want.
Just an idea.

 

[nitin2003]

You can Read as via File action, put data to variable, put this variable to temorary list, delete duplicates and save to wherever you want.
Just an idea.

Hmm.. Seems a lot of processing to perform a small task. Can we add this to the future enhancements where we can bind excel files to a list, if it's possible?



Edit - I tried it using Read via file action. it doesn't read the excel file properly. It shows junk characters.