Read & Write to an Excel File Using OWC?

[Sathya]

I have an Excel Template, is it possible to write some data to the excel file
using OWC and latter read from the same excel file and dump into the database
using owc.

Thanks for the reply in advance

sathya

 

[Alvin Bruney [MVP]]

No, you'd have to use the Excel COM libraries for that. The OWC cannot read
excel files.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley

 

[stocki]

No, you'd have to use the Excel COM libraries for that. The OWC cannot read
excel files.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon andwww.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley

.... and in addition to that, it seems that
"axSpreadsheet1.Export(...)" works on some machines, on others it
creates rather "big" excel spreadsheets of 17MB or even more, where
only 40kB should be sufficient ... I am exporting the content of a
spreadsheet now "manually" by using Excel automation.

Regards

Stocki