Viewing Websheets that Contain the 0x1A Hexadecimal Character

IBM® Cognos® TM1® Web cannot open a Websheet that contains the 0x1A hexadecimal character. If you attempt to open a Websheet containing the 0x1A hexadecimal character, TM1 Web issues the following error:

Error occurred while converting the MS Excel workbook into XML format : '', hexadecimal value 0x1A, is an invalid character. Line 54, position 34.

If you remove the 0x1A hexadecimal character from the Websheet, the file will open in TM1 Web.

Note: The ASCIIOutput TurboIntegrator function places the 0x1A hexadecimal character at the end of all generated files. If you use ASCIIOutput to export TM1 data to an ASCII file and then attempt to open the file in the TM1 Websheet, you will encounter this error.