Taking an exisitng open office calc document and turning the contain into an array using c#

[EDN Admin]

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. <br/>
I dont 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? <br/>
<br/>
i know that i have to use the CLI references and the following namesspaces:<br/>
<br/>
using unoidl.com.sun.star.lang;<br/>
using unoidl.com.sun.star.uno;<br/>
using unoidl.com.sun.star.bridge;<br/>
using unoidl.com.sun.star.frame;<br/>
using unoidl.com.sun.star.text;<br/>
using unoidl.com.sun.star.beans;<br/>
using unoidl.com.sun.star.sheet;<br/>
using unoidl.com.sun.star.container;<br/>
using unoidl.com.sun.star.table;<br/>
<br/>
However I need help on how to receive the data from the file and put it into an array. <br/>
<br/>
Can anybody help?? <br/>
<br/>
Thanks in advanced<br/>
<br/>
Andy

View the full article