excel


libxlsx Project

Hi all.

Does anyone know what happend to the libxlsx project?

Regards


The OpenXML Libraries Recent Updates

Just uploaded a new version of the OpenXML Libraries and tutorial.

Recent updates -

- Added support for resizable images.

- Added support for external, linked images.

- Added numeric and date internationalization features.

- Bug fixes and performance improvements.

You're invited to download the tools and try the samples or just look through the tutorial.

http://www.oehive.org/project/libooxml

If you have any questions please feel free to contact me.

Alon Blich
Email: alonblich@gmail.com
Phone: +972-54-2188086
Skype: alon.blich


Word and Excel Utilities V9 r-code

I've uploaded version 9 r-code for the Word and Excel utilities.

Like almost everything else we do the utilities are compatible with version 9 or better and work on UNIX/Linux and Windows.

Please download the utilities and try the samples.

http://www.oehive.org/project/libooxml

If you have any questions or requests please feel free to contact me.

Alon Blich
Email: alonblich@gmail.com
Phone: +972-54-2188086
Skype: alon.blich


More Excel and Word Utilities Updates

Just finished several big updates to the Word and Excel utilities.

Recent Word Updates -

- Added support for parts and sub parts using bookmarks (see the samples/src/word/sale_order.p sample).

- Added support for HTML and RTF values instead of plain text, numbers, dates etc. (see the samples/src/word/sale_order_html.p sample).

Recent Excel Updates -

- Added a meta table for setting field formats, styles, summaries etc. (see the samples/src/excel/create_template_ttmeta.p sample).

- with much improved calculated fields features.


Recent Excel and Word Utilities Updates and Future Plans

http://www.oehive.org/project/libooxml

Recent Excel util updates -

- Added a template generator procedure (samples: samples/src/excel/create_template.p and create_template_dataset.p).

- Added support for datasets.

- Added automatic field mapping, if the Excel defined name is the same as the buffer field.

- Added borders, colors, fonts, formatting, alignment etc. styles settings (samples: samples/src/excel/set_styles.p).

Recent Word util updates -

- Added support and samples for pictures in the Word util.

Planned updates for the Word util -


VBA for Excel and COM-handles

Hi,

I’m trying to launch a VBA for Excel from our Progress application, and I’m encountering a problem when I’m testing for access privileges. Essentially, I’m checking the read-only property for the workbook and alert the user if it’s true. Here’s a portion of the code:

DEF VAR chFileName AS CHAR INIT "N:\TestRegion2\testvba.xls" NO-UNDO.

DEF VAR chExcel AS com-handle no-undo.
DEF VAR chWorkbook AS com-handle no-undo.
DEF VAR chExcelApplication AS com-handle no-undo.
DEF VAR chWorksheet AS com-handle no-undo.


Sample Preview of program excecution.

Sample Preview of program excecution.

Add query for your program

Add query for your program

Selecting Fields for Excel

Selecting Fields for Excel

Tables from Database gathered

Tables from Database gathered
Syndicate content