I need some guidance on the use of Koolreport in working with an xls file. I need my user to be able to import data from an xls file. Their columns and my mysql required columns will not have the same names or order, so I will need to assign their columns to my columns.

What is the recommended way to do this? Are there any tools in KR's Excel package that can help me do this? If not, what do you recommend using?