xlswrite inserting characters to excel formula help
1 回表示 (過去 30 日間)
古いコメントを表示
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.
0 件のコメント
採用された回答
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.
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!