J JK Sep 4, 2003 #1 How do I import and use the Excel Object Library in .NET? Specfically I want to use the formula in .NET.
How do I import and use the Excel Object Library in .NET? Specfically I want to use the formula in .NET.
D Dino Chiesa [MSFT] Sep 17, 2003 #2 you can do interop with Excel from .NET. check the examples that are shipped with the SDK. C:\netsdk\Samples\Technologies\Interop\Applications\Office\Excel If by "use the formula", you mean... you want to use Excel-like formulas in a .NET app, you can do this with interop, or, SQL Server Analysis Services includes this capability (useful for server-side apps). http://msdn.microsoft.com/library/en-us/olapdmad/agmdxnonosfunct_3bzn.asp Also, there may be third parties that provide such libraries. http://support.softartisans.com/ExcelWriter/doc/intro/whatisexcelwriter.asp http://www.simtel.net/product.php?url_fb_product_page=65928 -Dino
you can do interop with Excel from .NET. check the examples that are shipped with the SDK. C:\netsdk\Samples\Technologies\Interop\Applications\Office\Excel If by "use the formula", you mean... you want to use Excel-like formulas in a .NET app, you can do this with interop, or, SQL Server Analysis Services includes this capability (useful for server-side apps). http://msdn.microsoft.com/library/en-us/olapdmad/agmdxnonosfunct_3bzn.asp Also, there may be third parties that provide such libraries. http://support.softartisans.com/ExcelWriter/doc/intro/whatisexcelwriter.asp http://www.simtel.net/product.php?url_fb_product_page=65928 -Dino