Frequently Asked Questions

Yes, ExcelWriter is a pure .NET product.

There are four primary server requirements to run ExcelWriter on the server:

• Windows 2000, Windows XP, or Windows 2003 Server
• IIS 5 or higher
• Microsoft .NET Framework Redistributable
• J# Redistributable Package

ExcelWriter's ExcelTemplate can import database values to an Excel file from the following ADO.NET objects: DataSet, DataTable, SqlDataReader, OleDbDataReader and AdomdDataReader. The ExcelApplication object can import from from a DataView, DataTable, SqlDataReader, OleDbDataReader, and AdomdDataReader.

Yes. See Modifying an Existing Spreadsheet.

Yes. See How To Use Templates.

Note: An ExcelWriter template is a file created in Microsoft Excel that contains data markers and can be opened with ExcelTemplate. In the ExcelWriter documentation, the term "template" refers to an ExcelWriter template, not a Microsoft Excel template (.xlt). However, ExcelWriter can open and generate both .xls and .xlt files. Use an .xlt file the same way you would an .xls file.

Yes. With ExcelApplication, you can create a new chart or modify an existing chart. See Charts.

ExcelWriter supports Excel 97 and later versions. ExcelWriter generates BIFF8 format files. BIFF8 is the format of all Excel versions starting with Excel 97.