If all else fails and your only task is to import data into a more readable format, maybe automating Excel / OpenOffice / LibreOffice is an approach.

See OpenOffice::UNO and/or Win32::OLE.

Maybe the OpenOffice macro recorder can help you get a close enough script to work with the unwieldly setup that the OpenOffice scripting approach needs.