e.Workbooks.open(FILE_NAME);

Question

Dennis Bellamy 2017-11-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/370004-e-workbooks-open-file_name

回答： Greg 2017-12-1

every time I try the 'Open'

FILE_NAME = 'E:\Nov_2017\CP-140_NOV-17\1_FORCE_DATA.xls'
eWorkbook = e.Workbooks.open(FILE_NAME);

command, it comes back with: Error using open Too many input arguments.

any idea why?

6 个评论
显示 4更早的评论隐藏 4更早的评论

Dennis Bellamy 2017-11-30

编辑：Guillaume 2017-11-30

在 MATLAB Online 中打开

here is the output:

methods(e.Workbooks, '-full')
    Methods for class Interface.000208DB_0000_0000_C000_000000000046:
handle Add(handle, Variant(Optional))
bool CanCheckOut(handle, string)
CheckOut(handle, string)
Close(handle)
handle Item(handle, Variant)
handle Open(handle, string, Variant(Optional))
handle OpenDatabase(handle, string, Variant(Optional))
OpenText(handle, string, Variant(Optional))
handle OpenXML(handle, string, Variant(Optional))
addproperty(handle, string)
delete(handle, MATLAB array)
deleteproperty(handle, string)
MATLAB array events(handle, MATLAB array)
MATLAB array get(handle)
MATLAB array get(handle, MATLAB array, MATLAB array)
MATLAB array get(handle vector, MATLAB array, MATLAB array)
MATLAB array invoke(handle)
MATLAB array invoke(handle, string, MATLAB array)
MATLAB array loadobj(handle)
release(handle, MATLAB array)
MATLAB array saveobj(handle)
MATLAB array set(handle)
MATLAB array set(handle, MATLAB array, MATLAB array)
MATLAB array set(handle vector, MATLAB array, MATLAB array)

I have tried all manner of re-entering the name, it just keeps coming back with the same error...

thanks for your help... but still not working.

Walter Roberson 2017-11-30

Notice it has Open with a capital 'O'.

Dennis Bellamy 2017-12-1

In my defence, I am working on three blocks of code and LaTex trying to get this data filtered, saved, and charted....

Probably should have noticed that myself so THANK YOU for pointing it out....

next question, how do I get the merged cell to centre the data? and can I make charts in Excel directly from MATLAB? and finally, is there an index of commands that I can use with e.Workbooks so that I can find these answers on my own?

thanks again for your help.

请先登录，再进行评论。

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

Answer 1

Greg 2017-12-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/370004-e-workbooks-open-file_name#answer_294066

For simple stuff, use properties(e) and methods(e) as Guillaume has indicated, with the extra knowledge that Microsoft Office products are (almost?) always capitalized, and MATLAB often start lowercase.

For more involved stuff, open Excel (or Office application of your choice), and change your help to "Developer Reference" then click "Excel Object Model Reference." You can browse a VAST library of VBA/API information this way (and without an internet connection). See attached image.