I have seen many posts and code on importing an excel spreadsheet, however not being a script guy myself, I would like an opinion on the best, simplest code to use. And in that opinion, show me where to put my column data which will be(DEPT,FP,S_A,IPL_CODE,BATCH,DESCRIPTOR,QTY,G,START_DATE,DUE_DATE,TYPE).
I want to use it in a button in a view or an agent, whatever would work best. I want it to overwrite everything in the view.
Also, when using these excel import scripts, do I have to make sure column widths are the same in the spreadsheet like when I am importing from a lotus spreadsheet?