xlswrite inserting characters to excel formula help

1 view (last 30 days)
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.

Accepted Answer

Cris LaPierre
Cris LaPierre on 16 Jan 2022
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 Comment
harrison cheng
harrison cheng on 16 Jan 2022
ok thanks. Just wanted to see what the reason is and if there are parameters within xlswrite can prevent this from occurring

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!