I need application stand alone to transform file CSV to Excel 97/2000 .xls
The CVS contain all customers information 37 colums I want in Excel just 12 principal colums + 1 more colum with code of product made by application stand alone taking code from 1 more CVS.
In Excel ordered A->Z the products, but Same name have to stay togheter and not follow ordered product, all Same name in yellow background, quantity more than 1 in red background white written, shipping metod different of priority red background white written.
I need Total of different names, total Euro amount, total of transactions.
In Excel page 2 creating 24 labels 70x37cm each page with address information for print.
Save 2 file xls:
1) File excel append containing all week
2) file excel insert for each day
Thanks