Plz plz plz <---- Help Me in this TDL ---->

Discussion in 'Tally Developer' started by SNB1726, Feb 2, 2013.

    
  1. SNB1726

    SNB1726 New Member


    [#Menu: Gateway of Tally]
    Add : Item : Export Ledgers to Excel : Call : Export Ledgers to Excel


    [Function: Export Ledgers to Excel]

    Variable : RowIndex : Number : 1
    Variable : ColIndex : Number : 1

    10 : OPEN FILE : "Exportxls.xls" : Excel : Write
    20 : ADD SHEET : "ATPL"
    30 : WALK COLLECTION : Ledger Coll
    70 : WRITE CELL : ##Rowindex : ##ColIndex : $name
    80 : INCREMENT : ColIndex
    90 : WRITE CELL : ##RowIndex : ##ColIndex : $ClosingBalance
    100 : INCREMENT : RowIndex
    101 : DECREMENT : ColIndex
    150 : END WALK
    160 : CLOSE TARGET FILE
    170 : EXEC COMMAND : Excel : "Exportxls.xls"

    [Collection: Ledger Coll]

    Type : Ledger
    Fetch : Name, ClosingBalance
     

    Attached Files:

    Amol Ashok Bhalgat likes this.


  2. admin

    admin Administrator Staff Member


    Please specify the problem...
     


  3. SNB1726

    SNB1726 New Member


    Error occured.. in this tdl code...
     


  4. SNB1726

    SNB1726 New Member


    Following Code not working.........
    Please Help me and modify this code pls..
    --------------------------------------------

    [#Menu: Gateway of Tally]
    Add : Item : Export Ledgers to Excel : Call : Export Ledgers to Excel


    [Function: Export Ledgers to Excel]

    Variable : RowIndex : Number : 1
    Variable : ColIndex : Number : 1

    10 : OPEN FILE : "Exportxls.xls" : Excel : Write
    20 : ADD SHEET : "ATPL"
    30 : WALK COLLECTION : Ledger Coll
    70 : WRITE CELL : ##Rowindex : ##ColIndex : $name
    80 : INCREMENT : ColIndex
    90 : WRITE CELL : ##RowIndex : ##ColIndex : $ClosingBalance
    100 : INCREMENT : RowIndex
    101 : DECREMENT : ColIndex
    150 : END WALK
    160 : CLOSE TARGET FILE
    170 : EXEC COMMAND : Excel : "Exportxls.xls"

    [Collection: Ledger Coll]

    Type : Ledger
    Fetch : Name, ClosingBalance
     


  5. nasir

    nasir Member


    kindly help how we can export files in PDf formate via TDl i am using version 9.1.1
    plzzzzz help thanks
     


Share This Page