Write On EXCEL Page 2

Write On EXCEL Page 2

Postby acwoo1 » Wed Apr 25, 2018 12:20 pm

Hi

cName = "socie"
oExcel:Sheets( cName ):Select()
oSheet:Cells( 1, 1 ):Value="ABC"

cName = "socif"
oExcel:Sheets( cName ):Select()
oSheet:Cells( 1, 1 ):Value="BCD"

Only page 1 is updated.
Page 2 is not updated.
how to update two pages.

Thanks

ACWoo
Using FWH + bcc582
acwoo1
 
Posts: 173
Joined: Tue Nov 10, 2009 10:56 am

Re: Write On EXCEL Page 2

Postby Enrico Maria Giordano » Wed Apr 25, 2018 2:54 pm

It should work. Please show a little sample that can be compiled and run, with the Excel file included.

EMG
User avatar
Enrico Maria Giordano
 
Posts: 8713
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia

Re: Write On EXCEL Page 2

Postby hua » Wed Apr 25, 2018 3:00 pm

After you activate the other sheet did you reassign oSheet with the new active sheet?
FWH 11.08/FWH 19.12
BCC5.82/BCC7.3
xHarbour/Harbour
hua
 
Posts: 1072
Joined: Fri Oct 28, 2005 2:27 am

Re: Write On EXCEL Page 2

Postby Enrico Maria Giordano » Wed Apr 25, 2018 3:04 pm

Right, that could be the problem.

EMG
User avatar
Enrico Maria Giordano
 
Posts: 8713
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia

Re: Write On EXCEL Page 2

Postby acwoo1 » Thu Apr 26, 2018 5:02 am

Thanks

It works.

Regards

AC Woo
acwoo1
 
Posts: 173
Joined: Tue Nov 10, 2009 10:56 am


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 94 guests