• I am afraid sheet name is a necessary. It is equivalent to table name.

    By default, Excel put Sheet 1, Sheet 2, ... as sheet name. In office 10, it does not allow blank sheet name. it accepts a SPACE as sheet name though.

    Can you ask the Excel creator to keep the sheet name?