List Info

Thread: Reg implementing SUBTOTAL formula in the excel
Reg implementing SUBTOTAL formula in the excel
user name
 2007-12-21 13:21:11 

  


  

    Hi John,
Sorry to ask same question again on the group.I have got 
Parse-RecDescent-1.94
http://search.cpan.org/~dconway/Parse-RecDescent-1.94/ 

module installed on our development server.I want to implement formule like =SUBTOTAL(109,G2:G31) in some of the columns in the excel.

Can you please let me know which example I should refer for this .There are many examples given in 
Parse-RecDescent-1.94 but,I don't know which one to refer.

You had earlier told me this info but,I'm not able to find your old mail.

Thanks in Advance,
Ajay


-- 



--~--~---------~--~----~------------~-------~--~----~

--
 
 You received this message because you are subscribed to the Spreadsheet::WriteExcel Google Group.
 
 
For posting and other options visit this group at:
 
 http://groups.google.com/group/spreadsheet-writeexcel?hl=en
 
 
You can also post by sending an email to:
 
 http://groups.google.com/group/spreadsheet-writeexcel?hl=en 
 
 
To unsubscribe send an email to spreadsheet-writeexcel-unsubscribegooglegroups.com 
 -~----------~----~----~----~------~----~------~--~---





  

  
  
   
     
    

  

     Re: Reg implementing SUBTOTAL formula
in the excel
  


  

     user name

     2007-12-21 15:30:47
  


  

    

  


  

    Hi John,

I find its outline.pl and I have successfully implemented the SUBTOTAL formula in the excel.The only problem is  when we put the formula like 

$worksheet->write('M36',  '=SUBTOTAL(109,M2:M35)');


can we take the column numbers are a perl variables ,as in my excel I don't know for which column I have to implement the SUBTOTAL formula.I have to dynamically decide it.

So it user selects the parameter which are going to fetch result data in 35 rows .I'll implement 


$worksheet->write('M36',  '=SUBTOTAL(109,M2:M35)');

But,When user is going to select the report which is going to fetch 100 rows data then,
I would like to implement 

$worksheet->write('M101', ; '=SUBTOTAL(109,M2:M100)');


So, can I write the formula in the excel like 

$no_rows_selected;
$no_rows_selected_one=$no_rows_selected +1;

$worksheet->write('M$no_rows_selected_one',  '=SUBTOTAL(109,M2:M$no_rows_selected)');


Is this syntactically correct ?

Thanks,
Ajay


On Dec 21, 2007 11:21 AM, AJAY PATIL < ajaypatil.cgmail.com">ajaypatil.cgmail.com> wrote:

Hi John,
Sorry to ask same question again on the group.I have got 
Parse-RecDescent-1.94
http://search.cpan.org/~dconway/Parse-RecDescent-1.94/
 

module installed on our development server.I want to implement formule like =SUBTOTAL(109,G2:G31) in some of the columns in the excel.

Can you please let me know which example I should refer for this .There are many examples given in 
Parse-RecDescent-1.94 but,I don't know which one to refer.

You had earlier told me this info but,I'm not able to find your old mail.

Thanks in Advance,
Ajay



-- 






-- 
"MBA from Top B-School in US --- at any cost"

--~--~---------~--~----~------------~-------~--~----~

--
 
 You received this message because you are subscribed to the Spreadsheet::WriteExcel Google Group.
 
 
For posting and other options visit this group at:
 
 http://groups.google.com/group/spreadsheet-writeexcel?hl=en
 
 
You can also post by sending an email to:
 
 http://groups.google.com/group/spreadsheet-writeexcel?hl=en 
 
 
To unsubscribe send an email to spreadsheet-writeexcel-unsubscribegooglegroups.com 
 -~----------~----~----~----~------~----~------~--~---





  

  
  
   
     
    

  

     Re: Reg implementing SUBTOTAL formula
in the excel
  


  

     user name

     2008-01-01 13:04:33
  


  

    

On Dec 21 2007, 9:30 pm, "AJAY PATIL"
<ajaypati...gmail.com> wrote:

> So, can I write the formula in the excel like
>
> $no_rows_selected;
> $no_rows_selected_one=$no_rows_selected +1;
>
> $worksheet->write('M$no_rows_selected_one',
> '=SUBTOTAL(109,M2:M$no_rows_selected)');
>
> Is this syntactically correct ?


Hi,

There are two things I would say about this.

The first is that is that the cell location would be better
specified
using Row-Column notation rather than "A1"
notation.

Instead of this:

    $worksheet->write("M$no_rows_selected_one",
...

Use this (coulumn M is equivalent to 12):

    $worksheet->write($no_rows_selected, 12, ...


See the section on "Cell Notation" in the docs:
http://searc
h.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet
/WriteExcel.pm#Cell_notation


The second is that the formula part is almost correct expect
that you
are using the wrong type of quotes:

    $worksheet->write($no_rows_selected, 12,
"=SUBTOTAL(109,M2:M
$no_rows_selected)");


Read up on quoting and "interpolation" in perl to
see why.

John.
--

--~--~---------~--~----~------------~-------~--~----~
--
You received this message because you are subscribed to the
Spreadsheet::WriteExcel Google Group.

For posting and other options visit this group at:
http://groups.google.com/group/spreadsheet-writeexcel
?hl=en

You can also post by sending an email to:
http://groups.google.com/group/spreadsheet-writeexcel
?hl=en 

To unsubscribe send an email to
spreadsheet-writeexcel-unsubscribegooglegroups.com
-~----------~----~----~----~------~----~------~--~---




  


  

    
  

  
  
   
     
    






 [1-3]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )