How to create and save open office .calc file in .net

See more:

.NET3.5

.NET

MS-Excel

open-source

I want to create a new Open Office Excel (.calc) File and write my datagrid values to it.. How is it possible???

I have referred the below link and some other links as well and this works,
http://www.vbforums.com/showthread.php?578833-RESOLVED-Write-to-OpenOffice-Calc-Sheet[^]

But it just opens a new .calc File and write the data's to it but I cannot save the file to the desired location through coding...

Pls help..