taking an exisitng open office calc document and turning the

[andy_Rolo23]

I have looked through the internet and have struggled to find how to read in the contents of a OO calc file and turn it into a array.
I don't have excel on my machine and therefore im using open office. In c# I need to read in the file and store the information in an array. How is this possible when using open office?

i know that i have to use the CLI references and the following namesspaces:

using unoidl.com.sun.star.lang;
using unoidl.com.sun.star.uno;
using unoidl.com.sun.star.bridge;
using unoidl.com.sun.star.frame;
using unoidl.com.sun.star.text;
using unoidl.com.sun.star.beans;
using unoidl.com.sun.star.sheet;
using unoidl.com.sun.star.container;
using unoidl.com.sun.star.table;

However I need help on how to receive the data from the file and put it into an array.

Can anybody help??

Thanks in advanced

Andy