How do i read unsupported files rows and columns in Drop down box?

1 次查看（过去 30 天）

hussain 2013-12-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/110530-how-do-i-read-unsupported-files-rows-and-columns-in-drop-down-box

编辑： Walter Roberson 2016-10-29

Hi Team,

I have few set of unsupported files but can be readable/writable from excel ,

what command do i need to use for Reading these unsupported file's Columns/Rows and display its Headers in My GUI Drop-downs Box ???

25 个评论
显示 23更早的评论隐藏 23更早的评论

dpb 2013-12-28

编辑：dpb 2013-12-29

在 MATLAB Online 中打开

You've yet to show anything of any useful help to diagnose a problem...

a) XLSREAD expects an Excel .xls or other specific Excel file format. It won't care about an extension if it doesn't actually have one altho not having one will obviously break the link to the Windoes automagic file association.

b) Excel, otoh, will open a delimited text file and import it if it can transparently so it's not surprising the same file may be "readable" by Excel.

First use the alternate return from fopen on the file and report what the error message is if the return value fid is -1 --

[fid,msg]=fopen('whateverthefilenameyouthinkis')

That will identify if it's a naming issue or not in the path or the like as it will be a "Not found" type as opposed to anything related to the content.

Then, to check on the extension, use

d=dir('thefilename.*');
d(:).name

and see what is returned. NB: of course, that need the actual file name you think the file has in the above calls. The wild card in the dir argument will return any file of the base name rather than just those w/o an actual extension so you'll see whether there is something there as IA has hypothesized.

After all that, as have requested and at least one other poster asked, paste a few lines of the content of the file (using the {}Code formatter to make it look correct in the Preview window; otherwise the stupid Answers entry form will wordwrap it and it'll be gibberish as far as determining the actual record format.)