This function translates an index to the Excel A1 notation that is used in xlswrite.
function a1String = idx2A1(idx)
alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
if idx < 27
a1String = alphabet(idx);
idx2 = rem(idx,26);
if idx2 == 0
a1String = [alphabet(floor(idx/26)-1),'Z'];
a1String = [alphabet(floor(idx/26)),alphabet(idx2)];
MySQL to TXT for Excel is a tool for database used for formatting the MySQL forms into Excel outputs. Supports only local file system. This script is comprised with error control features for directories, database selecting and selecting table.
TurboExcel converts Excel spreadsheets to C++ code. / This helps developers create perfect code instantly. Whenever you have to write a new function, prototype it in Excel first, getting the logic working before writing a single line of code....
this program consider to be data base of micro and mini uav's and allow to you to make matching between data and show the result in excel report
Write a matrix to active Excel-session. Input is filename, sheetname and range to write to in addition to the matrix that should be written to the Excel file.
Some simple checks are implemented.
Partly based on code from...
heck if a particular excel file is currently open, if it is then maximize it to notify the user. this simple function can be used inside a more complex function to check the excel workbooks that are currently running, if they are not do something...
Rather simple tool to read all data from all sheets in an excel file. Output is a structure with organization:
Data.Sheet_Name.num - The numerical value content
Data.Sheet_Name.txt - The text in the sheet
Data.Sheet_Name.cel - Raw...
PHP Dynamic Word/Excel Generator is an ultra easy-to-use php code for creating dynamic MS Word OR Excel files from a MySQL database query. Suitable for beginners to use.
ADODB SQL 2 Excel can be used to generate Excel files in the XLS format from database query results.
This is an altered version of of the SQL 2 Excel class that uses ADODB API instead of MySQL. It extends the GeraExcel class to generate...
Simple module that allows to export Views data to Excel (xls).
Uses php-excel class with UTF8 support.
If you will see message "The file you are...
This project allows PHP programmers to export data into Excel workbook. You can create multiple sheets, use fonts, colors and borders. Exported data is in XML format, recognized by Microsoft Office Excel
Java library that easily converts a Json array to Excel or CSV
This technical tip shows how an Excel XLS document can be converted to PDF file. Aspose.Cells component is designed to provide a fast and convenient way to convert any type of Excel spreadsheet into PDF format. The purpose of this article is to...
The DBF to XLS (Excel) program allows you to convert your dbf files to XLS (Microsoft Excel) format.
XLS is a wide-used format, many programs allow saving information in XLS format.
It is very convenient and Microsoft Excel provides...
A simple and easy to use script capable of converting a database table into an Excel spreadsheet.
This article discusses a solution to import MS Excel, MS Access, XML data to local or Remote MySQL databases by using a famous MySQL Admin Tool called Navicat.
Batch Replacer for MS Excel is an utility which helps to make a multi-replacement operations in MS Excel files with the help of the MS Excel list. It can really save a great deal of time: no need to open each file and make the replacement and then...
The Java Excel Connector product allows Java developers to read, create or modify Excel documents. The library handles Excel workbooks, worksheets, cells and charts.
Using automation the connector allows an easy Microsoft Excel...
Mail Report Excel .Net is an ASP Net component is clever at automatically send email HTML after conversion Excel Spreadsheet to HTML. It's very easy way just:
+ define the fields "from", "to", "object";
Aostsoft PDF to Office Document Converter is a competent and utility program specially used to batch convert PDF to Word(*.DOC,*.DOCX,*.DOCM),Excel(*.XLS,*.XLSX,*.XLSM),PowerPoint(*.PPT,*.PPTX*.PPTM,*.PPS,*.PPSX,*.PPSM), RTF, HTML,TXT. It is able...