Why do I get binary data warnings when using XLSREAD?

2009 12 3
1 个回答
回答已采纳
5 次查看（30 天）

0 个投票

I have a third party program that populates an Excel worksheet with data. An example of such a third-party software is FactSet, which is a financial datafeed tool. When I use XLSREAD, I get the following results:
>> [num txt] = xlread('tmp.xlsx')
num = []
txt = 1 x 2 cell
The error message in the second element of the "txt" variable is:
'This sheet contains Factset binary data for use with this workbook''s =FDS codes. Modifying the worksheet''s contents may damage the workbook''s =FDS functionality.'

请先登录，再回答此问题。

 采纳的回答

0 个投票

This issue is caused by the third party software that populates the Excel Sheet. The third party software places a new, invisible, worksheet before the visible worksheets. This new worksheet, named something like "__FDSCACHE__", contains binary codes that control the population of the visible worksheets.
You can see this worksheet when you open the Excel file in MATLAB's Import Wizard. You can workaround this issue by specifying the sheet you want to read, like:
[num txt] = xlread('tmp.xlsx','Sheet1');

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by