Database reporting has never been so simple - 20 lines of code are all you need to place a table or query in a spreadsheet. By changing the connection string and the SQL query you can reuse the included sample for any table or query. ExcelWriter also allows for formatting and the use of formulas that can make your reports look impressive. You can use many different types of data sources including databases, spreadsheets and comma separated text files. ExcelWriter can import into a parsed XML file into a spreadsheet as a data source. |