Class to export Sqlite to Excel

We need a VB.net class to export any sqlite table in a database into an excel spreadsheet. Please see further descriptions later on. A BIG questions is can you do this with late binding. ie. can you connect to excel objects that would be installed with Office so that we dont need to attach any office DLL's to our project ???? The class should have the following properties: ------------------------------------ SqlLiteFileName - points to folder & file name of the sqlite database. ExcelFileName - points to the excel file to be saved. AutoFilter - a boolean that indicates if you must autofilter the spreadsheet. SelectStatement - The select statement to be used to read the table. StartAfterExport - A boolean and if yes, it must start excel with the new spreadsheet. The class should have the following public methods. ---------------------------------------- SendToExcel - This method should run the select statement and take all resulting fields and put them into an excel spreadsheet. If Autofilter is turned on then ensure all columns are auto filtered. (NB. We would prefer this to use latebinding so that we dont have send additional DLL's, but it must still be compatible with all versions of office)

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

VB .Net Windows

.NET Excel 微软Access 微软Exchange Odd Jobs Powerpoint Visual Basic Word

项目ID： #3280897

关于项目