Hello all,
I want to convert excel file to Txt format with tab as delimiter. and i want the encoding to be utf 8.
I tried converting excel to csv, then csv to DT but i am getting error
How you do it manually? also what’s the error you are getting?
Hi @hansen_Lobo
Are you using “Read CSV” activity? What kind of issue are you having?
“Line 2 contains more values than header”
It means the input is not correctly formatted.
Try using Generate Data Table From Text activity. It will give you more options to build the data.
Okay will try.
Btw unable to find excel application scope activity.
This error means your CSV has more data in the rows than your header. Probably your conversion from xlsx to cvs is causing some error in the CSV.
You can check also if there is any empty column in the header of the original excel, then in the conversion it will cause some issues.
Your CSV will probably look like this:
Column1Title, Column2Title, Column3Title
abc1,abc2,abc3,abc4
in the example you have 3 columns in the header but 4 columns in the second line
Hey there, so i read the excel then used write csv to write in to csv file with tab delimiter,
What next? How do i convert to txt?
excel application scope is classic activity. You can use Excel Process Scope and Use Excel File activities
i dont have excel installed in the system nor i am allowed to install it. Will these activities work?
1 Like