Free multiple excel worksheets software for windows

A set of classes for the PHP programming language PHP Excel Project is intented to provid a set of classes for the PHP programming language, that will allow you to write to Excel 2007 files and read from Excel 2007 files.
Main features:
- Create an in-memory spreadsheet representation
- Set spreadsheet meta data (author, title, description, ...)
- Add worksheets to spreadsheet
- Add data and formulas to individual cells
- Merge cells
- Protect ranges of cells with a password
- Supports setting cell width and height
- Supports different fonts and font styles
- Supports formatting, styles, cell borders, fills, gradients, ...
- Supports different data types for individual cells
- Supports cell text wrapping
- Supports conditional formatting
- Supports column auto-sizing
- Supports rich-text strings
- Supports autofilter
- Supports "freezing" cell panes
- Supports workbook-level security
- Supports worksheet-level protection
- Cell data validation
- Insert/remove rows/columns
- Calculate formula values
- Add images to your spreadsheet
- Set image styles
- Positioning
- Rotation
- Shadow
- Set printing options
- Header
- Footer
- Page margins
- Paper size
- Orientation
- Row and column breaks
- Output your spreadsheet object to different file formats
- Excel 2007 (spreadsheetML)
- BIFF5 (Excel 97 and higher)
- PHPExcel Serialized Spreadsheet
- CSV (Comma Separated Values)
- HTML
- Read different file formats into your spreadsheet object
- Excel 2007 (spreadsheetML)
- PHPExcel Serialized Spreadsheet
- CSV (Comma Separated Values)
System requirements:
- PHP version 5.2
- PHP extension php_zip enabled

Export Dataset to Excel from ASP.NET demonstrates exporting a DataSet to Excel in ASP.NET, without using the Excel object model. We did not want to install Office on the server just to get the ability to create an Excel spreadsheet.
Whats so special about this? Well, of all of the online samples we could find, none of them had any way to create multiple Worksheet tabs within the spreadsheet without using the Excel object model. Trying to fit multiple tables in a single Worksheet causes several interesting and unnacceptable formatting problems, not to mention difficulties in finding precisely the data that was desired.
This is accomplished by building and returning an XML file which is created programmatically, in an Excel-readable format. Once this file is built, it is written directly to the Response stream, and the Response ContentType and appropriate HTTP headers are set to indicate that the pages output is an Excel spreadsheet.
The resulting spreadsheet will contain a seperate Worksheet for every table in the Dataset. The Worksheet will be named the same as the corresponding Table.
This demonstration project returns all of the data in all tables of the Northwind database on the local server.

Features:
- Full support for Visual Studio 2005 and .NET Framework 2.0
- Direct formula support in reading and writing
- Direct named ranges support in reading and writing
- Various cell data types (numbers, strings, dates, floating point etc.)
- International characters (Unicode support) and international date/time formats (custom number formatting)
- Cell styles (alignment, font properties, indentation, rotation, borders, shading, protection, text wrapping and shrinking, number formats etc)
- Font formatting (size, color, font type, italic and strikeout properties, different levels of boldness, underlining, subscript and superscript)
- Smart caching for cell styles and font properties removes duplicates in an efficient way so you dont have to worry about breaking the Excel cell style limit
- Multiple worksheets
- Row and column styles, row height and column width
- Row and column grouping and outlining
- Merged regions
- Worksheet and row copying, deletion and insertion
- Performance and feature samples (writing, reading, conversion and templates)
- XLS reading / writing - preserving images, summaries and similar excel objects not directly supported by ExcelLite API
- CSV reading / writing - support for comma, tab, semicolon or any other delimiter
- Horizontal and vertical page breaks, other print properties
- Worksheet Zoom, FirstVisibleRow, ShowGridLines, and other view properties
- Template support - create new workbooks using existing workbook as a template
Most common uses of ExcelLite:
- XLS files reading, writing or modification
- Filling of XLS forms
- CSV files reading or writing
- Conversion of CSV files to XLS files (and other way round)
- Splitting of XLS files into multiple files (and other way round)
You can equally use ExcelLite from your desktop or web applications. ExcelLite is very fast (about 260 times faster than Microsoft Excel object) and with the small memory footprint.