When adding an Excel file .xlsx to a project in Studio 2021 SR2, the xliff is empty (0 words). When opening it I only see the path on my computer, but no file

In the column Words: 0, in Files Satus: Unspecified; size: 131KB; Usage: Translatable; File type identifier: SpreadsheetML v.1

I use Microsoft Office 2016, and the file type Microsoft Excel 2007-2019 is checked in the Project settings.

Thanks for your help!

emoji
Parents
  • Is this happening for a very simple XLSX as well  - a new Worksheet with 1 cell with a text ? Or is it for a specific XLSX you have.   To check if you have an actual XLSX format, open it in a text editor and check it starts with "PK". Anything else will not be a proper XLSX file format, even if MS Excel can open it. 

    Text editor displaying the start of an XLSX file with 'PK' followed by several characters and 'Content_Types.xml'.

    The best is to use Preview File feature.... via  File > Options > FileType > Microsoft Excel 2007 - 2019  ......    Load the XLSX file to a "Preview file" field and click Preview.   If even a simple XLSX doesn't show the content extracted, perhaps you may have some non-default options selected -  e.g. extract based on color or similar ... just click at "Reset to Defaults"  button  while having "Microsoft Excel 2007 - 2019" filetype highlighted and try to preview file again.

    Trados Studio options menu showing 'Microsoft Excel 2007 - 2019' file type selected with content processing options and 'Reset to Defaults' button highlighted.

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 6:59 AM (GMT 0) on 29 Feb 2024]
Reply
  • Is this happening for a very simple XLSX as well  - a new Worksheet with 1 cell with a text ? Or is it for a specific XLSX you have.   To check if you have an actual XLSX format, open it in a text editor and check it starts with "PK". Anything else will not be a proper XLSX file format, even if MS Excel can open it. 

    Text editor displaying the start of an XLSX file with 'PK' followed by several characters and 'Content_Types.xml'.

    The best is to use Preview File feature.... via  File > Options > FileType > Microsoft Excel 2007 - 2019  ......    Load the XLSX file to a "Preview file" field and click Preview.   If even a simple XLSX doesn't show the content extracted, perhaps you may have some non-default options selected -  e.g. extract based on color or similar ... just click at "Reset to Defaults"  button  while having "Microsoft Excel 2007 - 2019" filetype highlighted and try to preview file again.

    Trados Studio options menu showing 'Microsoft Excel 2007 - 2019' file type selected with content processing options and 'Reset to Defaults' button highlighted.

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 6:59 AM (GMT 0) on 29 Feb 2024]
Children
No Data