Jump to content


Saurabh Goyal

Member Since 04 Sep 2002
Offline Last Active Jun 21 2011 11:57 PM
-----

Posts I've Made

In Topic: Question on DDE_EXECUTE

21 June 2011 - 11:56 PM

Hi All,

Just to let you know if you will upgrade to PROIV Version 6.2 and use SSO (Service Side Objects), PROIV has the Excel SSO Package (contact US Sales for pricing) which will allow you to build Excel files without calling DDE commands. Even you can email those Excel files directly from PROIV again using the power of Email SSO (Server Side Objects). We have serveral customer who in the past use the DDE command to built Excel and migrate to SSO. Here is the list of the features supported by SSO at this time:

* - Set Excel File Name
* - Set Excel Worksheet Name
* - Set Font Name (Tahoma, Arial, Times, Courier)
* - Set Font Size & Color (limited color options)
* - Set Font Style (Italic or Regular)
* - Set Font Weight (Bold or Normal)
* - Merge Multiple Excel Row & Cell
* - Set Cell Background Color (limited color options)
* - Set Cell Alignment (Left, Right, Fill, Center, General, Justify)
* - Set Cell Width
* - Write Excel Cell as General
* - Write Excel Cell as Number (With Or Without 2 Decimals)
* - Write Excel Cell As Currency (With $ Prefix and With 2 Decimals)
* - Write Excel Cell As Date (MM/DD/YYYY [US Format])
* - Write Excel Cell As Image (very limited, PNG image types only)
* - Write Excel Cell As Hyperlink
* - Add Box To Excel Cell
* - Vertical Align Excel Cell
* - Add Page Break at Specified Row
* - Write Excel Cell As Date (DD/MM/YYYY [UK Format])
* - Set Worksheet To Readonly with or without Password Protection
* - Write Excel Cell As Currency (With $ Prefix and Without 2 Decimals)
* - Write Excel Cell As Number (No Formatting, With Or Without 2 Decimals)
* - Add Multiple Worksheets To Single Spreadsheet
* - Excel Formula Support
* - Read Excel Cell Content
* - Write Excel Cell As Custom Number Format
* - Write Excel Cell As Custom Date Format
* - Set Worksheet Page Orientation - "P"ortrait (Default) or "L"andscape
* - Set Worksheet Horizontal Freeze
* - Set Worksheet Vertical Freeze
* - Set Worksheet Default Column Width
* - Set Worksheet Default Row Height
* - Set Worksheet Hidden in Excel File
* - Set Worksheet Vertically To Fit In Pages - (Print or Print Preview)
* - Set Worksheet Widthwise To Fit In Pages - (Print or Print Preview)
* - Set Worksheet Header - (Print or Print Preview)
* - Set Worksheet Footer - (Print or Print Preview)
* - Set Worksheet Top Margin - (Print or Print Preview)
* - Set Worksheet Bottom Margin - (Print or Print Preview)
* - Set Worksheet Left Margin - (Print or Print Preview)
* - Set Worksheet Right Margin - (Print or Print Preview)
* - Set Worksheet Vertical Center - (Print or Print Preview)
* - Set Worksheet Horizontal Center - (Print or Print Preview)
* - Set Worksheet To Scale - (Print or Print Preview)
* - Set Worksheet Default Number Of Copies - (Print Only)
* - Hide Worksheet Row or Column

For you reference here also attached the Simple Excel file generated from PROIV Version 6.2 using Excel SSO.
Attached File  EntertainmentCatalog.xls   20.5KB   108 downloads

If you have any question regarding the SSO or Version 6.2 upgrade, please contact PROIV US Sales Office.

Thanks,
Saurabh

In Topic: ProIV Programmer

17 May 2011 - 06:38 PM

Hi Senthil,

You can contact our Australia office for the above requirement as follows:

Mr. Gareth Talbot
Value Creation Manager
PROIV Technology
Level 5,
37 Pitt Street
Sydney
NSW 2000
AUSTRALIA
Direct: +61 (2) 9258 2050
Mobile +61 (0) 409 906445
Main : +61 (2) 9258 2000
Fax: +61 (2) 9258 2100
E-mail gareth.talbot@ngahr.com


If you need anything else or have question, let me know.

Thanks,
Saurabh Goyal
PROIV, USA
Phone: 949-748-7312
Email: saurabh.goyal@ngahr.com

In Topic: Finding PRO IV 7.0 distributor in Thailand

28 April 2011 - 10:00 PM

Hi Mr. Punyawee,

You can contact PROIV US office at the following or provide us with you contact information and someone from the sales team will contact you ASAP.

PROIV Technology LLC
Michelle Truran
+1 949-748-7306

Thanks,
SG