Dw2xls
是一款PowerBuilder資料庫,用來設計Excel格式中匯出Datawindow & Datastore單元格式。
更新介紹
- Improved temporary file logic
- Alternative way to calculate autosize height (new parameter n_dwr_service_parm.ib_nonvisual_calc_height)
- Fixed problem with objects in foreground and background bands for Crosstab DWs
- Added workaround for dates before 1900-03-01 which are calculated in Excel in a different way in comparison to OpenOffice and LibreOffice (see new parameter n_dwr_service_parm.ib_fix_date_base)
- Allowed to switch ON/OFF dash borders for Grid DWs separately from document gridlines (see new parameter n_dwr_service_parm.ib_draw_dw_grid_lines)
- Supported pictures (for OOXML format only)
- Fixed problem with Footer band appeared before Summary band
- Fixed problem with DDDW when in some conditions Data Column was exported instead of Display Column
Features
- Support of Freeform, Grid, Tabular, N-UP, Group, Crosstab, Composite, TreeView and Nested DW styles
- Support of Text, Column, Expression types of DW objects
- Support of DropDownDW, DropDownListBox, Edit, Edit with Code Table and EditMask edit styles of fields
- Conversion of a set of Datawindows and Datastores to separate spreadsheets of Excel workbook
- Support of all data types
- Support of all kinds of text and data formatting
- OLE-components are not required
- Excel 97/2007/2010 (XLS/XLSX(OOXML)) format support
- Easy-to-use program interface
- Good technical support.
Restriction
- SlideLeft, SlideUp are not supported yet
- In some builds of PowerBuilder machine code (DLL) builds of DW2XLS fail with GPF during export.
- .Net WebForms deployments are not supported.
Update policy
- All minor updates (Versions .xx) are free-of-charge.
PB2XLS
PB2XLS is a powerful PowerBuilder library which allows to create manualy XLS file ftom scratch.
Features
- to create Excel files
- to write information into cells and worksheets
- formatting cells and worksheets.
PSR Viewer
PSR Viewer is a visual component, designed for reports management (.psr), stored in separated files. Component has own UI. Additionally, using our PSR Viewer component you can build your own psr viewer utility for distribute to your clients.
Features
- Mass viewing
- Mass converting into different formats (Excel 97/2003, Excel 2007, HTML, Text)
- Mass mailing through your mail client (by IMAP)
- Mass printing
- Easy-to-use user interface
- Building standalone utility
- All features of DW2XLS v4.x included.
- Good technical support.
PowerBatch (by Anatoly Moskovsky - our partner and friend)
PowerBatch is a command line PowerBuilder compiler.
Features
- command line compiling mode
- support of PowerBuilder 5 - 12 classic and PocketBuilder 1.5/2.0
- automatic detection of installed PowerBuilder/PocketBuilder version
- Conversion of a set of Datawindows and Datastores to separate spreadsheets of Excel workbook
- import existing PowerBuilder projects
- check for duplicate objects
PBInvoke (by Anatoly Moskovsky - our partner and friend)
PBInvoke is a PowerBuilder library for calling external DLL functions with arbitrary parameter and return types - structures, unions, pointers, etc. including function pointers to PowerBuilder methods callable from DLL code as callbacks.
PBInvoke goals
- Allow PowerBuilder developers to work in PowerScript with complex data structures without writing wrapper DLLs in other languages such as C/C++.
- Make declarations of external functions ANSI/Unicode-independent which avoids migration issues when using the same code across ANSI and Unicode versions of PowerBuilder.
- Support any C/C++ data type (except classes). This includes complex nested data types involving structs, unions, pointers, simple types and their combinations.
- Support not only STDCALL calling convention, but also CDECL which is default in C/C++ programs.
- Allow PB code to be called from external functions as callbacks with full access to passed parameters.
- Support wide range of PowerBuilder versions from PB 6 to PB 11.5 and any future version.
PbGuard (by Anatoly Moskovsky - our partner and friend)
PbGuard is a command line utility that implements encryption of PowerBuilder applications to protect them against decompilers or unauthorized modifications.
Features
- Support versions of PowerBuilder from v.5 to v.12 (classic)
- Support the p-code (PBD) and the machine code (DLL) targets
- The program source code is not changed to support protection. PbGuard protects compiled executables and libraries (the source code is not even needed).
- Each encryption uses a unique generated encryption key, so that no two protected programs would have the same key.
- Support reusing the key for applications sharing their libraries.
- Support adding encrypted PBDs to library list at runtime.
- Protected program does not require any additional external DLLs