Regarding Excel Automation

[selva]

I have a program where it writes and read data from the specified excel
sheet.
However, i am looking for some way to check the spreadsheet so that i
know where to start writing. For example, if when i open the spread
sheet row A1 to A20 are already written to, then i
will know to start writing to A21.

Please help in this regard with approriate syntax in VC 6.0 using MFC.

Thank u
Selva

 

[Dave Hart]

I have a program where it writes and read data from the specified excel
sheet.
However, i am looking for some way to check the spreadsheet so that i
know where to start writing. For example, if when i open the spread
sheet row A1 to A20 are already written to, then i
will know to start writing to A21.

Please help in this regard with approriate syntax in VC 6.0 using MFC.

Thank u
Selva

Do a Google search for "Excel+last+cell" and you'll gets lots
of different ways of doing it.

Dave Hart

 

[selva]

Hi Dave,
Now somehow i manage to find out the last cell .
Next problem i have is,

I have to increment the address.
For ex. if the last cell is G22, i have to start writing data from
G24.
please tell me how can we do this again using VC++.

Thank u

Selva

 

[Dave Hart]

Selva

Take a look at some of these Microsoft Knowledge Base articles:
http://support.microsoft.com/kb/q196776/

http://support.microsoft.com/kb/q198112/

http://support.microsoft.com/kb/q216686/

http://support.microsoft.com/kb/q222101/

http://support.microsoft.com/kb/q238972/

http://support.microsoft.com/kb/q178749/

Dave Hart

 

[selva]

Hi Dave,

Thanks for u kind reply.
It provides me a lot of valuable information in automation of Excel.
However, still it couldnt satisfy my requirements.
I need to increment the cell address dynamically without giving it
explictly.
If the last cell address is H40, i may require to start writing the
data from the cell address J30.Could u please give me the appropriate
syntax for this in VC++ 6.0 using MFC.

Thanks in advance,

Selva