Variable for range in xlswrite

1 次查看(过去 30 天)
I have define a variable which is beeing calculated automaticaly.
This variable has been define
a = [starcell ':', endcell]
and it give me e.g.
a = g12: h12
Now when i write
xlswrite('1.xls', Y, 3, a) it doesn't want to understand the range. The variable a is a character string . Does anybody have any idea?

采纳的回答

Sven
Sven 2011-11-18
Providing a variable as a string should be exactly the same as providing that string directly. Here are 3 possibilities that I can think of:
1. Did you intend to have the space " " character in the string "g12: h12". Try it without the space.
2. Make sure that the variable Y matches exactly the size you defined with g12:h12 (ie, it's 1-by-2)
3. Try uppercase 'G12:H12'
  1 个评论
Alexandros
Alexandros 2011-11-18
Yes I fixed it. It was the space between the g12: h12.
My function i made to find the cells i need to put them was automatically putting a space between them. I took it out and work fine

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Language Fundamentals 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by