problems with xls file

Question

I'm uploading an xls file to the SDL (2017 suite) and i'm getting the first numbered raw as well as the headers which I don't need. I tried to setup in the file-options-bilingual excel-common and nothing works 
 I work with excel 2016 
 anyone? idea?

Jesús Prieto · Answer

Hi Efrat Gorohovski 
 You can hide columns/rows you don&rsquo;t want to translate in Excel. After translating the file in Studio, unhide them in Excel. Alternatively, if it&rsquo;s an XLSX file, you can apply a special colour to columns/rows/cells (let&rsquo;s say, red) and set that colour to be exluded from the extraction. You do it in Project settings > File settings > Microsoft Excel 2007-2016 > Exclusions > Skip cells formatted with the selectec color. After translating the file in Studio, reset the original colour in Excel.

Paul · Answer

Hi Efrat Gorohovski , 
 
I think a small sample file illustrating the problem would be helpful? So just create one in Excel, just a few lines after the header, and then explain what you want the final file to look like... so translation in another column or just overwrite the source?

Trados Studio > 1. Trados Studio

problems with xls file