stargeek
PHP news website logo.
home    PHP scripts    articles    seo tools    links    search    contact    shop    realtors


PHP Class 'SQL to Excel' released







PHP Class 'SQL to Excel' released

PHP Class 'SQL to Excel' released 04/27/2004 06:56 PM

This package is meant to export spreadsheet information in the Excel XLS format. It consists in a base class that is capable of generating the contents of an XLS file given the values of the spreadsheet cells. There is also a sub-class that can query a MySQL database and use the base class to generate the contents of XLS file with the information of the query result set. The class code and comments are in Portuguese.




This is a GrokNews Entry: (what is grok?)





Similar Items

PHP Class 'SQL to Excel' released

Grok Headline matches for PHP Class 'SQL to Excel' released

PHP Class 'SQL Highlighter' released


PHP Class 'SQL Highlighter' released 02/16/2004 07:54 PM
This class is meant to process a SQL statement text string and reformat it with HTML tags that can highlight different parts of the statement with different colors and styles. The syntax of SQL statements that are supported is defined in external files that can be changed to improve the types of SQL keywords that are recognized and highlighted.

PHP Class 'SQL wrapper' released


PHP Class 'SQL wrapper' released 03/06/2004 02:00 AM
This is a simple MySQL database access wrapper class. It provides functions to connect to a given MySQL database, execute a SQL query, retrieve the query result data and number of rows.

PHP Class 'SQL Query' released


PHP Class 'SQL Query' released 05/31/2004 06:41 PM
This class is meant to ease the generation of database queries by composing the SQL statements based on parameters passed dynamically to the class functions. The class can generate SELECT, INSERT, UPDATE and DELETE SQL statements. It has functions to specify the columns involved in the queries, the column values and the conditions that will determine which database table rows will be affected.

PHP Class 'SQL Data Browsing' released


PHP Class 'SQL Data Browsing' released 05/13/2004 06:25 PM
This package is meant to display MySQL query results in multiple HTML pages. It comes with a class for displaying query results in HTML tables and another class for displaying links to browse between all the query result pages.

PHP Class 'PHP or Java Class Code
Generator' released


PHP Class 'PHP or Java Class Code
Generator' released
03/06/2004 02:00 AM
This package is meant is automate the generation of classes to access databases in Java beans style. It uses the Fast Template engine to process template files that define the skeleton of functions and variables of classes that store and retrieve data object property values from a given database table, getter and setter functions to access those properties and a function to delete a data object row from the respective database table. The package comes with templates to generate classes either in PHP or Java. The PHP template defines code to access data objects in a MySQL database. The Java template defines code to access data objects in any database supported by JDBC.

PHP Class 'Convert Class To HTML Table'
released


PHP Class 'Convert Class To HTML Table'
released
02/10/2004 02:46 AM
This class is meant to display the structure of any class as an HTML table. The class being displayed can have variables that contain objects of other classes or arrays and treats those variables each accordingly.

PHP Class 'Bs_StopWatch.class.php'
released


PHP Class 'Bs_StopWatch.class.php'
released
11/07/2002 07:59 PM
You can take times during a code run and at the end get a time table as HTML or text table. The output will contain total and as delta between each take in microseconds. Free Code; This Class is part of the BlueShoes PHP Application Framework, see blueshoes.org.

PHP Class 'calend.class.php' released


PHP Class 'calend.class.php' released 01/03/2003 07:52 PM
This class generates HTML calendars in the portuguese language. In portuguese: Esta classe gera um calendário em português em HTML.

PHP Class 'Bs_CsvUtil.class.php'
released


PHP Class 'Bs_CsvUtil.class.php'
released
11/08/2002 08:17 PM
Features: supports any separator char sequence, default is semicolon ";". supports separator characters in the values. eg you use a ; as separator, your line may look like blah;hello world;"foo";"foo;bar";"this is a ""string""";got it?;foo as you can see, the values can be in "quotes". if your text uses quotes itself as in the "string" example, they are escaped in ms-style with 2 quotes. and by using quotes we can even have your separator inside the text (example "foo;bar"). line breaks. a csv line may spread over multiple lines using crlf in a field value. see the checkMultiline param and the _checkMultiline() method.

PHP Class 'My DB' released


PHP Class 'My DB' released 02/15/2004 07:40 PM
This class is a simple wrapper around MySQL database acess functions. It provides wrapper functions around most of the PHP MySQL extension function like database, connection, queries execution and result data access, error message retrieval, database creation and locking of tables.

