excel


db2Excel

db2Excel

DB2Excel

Hi guys,
I tried to create a program that will generate code that will export table contents to excel
and wanted other people to test my project. (P.S. Please excuse my coding, I'm just a starter with progress :}).

This program is created using Openedge 10.1B and tested using Microsoft Excel 2007
DB2Excel is a program that automatically generates code for importing data to excel.

Step 1: db2Excel Collects tables from the database and makes them available for selection.
(if needed for schema preview, you can edit the source code to view system tables)


OpenOffice.org Calc Library

This is a collection of functions and procedures that provide an API to the OpenOffice.org Calc spreadsheet application. These were developed in Progress 9.1D using OpenOffice.org version 1.1.2 and have not yet been verified to work with version 2+.

This collection of functions and procedures will allow you to programmatically create Calc spreadsheets, add data, format columns, rows and cells and more!


Excel howto

Question

Tips and examples for communicating with MS-Excel.

Answer

by Jeff Pilant

Sites with information to write *.XLS directly:

http:sc.openoffice.org/excelfileformat.pdf

http:www.sector13.org/jason/xls/

http:www.wotsit.org/search.asp?s=CEL

http:chicago.sourceforge.net/xlhtml/

----

Some Excel tricks:

1) To speed up the excel generation, you can disable the screen updating with the following:

chExcelApplication:ScreenUpdating = False.

and restore it with

chExcelApplication:ScreenUpdating = True.


Syndicate content