xlswrite inserting characters to excel formula help

3 ビュー (過去 30 日間)
harrison cheng
harrison cheng 2022 年 1 月 16 日
コメント済み: harrison cheng 2022 年 1 月 16 日
I have a simple code
clear all; close all; clc;
input(1,1) = {'=QFS("DIS","net_income","TTM")'};
xlswrite('test.xls',input)
however, the output of the spreadsheet
is there reason why the xlswrite inserts an @ character to the output? is there a way to remove it during the write so I dont have to manually edit?
the QFS function is a custom installed excel function.

採用された回答

Cris LaPierre
Cris LaPierre 2022 年 1 月 16 日
I think the issue is that QFS is not a recognized Excel formula, so Excel is assuming you are using a named table reference (I think that's what it's called). The main point - if you replace QFS with the name of a recognized Excel formula, there is no '@'. If you use something that is not a formula or cell reference, the '@' is inserted before it.
  1 件のコメント
harrison cheng
harrison cheng 2022 年 1 月 16 日
ok thanks. Just wanted to see what the reason is and if there are parameters within xlswrite can prevent this from occurring

サインインしてコメントする。

その他の回答 (0 件)

Community Treasure Hunt

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

Start Hunting!

Translated by