PHP Class 'My Db' released


PHP Class 'My Db' released 06/09/2004 06:55 PM
This package is a SQL database wrapper supporting MySQL, Interbase and MS SQL server. It can establish database server connections, execute SQL queries, retrieve query results into arrays and display query results as HTML tables.

PHP Class 'htmldoc' released


PHP Class 'htmldoc' released 10/11/2002 07:54 AM
Object Library for Creation of PDF Documents out of HTML Pages by using htmldoc as conversion facility.

PHP Class 'BaseDB' released


PHP Class 'BaseDB' released 10/11/2002 07:54 AM
Excellent oo base class for mysql interaction. worth looking at. you must use this as a base class and extend your classes which map to a table name. your tables must have a 'id', 'created' and 'modified' field to work properly and the class takes care of the rest. check it out.

PHP Class 'Spreadsheet_WriteExcel'
released


PHP Class 'Spreadsheet_WriteExcel'
released
09/26/2002 07:29 PM
Class for generating Excel files, based on John McNamara's Spreadsheet::WriteExcel from CPAN. It supports all the basic values for cells. It doesn't support URLs, images (working on it) and charts. It has very basic support for formulas.

PHP Class 'WebWidgets' released


PHP Class 'WebWidgets' released 10/11/2002 07:54 PM
WebWidgets is a library of classes to produce any HTML(XML) documents, create, validate forms. It allow to create any "complicated" forms easy. Any tag is an object. Your can build tags tree by inserting one tag into another and get its content as HTML. Based upon "Composite" OOP patern. Library is very flexible, so your may derive your own classes. Documentation in html format can be downloaded from here: http://scancode.ru/dev/WebWidgets/webwidgets.08.doc.tar.gz (it is not fine:( )

PHP Class 'bstCountdown' released


PHP Class 'bstCountdown' released 10/15/2002 07:15 AM
Display a list of 'days until' a set of events, includes a simple example and a more complex one as child classes. Could easily be extended to multi-user and notifications via email by adding a user table and owner columns. Written to MySQL but db access is simple enough to adapt.

PHP Class 'rhc' released


PHP Class 'rhc' released 10/15/2002 07:15 AM
RHC is actually a few files which give the user the ability to do custom error handling, debugging, and handle database abstraction (currently only through Informix).

PHP Class 'URLHelper' released


PHP Class 'URLHelper' released 10/15/2002 07:15 AM
This class give you access to the http header information and provides some help for retrieving and parsing urls. FUNCTIONS: function isURLAvailable($url) function isValidURLFormat($url, $strict=false) function addHTTPtoURL($url) function getHTTPStatusCode($url) function getRealURL ($url, $simple = true, $method = "HEAD") function getHTTPHeader($url) function getMD5FromURL($url, $estFilesize=500000) function _openHTTPConnection($url, $method = "HEAD")

PHP Class 'color' released


PHP Class 'color' released 10/15/2002 07:15 AM
These class converts colortypes. It supports the following colors formats and types: - CMYK - RGB - Pantone - HEX Codes for HTML

PHP Class 'BarcodeI25' released


PHP Class 'BarcodeI25' released 10/15/2002 07:15 AM
HTML Barcode generator for Interleaved 2 of 5 Codes. Código de barras fator Intercalado 2 de 5, padrão FEBRABAN (BRASIL).

PHP Class 'DBgrid' released


PHP Class 'DBgrid' released 10/10/2002 09:55 AM
Show the result of a mysql query on HTML table. Easy to use. 1 line code. $grid = new DBgrid($result);

PHP Class 'CISVC' released


PHP Class 'CISVC' released 01/16/2004 11:05 AM
This class is meant to encapsulate the APIs around the COM object for Microsoft Indexing service (CISVC). The class can perform the search query, output the search results split in multiple pages and also a navigation let the user go back and forth between the presented search results pages.

PHP Class 'morse' released


PHP Class 'morse' released 09/28/2002 07:48 PM
Short class for encoding or decoding morse signs input: this is my 1st morse output: - .... .. ... .. ... -- -.-- .---- ... - -- --- .-. ... .

PHP Class 'burnauth' released


PHP Class 'burnauth' released 09/29/2002 08:10 PM
Burning Auth is a script to handle user authenticated access to php scripts. The goal is quite simple: protect from unauthorized access those pages who need to be kept under admin control, such as data/content administration and/or members only areas on a website. Security is achieved through a database authentication and mantained with a Session variable set to the authenticated user's name. Every page can be protected including the file 'shield.php'; at the beginning of it.

