I'm receiving files output as .xls from I'm told Oracle. When I go to load them in Excel it warns me that they are possibly corrupt but will open them. The open file has formatted colours and once open has 1,048,576 rows. Someone else approached our inhouse Oracle admin and they were unable to help. There potentially are 100s of these to work with and consolidate so is there any way of telling what the file format genuinely is despite what the extension says?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
The file format and extension don't match - how do I figure out what the format is?
- Thread starter Bedlam
- Start date
I'm receiving files output as .xls from I'm told Oracle. When I go to load them in Excel it warns me that they are possibly corrupt but will open them. The open file has formatted colours and once open has 1,048,576 rows. Someone else approached our inhouse Oracle admin and they were unable to help. There potentially are 100s of these to work with and consolidate so is there any way of telling what the file format genuinely is despite what the extension says?
Excel Facts
Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
I tried saving it and it defaults to an MHT format it seems MHTML - Wikipedia
Upvote
0
Similar threads
- Question
- Question
