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 Matlab, sendt on mail from Antti LdoTAytynoja(Application Engineer in MatLab).
Errors on the otherside is the sole responsebility of the author of the code.
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...
Class for creating Excel spreadsheets - esp writing data and formatting them. NB OpenOffice Calc will be easily able to open the outputs too.
Often I get data to import in MS Excel files, and the column headers are not very useful for column names. They contain spaces, punctuation, and special characters that make a simple import difficult.
This script opens the file in...
Sometimes you get an Excel spreadsheet (say, from the marketing departement) and you want to read tabular data from it (i.e. a line with column headers and lines of data). There are many ways to do this (including ODBC + mxODBC), but the easiest...
This article discusses how to use jython to connect to an MS Excel file via ODBC using the JDBC-ODBC bridge.