Getting numbers calculated using formulas using XLConnect

Question

I would like to read the numbers in an Excel spreadsheet using the XLConnect package. My impression is that he cannot read the numbers that are calculated inside Excel using the dollar sign formula. Is there a solution to this problem?

Answer 1

I ran into the same problem.

Have you looked at the 'useCachedValues' parameter for the readWorksheet function? Here is the help document for the parameter:

useCachedValues ​​is a logical indication of whether to read a cached formula from a workbook instead of re-evaluating it. This is especially useful when reading data received by Excel with features not supported in XLConnect, such as links to external tutorials. The default is FALSE, which means that the formulas will be evaluated by XLConnect.

I have specified useCachedValues ​​= TRUE. Although the formulas in my case did not include links to external links, this worked for me and I was able to read the values.