Exporting format of a spreadsheet object

F

Facilnet

We have created a spreadsheet in an ASP with Office Web Components with
the intention of Importing it with ODBC.

The problem is that the Export method of OWC exports in an XML format
but the ODBC import expects the old Excel binary format.
Is there a way to Export directly to the old format or import an XML
format Spreadsheet file with ODBC or OLEDB in ASP?

Thank you
 
A

Alvin Bruney

One approach that may work well is to override the export function and roll
your own code. Make sure to cancel the export event so you don't have two
exports. For a review of OWC events, consult the help documentation.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
 
Top