Spider.Excel is a non-graphical Excel spreadsheet reporting component that enables either .NET applications to read and write Excel spreadsheets without utilizing Microsoft Excel.Spider.Excel is a very feature rich component that offers much more than just basic exporting of data. With Spider. Excel developers can export data, format spreadsheets in every detail and at every level, import images, import charts, create charts, stream Excel� data, save in various formats and much, much more.
No Microsoft Excel Automation
Spider.Excel is the most flexible component that allows developers to create and manage Excel Spreadsheets without requiring Microsoft Excel or Microsoft Office to be insalled on the system. In short, Spider.Excelis a better alternative to automation in terms of security, stability, scalibility/speed, price and features.
Advanced Features:
Unlike similar products from other vendors, Spider.Excel not only supports spreadsheet generation and other basic file formatting features, but also supports a number of advanced features. These advanced features make it much more convenient for the developers to manipulate spreadsheet contents, cells formatting and files protection.
Spider.Excel supports features such as:
- Saving and opening Excel files to and from streams
- Sending output to a client browser
- Importing and exporting data from a DataTable, DataView or Array
- Importing images and charts
- Creating images and charts through API
- Importing formulae from a designer spreadsheet
- Configuring page setup through API
Spider.Excel also supports Addins, VBA and macros. Moreover, there are also a number of unique features that developers can only find in Spider.Excel.Cells such as:
- The support of CSV format
- Adding the copy of an existing worksheet (with full contents, images and charts etc.) to a file
- Setting gradient background for charts through API
- Creating comments
- Auto-filters and page breaks through API
- Setting complex formulae
- Supporting conditional formatting
- Supporting protection options introduced in Microsoft Excel XP
- Manipulating named ranges
- Locating APIs
- Supporting custom chart API
- Formula calculation engine etc.
Platform Independence
Spider.Excel for .NET cover most of the popular development environments and deployment platforms. You can confidently use Spider.Excel for .NET to build any type of a 32-bit or 64-bit .NET application including ASP.NET, Web Services and WinForms. Spider.Excel for .NET is easy to deploy because it is just a class library without any dependencies (except on the .NET Framework itself). It is also possible to use Spider.Excel for .NET in pre- .NET technologies (like ASP) as a COM Wrapper.
Support for many Different File Formats
Using Spider.Excel, developers can easily open and save a multitude of file formats. These include Excel 97 / 2000 / XP / 2007 (XLSX), SpreadSheetML, Tab Delimited and CSV documents. Using Spider.Excel you can also open encrypted Excel files.
