|
+1We use this for several things - it takes a SELECT statement and dumps the results into a spreadsheet - you can have a sheet that has headings and all - the data starts at the first row without content. Several options for output, as I recall.
We also use another tool that Giuseppe put together - it's at http://www.mcpressonline.com/tips-techniques/microsoft/techtip-excel-flies-higher-with-jexcelapi.htmlThis one creates only XLS files, not the latest XLSX - in fact, I think both have that limitation. These utilities are open source, so one might be able to take the latest POI and get XLSX files out of it.
Vern On 5/8/2015 12:42 PM, rob@xxxxxxxxx wrote:
If all you want to do is create excel spreadsheets, which can then be emailed or something, then download a copy of SQL2XLS http://www.mcpressonline.com/tips-techniques/microsoft/techtip-excel-on-the-fly.html Better hurry, the link is working for now... Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
