[Collection : ExcelledgersCollection] ODBC : "Driver={Microsoft Excel Driver(*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=C:\Users\Accounts-2\Desktop\Ledgers.xlsx" SQL : "Select * From [Ledgers$]" [Function: ImportFromExcel] Variable : TotalEntries : Number Variable : Count : Number 00 : Set : TotalEntries : $$NumItems:ExcelledgersCollection 10 : Start Progress: ##TotalEntries : "Ledgers Creation" : "Importing Ledgers in" : ##SVCurrentCompany 20 : Walk Collection : ExcelledgersCollection 30 : New Object : Ledger 40 : Set Value : Name : $_1 50 : Set Value : Parent : $_2 60 : Set Value : Malling Name : $_1 70 : Set Value : State Name : $_6 80 : Set Value : Ledger Phone : $_7 90 : Set Value : Ledger Fax : $_8 100 : Set Value : Email : $_9 110 : Insert Collection Object : Address 120 : Set Value : Address : $_3 + ", " + $_4 130 : Set Target : .. 140 : Insert Collection Object : Address 150 : Set Value : Address : $_5 160 : Set Target : .. 170 : Create Target 180 : Show progress : ##Count 190 : Increment : Count 200 : End Walk 210 : End progress 220 : Msg Box : "Status": "Legders from Ereel Imported Successfully." [#Menu: Gateway of Tally] Add : Item : Before : @@locQuit : "Import From Excel" : Call : ImportFromExcel FUNCTION: 'ImportFromExcel' LABEL: 10 : Invalid number of steps FUNCTION: 'ImportFromExcel' LABEL: 10 : Action execution failed! Please Help Me
