Excel

How to Convert SQL Database into Excel File (*.xlxs) in PHP

Submitted by Mr.Niemand03 on
In this tutorial, we will convert sql to excel using PHP. This code will read all data from an SQL table then add it into an excel file using a class called "xlsxwriter.class.php". You can download the class using this link from Github Things to do You have to download and install XAMPP or any local server that run PHP scripts. In my case I used XAMPP as my local server, here's the download link

Access RTGS, NEFT Bank forms, multiple company, Address Book

Submitted by Rajan on
Access application for RTGS, NEFT Bank forms for Fund transfer from multiple company and different Banks as many as you want... === NEW =========== A simple application for preparing the Bank forms to submit for RTGS / NEFT fund transfer. You will have a copy of the transactions with you, besides easy preparation for fund transfer application. New release, very useful for practically for Indian

Philippines Payroll Calculator

Submitted by nostradamus1566 on
PayCal.ocx is a simple payroll component. It is designed for the Philippines Payroll market. There is a simple Vb6 test project included to try out the component. There is also an Excel spreadsheet project to demonstrate it as well. If you examine the source code of the test project it will help you to use this component in your own project. Register the component on your computer and add it to

Easy Excel Bookkeeping

Submitted by nostradamus1566 on
Instant Excel bookkeeping without any macros or VBA code. For bookkeeping beginners There are two sheets in this workbook: Ledger and TrialBalance. The Ledger sheet is arranged in the traditional T format for double entry bookkeeping. The TrialBalance sheet calculates its results from the Ledger sheet. This excel workbook is just a teaching aid to help students understand how debits and credits

Calculate Your Weight on Other Planets using Excel

Submitted by nostradamus1566 on
Microsoft Excel spreadsheet with a user defined function in VBA to calculate you weight in kilograms, Lbs, and stone on the 8 planets MERCURY, VENUS, EARTH, MARS, JUPITER, SATURN, URANUS, NEPTUNE. This Microsoft Excel spreadsheet contains a new function called YourWeightOnPlanet(p, w). p = planet name as a string. w = your weight in Kilogrammes Use the function like this: =YourWeightOnPlanet(C9, G

Creating an Excel Application in C#

Submitted by donbermoy on
This is a tutorial wherein we will going to create a program that creates an excel application using C#. This tutorial uses Microsoft.Office.Interop.Excel in our Windows Form Application. 1. Let's start with creating a Windows Form Application in C# for this tutorial by following the following steps in Microsoft Visual Studio: Go to File, click New, and choose Windows Form Application. 2. Insert a Button control named Button1 in the form.

VB6 to Excel

Submitted by donbermoy on
In my previous tutorials, I had discussed about how to have an excel file using vb.net. And for now, we will create a program that can have an excel file from vb6. Now, let's start this tutorial! 1.Let's start this tutorial by following the following steps in Microsoft Visual Basic 6.0: Open Microsoft Visual Basic 6.0, click Choose Standard EXE, and click Open. 2. Next, add two TextBox named Text1 and Text2 for inputting and displaying it in excel.
Subscribe to Excel