xlswrite inserting characters to excel formula help
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
harrison cheng
le 16 Jan 2022
Commenté : harrison cheng
le 16 Jan 2022
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 commentaires
Réponse acceptée
Cris LaPierre
le 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.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!