How to write Excel formula using actxserver with non-english regional settings

2 views (last 30 days)
I am working on a project where I should wirte formulae into excel from matlab for international use.
When using actxserver('excel.application') the contents of Range.FormulaR1C1 and Range.FormulaR1C1Local are the same with non-english Excel.
Meaning if I want to write either, the Excel expects me to use local formulae, and does not accept it in english.
If I would like to write simple formulae in R1C1 format, this could be worked around by reading the specific rows of the .International property of the Excel application, but is not usable for anything more complicated, like using an =IF() statement.
Could you give some suggestion how to write formulae into excel regardless the regional settings of the excel?
S replaces R(ow) and O replaces C(olumn) in this example:
CurrentRange.FormulaR1C1
ans =
'=SO[-6]+16'
>> CurrentRange.FormulaR1C1Local
ans =
'=SO[-6]+16'

Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!