Manipulate Excel Fields
Join the DZone community and get the full member experience.Join For Free
// This code makes it easy to take multiple Excel fields and make them however many fields you want. First save the Excel file as CSV.
import csv reader = csv.reader(open("absolute path to CSV file"), dialect='excel') for row in reader: firstname = row lastname = row ## Then you can take the fields and arrange them however you want. ## Copy and paste them however you'd like. print firstname, lastname