OfficeExporter – SQL or DataTable to xls and mdb – PHP Script Download

What’s OfficeExporter

OfficeExporter exports data from a SQL Server, ODBC Information Source or DataTable to either an Excel file or an Salvage admission to Database without the need of getting Feature of job do in.

Combine OfficeExporter to your venture

Gorgeous add the venture to your solution and begin the usage of the library savor in the examples. Construct a OfficeWriter object, construct a table and write your data to Excel or Salvage admission to.

What’s incorporated

• beefy provide code
• instance files
• instance venture
• heavy commented instance and library (public methods)

Requirements

I recommend to have the Microsoft Salvage admission to Database Engine do in, it’s far must write Excel and Salvage admission to files. Its incorporated in more contemporary versions of Microsoft Feature of job. There is not always any must have Feature of job do in though, ethical the Salvage admission to Database Engine.

Contact me

At the same time as you’ll need any questions or want serve, feel free to contact me.

Changelog

• 1.0 (2015-02-15)
• initial birth
• 1.1 (2015-05-19)
• added the functionality to export data from databases (Odbc data sources and Microsoft Sql Server) too
• code orderly up
• renamed venture to OfficeExport, didn’t savor the “Easy” phase anymore, it’s silent easy to use though :>
• all write capabilities now bewitch now the table name where the data desires to be imported in
• all data table and single row write capabilities now bewitch the columns as extra parameter to import the values properly
• added a “WriteSingleRow” skill to insert single rows correct into a Excel or Salvage admission to table