xlswrite inserting characters to excel formula help
3 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
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.
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!