PHP Class 'mixer' released


PHP Class 'mixer' released 10/01/2002 09:17 AM
color mixer for vga (16 colors) - the class create a form for change backgroundcolor

PHP Class 'Pagination' released


PHP Class 'Pagination' released 01/10/2004 07:54 PM
This package is a set of classes is meant to generate navigation bars to display database query result sets split in multiple pages. The packake is based on the factory design pattern that is used to create objects of specific classes to provide the result set pagination support with different databases.

PHP Class 'numeroaletra' released


PHP Class 'numeroaletra' released 10/01/2002 10:18 AM
Extensión de la clase number2words de Bas Jobsen (bas@startpunt.cc) con la traducción de numeros a letras en español y de numeros a euros

PHP Class 'COutLook' released


PHP Class 'COutLook' released 10/01/2002 10:18 AM
This class reads messages from the Inbox and Oubox of an Outlook local profile through CDO (Colaboration Data Objects). The class only works under Windows.

PHP Class 'DCalendar' released


PHP Class 'DCalendar' released 10/08/2002 07:09 AM
Show a calendar with options view year, month and today link. Dynamic events with diferent color

PHP Class 'ms_dbx_reader' released


PHP Class 'ms_dbx_reader' released 10/01/2002 07:38 PM
Microsoft DBX file reader /such as Outlook Express Mailbox database files/ Author: Zeos

PHP Class 'db_view' released


PHP Class 'db_view' released 10/08/2002 07:08 AM
"db_view" provides: * An abstraction class and helpers for multi-tabled Mysql data. (init, select, select_row, count, insert, update, delete) * Atomic multi-table updates, inserts, deletes eg: update items, month set items.price=month.price where items.id=month.id; Also primitive non-atomic (=insecure) rollbacks. * Functions, Triggers and Defaults per action (select, update, insert, delete; before or after) * Rich logging and debugging facilities.

PHP Class 'MkDir' released


PHP Class 'MkDir' released 05/16/2004 07:21 PM
This is a simple class for creating directories in the local file system or in a remote server file system using a FTP connection.

PHP Class 'phplibTemplateExtention'
released


PHP Class 'phplibTemplateExtention'
released
10/08/2002 07:09 AM
phplib has template.inc - a template class for php to utilize templates. This is an extension to the class Template needing less code by: Automatic detection and declaration of blocks Automatic "blanking" of unused blocks Blocks automatically declaired in proper nested order. All calls to set up template/file/paths/names in the class call. - LGPL / GPL - phplibs license anyway - its their template class - I just extended it to make my life a little easier.

PHP Class 'cellroll_lib' released


PHP Class 'cellroll_lib' released 10/15/2002 08:29 PM
Very simple class for faster building of table-rollovers (changing bgcolor for rows or cells) js-scripts

PHP Class 'MyTemplate' released


PHP Class 'MyTemplate' released 10/15/2002 08:29 PM
MyTemplate is very powerful template engine. It allows including a nested template file directly into another template file and automaticaly parse it in any template in set. Working with dinamic blocks is so easy. Only assign block variables and get result. You do not need to parse each block 'manualy'. Automaticaly parses PHP constant and global variables into templates. Supports multiply template directories. You'll like it :) Your code will become shorter :)

PHP Class 'DcSessionManager ' released


PHP Class 'DcSessionManager ' released 05/14/2004 07:21 PM
This class is meant to manage sessions storing the information about their state in a MySQL database table. It generates an hash with 64 characters that is used to identify each session and may be passed between pages using cookies or request variables. This class has security in mind, providing means to prevents session hijack by using 2 hashes (double crypted) in only one "session". You can store more than 5kbytes of data in each session. The class provides other features, like: - Explicitly creating and destroing session - Register and deleting a session value - Check if a session key value is assigned

PHP Class 'page_handle' released


PHP Class 'page_handle' released 10/28/2002 08:29 PM
A template engine geared to be able to display data without much hassle in PHP code, just fetching of data and giving it to the template engine. Create HTML templates with the data's keywords

PHP Class 'mimetype' released


PHP Class 'mimetype' released 10/28/2002 08:29 PM
This class enables PHP scripts to determine the mime type of a file based on file extension, useful for PHP versions without access to other utilities that determine mime type. Built from the Apache mime type file.

PHP Class 'CSQLite' released


