Is the requirement to convert the spreadsheet into a native Confluence table? The reason why I ask is because you tried the excel macro. If a Confluence table is is not a requirement, you can always import the file into a file list and keep it a spreadsheet.