Cleaning up Excel data before Import

[travelkind]

I have a nice little php script that uploads an excel file to my webhost but I need to clean up the file before it comes in.  Here is what I need to do:

 

1.  I need to delete the first column of the file which has a label of: "Bill To #".

2.  I need to delete (or ignore) the first (header) and last (footer) rows.  The number of rows that the file contains will vary from day to day but there will always be a header and footer that need to be deleted (or ignored).

3.  The file contains commas and dollar signs in three columns.  These create havoc on my import and need to be stripped out.

4.  The file contains "borders" (which are the grid boxes that are placed around each cell)so I am not sure if these will cause me problems?

I appreciate any help you can offer!!!!!!!