PHP Class 'CSQLite' released 05/14/2004 07:21 PM
This class is a wrapper to access SQLite file databases using SQLite extension for PHP 5. The functions are similar to those used to access MySQL databases: open, query, fetch_row and get_num_rows.
Grok Description matches for PHP Class 'SQL to Excel' released
GrokA matches for PHP Class 'SQL to Excel' released

Excel 2003 Sample: Create an Expense
Report Template


Excel 2003 Sample: Create an Expense
Report Template
04/28/2004 02:43 PM
This sample demonstrates how you can reuse legacy forms by converting them to XML data maps in Excel through the use of XML schemas.

Excel 2003 Sample: XML File


Excel 2003 Sample: XML File 12/12/2003 10:28 AM
This download contains the sample workbook that accompanies the Assistance Center on Office Online article How to use XML in Excel 2003. The workbook contains sample XML data that you can use to create a fictitious expense report.

Send Excel Documents via e-mail in
Pocket Excel


Send Excel Documents via e-mail in
Pocket Excel
04/06/2005 03:45 PM

Convert PDF Data to Excel Spreadsheets!


Convert PDF Data to Excel Spreadsheets! 04/27/2004 11:41 AM
Ad - http://www.investintech.com Apr 27 2004 4:41PM GMT

Excel 2002 Sample: Five Handy Charting
Tips


Excel 2002 Sample: Five Handy Charting
Tips
04/28/2004 02:43 PM
This download includes a collection of handy add-ins and techniques created by Excel MVP Tushar Mehta for use with Excel charts.

Create 'ledger paper' in Excel


Create 'ledger paper' in Excel 09/02/2004 10:30 AM
If you work in Excel, here's an easy way to create alternating colored and clear rows. With alternating patterns, wide reports are much easier to read, as your eye has a visible 'line' to follow across the page. Normally, you...

Exporting MySQL To Excel


Exporting MySQL To Excel 10/29/2003 12:11 AM
Teach yourself how to export MySQL tables to excel spreadsheets!

Cell names in Excel


