search for: ascomarray

...-------- But I don't perfer this way writing calculated values like "c(1:4)" to the Excel Sheet and calling them via "SeriesCollection". I'm looking for direct adressing to "SeriesCollection". But codes like ac$SeriesCollection(1)[["XValues"]] <- asCOMArray(c(1:4)) ac$SeriesCollection(1)[["Values"]] <- asCOMArray(c(1:4)) were not successfull. E.g. the code above produces the error message "OLE error 0x800a01a8". Ok, I know that there are better ways to solve my problem by using the RExcel/statconn tools. Unfortunately the con...

Hallo all, I`ve read a lot of things in this forum about an Excel export via R. It is no problem to export my data frames via write.table or write.xls (xls or csv), but some things are not very convenient for me: I always have to adjust the column with to see all the numbers or the text and there is no frame between the cells. And I missing the possibility to make some headers bold or coloured.

Hi all, We currently faced a problem about how to pass a matrix with different types to a COM function call thru the RDCOMClient asCOMArray(). As we all know that matrix in R can't hold of elements with different types. So we managed to create a matrix of lists: rates <- matrix( list("1y","2y","3y","4y","5y","7y","10y"...