I have exported a excel file from a Finance software without formatting. Therefore I want to convert the excel file to text, and put it into a list and convert to data table. Is anyone know how to do it( like how to write the vb language)? or is there any better way to do it?
Thank you so much!