Cell names in Excel 04/08/2005 02:44 PM
Can anyone tell me, what is the point of binding cell names in Excel to absolute cell references? (I know this is a bit ...

Using MySQL and PHP to Present Excel
Spreadsheets


Using MySQL and PHP to Present Excel
Spreadsheets
05/23/2002 10:39 PM

Excel-Template-Element-Cell-AutoSize-0.0
4


Excel-Template-Element-Cell-AutoSize-0.0
4
08/28/2004 12:50 AM

Excel ate my DNA


Excel ate my DNA 07/16/2004 08:41 AM
Autoformating black hole

MSXML and Excel XP


MSXML and Excel XP 10/28/2003 11:06 PM
I know people complain - even myself - about Microsoft. OSes plagued with security flaws; products with tons of bugs......

Excel Pile


Excel Pile 04/22/2004 06:39 PM
Most of the people I know are geeks, and some large number of geeks are obsessive to one degree or...

Excel-Template-0.03


Excel-Template-0.03 12/04/2003 12:11 AM

Synkronizer for Excel v8.0


Synkronizer for Excel v8.0 04/16/2004 06:22 PM
Synkronizer for Excel compares two Excel sheets. It gives a cell-by-cell summary of differences. [Shareware $79.00 30 Days 1.13 MB]

Excel Hacks


Excel Hacks 05/06/2004 06:58 PM
for all you dorks who were geeking out in the Excel Pile thread

New: Excel Hacks


New: Excel Hacks 04/09/2004 04:01 PM
O'Reilly's Excel Hacks offers 100 tips and techniques that include hacking pivot tables, designing charts beyond the basic types, specifying dynamic ranges, using XML, and more.

Excel ate my DNA | The Register


Excel ate my DNA | The Register 07/18/2004 12:19 PM
Excel is frickin' EVIL .. evil

theregister.co.uk/2004/07/16/excel_vanishing_dna
track this site | 3 links


Excel ate my DNA | The Register


Excel ate my DNA | The Register 07/18/2004 03:09 PM

Excel Web Queries


Excel Web Queries 08/27/2004 03:44 PM

Updating Excel From the Web: Really great article on Excel Web Queries. Users always want to get data in Excel for some reason. Web queries are a rock-simple way to let them do this.

Web queries essentially let Excel read data in from an HTML table. Excel can call a URL, parse the table that the URL produces, and load that as rows and columns. Additionally, you can get Excel to prompt the users for querystring parameters without doing any VBA, and using some extensions to HTML, you can format the data, add formulas, filter boxes, etc.

With Web queries, you can get a lot of client-side functionality for your Web app without doing a blessed thing, really. Microsoft really hit this one out of the park.

Click here to comment on this entry


Excel-Template-0.07


Excel-Template-0.07 01/23/2004 02:26 PM

Getting Data into MS Excel


Getting Data into MS Excel 09/02/2004 08:28 AM

Opening an Excel Spreadsheet


Opening an Excel Spreadsheet 07/26/2004 05:59 PM

Querylet-Output-Excel-OLE-0.12


Querylet-Output-Excel-OLE-0.12 09/23/2004 05:47 PM

Smart Excel Library


Smart Excel Library 04/27/2004 08:42 AM
Smart Excel Library beta 1

Make Charts in Excel


Make Charts in Excel 09/25/2004 04:08 AM
G4 Tech TV Sep 25 2004 8:16AM GMT

Advanced Excel Find v2.0


Advanced Excel Find v2.0 02/17/2004 10:29 AM
Advanced Excel Find lets you search through multiple worksheets and workbooks in Excel. It lets you simultaneously search in values, formulas, comments and more. [Shareware $30.00 30 Days 1.13 MB]

Excel JDBC Driver


Excel JDBC Driver 07/08/2004 09:03 AM
Y3 WARNING

Querylet-Output-Excel-OLE-0.10


Querylet-Output-Excel-OLE-0.10 09/21/2004 11:00 AM

Querylet-Output-Excel-XLS-0.10


Querylet-Output-Excel-XLS-0.10 09/21/2004 07:05 PM

PHP Class 'SQL to Excel' released

The following phrases have been identified by the grok system as matching this entry: how to convert xls to csv via perl sample to create excel poi package php mysql link excel results jedox pricing excel function pmt and sql "convert xls to csv" unix sydslnpvrate financial sample :xls php create excel file excel dropdown perl cell -cgi

















Also check out:


Grok

Ipod Porn on the
Rise

Brief Abstract of
Wikipedia's
Mesothelioma Cancer
page

Get first aid
instructions in your
cell phone

IE is crap
JSPWiki gains
podcasting support

Is It Time To Switch
to MySQL?

Ten years of mapping
Google Founder
Embarassed by Lack
of Gmail Safari
Browser Support

BluePhoneMenu 1.0
HUMAN KLEENEX
The Village Voice:
Nation: Mondo
Washington: John
Kerry Must Go by
James Ridgeway

Vice President of
Technology

U.S. Planes Hit
Falluja After Najaf
Clash Leaves Scores
Dead

In Falluja, Finding
a Place for the Dead

Sisters of Dead
Soldier Decide Not
to Return to Iraq

Online t-shirt
store: "we were
gagged by Google"

RSS Stock Ticker
Congressional Trip
to India Riles
Workers (AP)

Cost-Cutting Boosts
NAI's Earnings in Q1

Florida Town to
Automate Camera
Surveillance

Venture Capital
Investments
Stabilize

Channel woes persist
at Microsoft
Business Solutions

Citrix looks to make
access strategic

Ringing In The
Heroes

Intel's Dothan chip
expected May 10

PodWiki
Codea
NetWealth: Online
Money Game

Rumor Today: What's
In The Next iPod

Music Rivals Prepare
To Fight iTunes

Woman Claims Cops
Made Her Show Tattoo
(AP)

McDonald's Earnings
Increase 56 Percent
(AP)

Coal Miner's
Daughter

It's plucky!
Global Crossing's
shares plummet

Shell cuts 2,800
technology jobs

E-Gov Website Offers
Comparison Pricing
for Common
Medications

U.S. Forces Blast
Falluja Targets
After Deadline

Brahimi Says Iraq
Government Can Be
Set Up in May

Spy Agency Wants to
Raise Language
Skills

Nurse Testifies in
Kobe Bryant Rape
Case

Senate seeks
Internet tax
compromise

Writing strategy
guide for video and
computer games an
all-consuming task

IBM expands
midmarket push

Big Blue revs up
midmarket push

Avaya Swings to
Profit

RF Micro Devices In
Line on EPS, Beats
on Revenue

Top strategic
technologies for
2005

Bank security review
sparked after $100K
stolen in internet
scam

Acadia taps Dell for
massive notebook
refresh

PHP 5 Release
Candidate 2
Released!

iVCD 2 adds menus,
playlists to Video
CDs, more

Project Complete
Java Embedding
Plugin

wmosmon
what is grok?