Excel Automation

[Chandrasekharan P]

In my application i am creating an excel file through Excel Automation. Now i am writing some values in the excel and then i am using Save() and Close() functions. Now i want to open the same file and then write and append it. how can i do that? i have already written in the first 2 columns. Then i am closing it. Later i want to write into the third column by opening it. give me some leads.

[MsmVc]

try to find find number of rows in used.Then start write into file. It may be help you

long row;
VARIANT varc=pRange->GetValue();
if(varc.vt==VT_EMPTY)
{
}
else
{
COleSafeArray sarect(pRange->GetValue());
sarect.GetUBound(1,&row);
}

[David Crow]

Chandru080 wrote:

i have already written in the first 2 columns....Later i want to write into the third column...give me some leads.

How are you writing to the first 2 columns?

"One man's wage rise is another man's price increase." - Harold Wilson

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

"Man who follows car will be exhausted." - Confucius

[Chandrasekharan P]

I am using Excel Automation for that.. but i am trying to close the excel file and then open it again in a different function and then i am trying to append it again. that is not happening. I am using PutElement function to write the values into the excel file. but i am getting an exception there.