Smalltalk › Cincom › VisualWorks

[vwnc] Updating an existing Excel file

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

2 messages Options

Christophe Le Page

[vwnc] Updating an existing Excel file

Hello,

From my VW application, I would like to open an existing Excel file to overwrite the values of a few cells only (for which I already know column and line numbers).

I went through the COMConnectGuide and also looked at ExcelExampleFileImport from “COM- automation Examples” package, but I could not manage to do it…

Any clues would be very much appreciated!

Best regards,

Clp

------------------------------------------

Dr. Christophe Le Page

CIRAD, GREEN Research Unit

Department of Biology, Faculty of Science

Chulalongkorn University

Bangkok, Thailand

Tel/Fax: +66 22192057

Alternative email: [hidden email]

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

skrish

Re: [vwnc] Updating an existing Excel file

Probably a simple example should help..

Enclosed is a zip archive of Excel/ Word access through VW..

Let me know if this helps..

Simply load the ComTests.pcl and also the SUnit/RBSUnitExtensions

Choose the tests methods and execute from the debug/run button...

The access to cell and rows specific are through the macros you could pick from MS.

regards
skrish

On Mon, Sep 1, 2008 at 11:50 AM, Christophe Le Page <[hidden email]> wrote:

Hello,

From my VW application, I would like to open an existing Excel file to overwrite the values of a few cells only (for which I already know column and line numbers).

I went through the COMConnectGuide and also looked at ExcelExampleFileImport from "COM- automation Examples" package, but I could not manage to do it…

Any clues would be very much appreciated!

Best regards,

Clp

------------------------------------------

Dr. Christophe Le Page

CIRAD, GREEN Research Unit

Department of Biology, Faculty of Science

Chulalongkorn University

Bangkok, Thailand

Tel/Fax: +66 22192057

Alternative email: [hidden email]

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc

ComTests.zip (117K) Download Attachment