ABL_xls.i

By Author: kgunderson
Library of procedures and functions that manage Microsoft Excel Spreadsheets.

Import Excel Spreadsheets (xls/xlsx) from Windows servers to ABL temp-tables via ActiveX.

Generate native Excel Spreadsheets (xls/xlsx) from Windows servers via ActiveX.

Generate native Excel XML Spreadsheet 2003 (xml) from Windows or Linux servers via native ABL.

----
There has been significant effort on my part to produce this code. It works and it works well. In return, I have two requests:

1. Please don't steal my work or remove the attribution. I wrote it and it's free for you to use in any project, commercial or otherwise. What harm is there in letting everyone know that I wrote it?
2. Please consider writing a review. A little feedback goes a long way.

Feature

  • Import Excel Spreadsheet to temp-table via ActiveX (xls/xlsx extension) from Windows
  • Create richly-formatted Excel Spreadsheets via ActiveX (xls/xlsx extension) from Windows
  • Create richly-formatted Excel XML Spreadsheet 2003 (xml extension) from Windows/Linux
  • OpenEdge 10.1C production tested
  • OpenEdge 10.2B production tested
  • OpenEdge 11.1 production tested
  • OpenEdge 11.2.1 production tested
  • OpenEdge 11.3.3 production tested
  • OpenEdge 11.6.1 production tested

Savvy Repair for Microsoft Office

DOCX, XLSX and PPTX files are collections of conventionally zipped mostly XML sub-files. This program first attempts repair any zip based corruption. From there it engages in four different algorithmic attempts at repair or recovery. With the first method using validation, the location of the first.........

Similar: 13%

Michel Max Spread - XLSX Loader/Creator

The Michel Max - MMSpread is an API to generate XLSX Spreadsheets without having the Microsoft Excel installed in the Machine. It allows you to Load XLSX files and edit them, or even create them from nothing, without having annoying alerts when it is open. It supports the following Microsoft Excel i.........

Similar: 12%

Volbx

Volbx is a graphical tool for data manipulation written in C++/QT. User can load data, filter, select, visualize, export and more using few clicks. Volbx reads, along with inner application format, xlsx and ods spreadsheet files. User can save output stream as csv or xlsx and plots as png files. Dyn.........

Similar: 11%

Windows 7 Quck Application Launcher

Turn your icon cluttered desktop into neat and tidy place. With Win7QL you can quickly create launchers to access easily your frequently used programs and documents. As project name suggests this program targets Windows 7 with its rather confusing Start Menu. Ideal for enterprise environment with .........

Similar: 10%

S2 Recovery Tools for Microsoft Excel

Microsoft recommends several methods for recovering Excel data from corrupt spreadsheets. S2 Recovery Tools for Microsoft Excel makes it easy to follow these recommended routines by just pressing buttons. The application also adds five methods of its own for recovery. Additionally it has its own na.........

Similar: 10%

Free VCF file to CSV converter

This is an Excel based VBA script used to import bulk .VCF files that contain more than 1 Vcard and then convert them to a comma separated .CSV file or Excel xls file that can then be imported into Outlook, Google, or any other application that supports import of contacts using CSV files. This has .........

Similar: 9%

Apache OpenOffice

Free alternative for Office productivity tools: Apache OpenOffice - formerly known as OpenOffice.org - is an open-source office productivity software suite containing word processor, spreadsheet, presentation, graphics, formula editor, and database management applications. OpenOffice is available in.........

Similar: 7%

XML Editor/Validator/Designer with CAMV

The CAM editor is the leading open source XML Editor/Validation/Schema toolset for rapidly building / deploying XML /JSON /Hibernate /SQL data /Forms applications. Visual WYSIWYG data design, rule entry wizards + drag & drop dictionary components. Will import, analyze / refactor from XML Schema / JS.........

Similar: 7%

Aspose for Spring.Java

Aspose for Spring.Java provides usage samples / sourcecodes for the demonstration of Aspose API for Java by extending famous Spring Java PetClinic Sample Web Application. This extension of "Spring Java PetClinic Sample Web Application" also shows the Integration of Aspose APIs with Spring MVC, JSP .........

Similar: 6%

OpenUnderwriter (Insurance Distribution)

OpenUnderwriter is an open source software house specialising in the development of IT solutions for the insurance market. Specialists in the areas of eBusiness and component based development, the team has developed technology for a number of major insurance companies. The OpenUnderwriter platfor.........

Similar: 6%