Re: Open xls file from AS400

Hi Colin

No - you can read/write a range of cells across a row directly from the Excel worksheet - no intermediary stuff - very clean, if I may say so.

The product gives you direct access to a large subset of Excel functionality - formatting, ranges, selections, fonts, colors - it's not done with SQL, and it does not use CSVs or anything in between.

If that is what you meant to ask!

Vern

Colin Williams wrote:

Not an option to generate the data to an extract file first?
Colin.W

http://www.as400blog.blogspot.com/

2009/4/30 Vern Hamberg <vhamberg@xxxxxxxxxxx>

I forgot to say what our product is - RPG2SQL Integrator - it's not just
SQL, also does XLS.

Vern

PEPITOVADECURT wrote:

Hi, I need open and update a Excel file from an CL or RPG program.
Actualy, I generate file from RPG and acces it from a xls file using
ODBC (iSeries ODBC driver) but have any manual steps.
Is posible do it automaticaly?
(RPG or CL program opens a xls file and update)

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.