Sum of Diffrent Column in Excel from Lotus Script

HCL Domino Domino Forum
1

Hi to All

Any Body Know How i can generate the sum of column of excel sheet from Lotus Script Code…

i m using

xlsheet.cells(Rowno,2).Select:SUMSTRING=“Sum(B”& StartRow &“:B” & RowNo-1 & “)”

It wiil Give The sum Of B Column from StartRow to Rowno …

That Code is used in Visual Basic 6.0 But It Dont work Here…

Any Idea Regarding that Querry

Plz Advice…

2

Subject: Sum of Diffrent Column in Excel from Lotus Script

xlsheet.cells(Rowno, 2).formula=“=Sum…”

Look at the VBA help, not visual basic. Just record a macro in excel to do what you want and then check the code. Some alterations needed, but basically it’s the same

3

Subject: RE: Sum of Diffrent Column in Excel from Lotus Script

Thanks Sir It works .

Now i want to draw a graph on th ebasic of vaule comes from the view .

what are the possilbe way for that…

plz reply…