How to Import an Excel Sheet Using the Table Excel Buffer

prashanth.sanath
Member Posts: 2
I require a simple example which IMPORTS an Excell Sheet using the "Excel Buffer" (Table 370). I need an example with the DataItem as ITEM.
I have gone through the REPORT 81 - Import Budget from Excel; But i found it real complecated to understand that.I want a simple example which will allow me to understand the "EXCEL IMPORT" through an EXCEL BUFFER.I have written a function which allows me to select an Excel Sheet ,Reads that and Populates my Excel Buffer Table.I am not able to understand how to get the data out from the Excell Buffer table into my Table.PLEASE give me a simple example so that i will understand the Importing of an Excell using EXCELL BUFFER.[/b]
I have gone through the REPORT 81 - Import Budget from Excel; But i found it real complecated to understand that.I want a simple example which will allow me to understand the "EXCEL IMPORT" through an EXCEL BUFFER.I have written a function which allows me to select an Excel Sheet ,Reads that and Populates my Excel Buffer Table.I am not able to understand how to get the data out from the Excell Buffer table into my Table.PLEASE give me a simple example so that i will understand the Importing of an Excell using EXCELL BUFFER.[/b]
I work for the Blue Star nfotech Limited
0
Comments
-
What part is confusing? Here's a snipit
OnAfterGetRecord()
RecNo := RecNo + 1;
GLBudgetEntry.INIT;
GLBudgetEntry."Entry No." := EntryNo;
GLBudgetEntry."Budget Name" := ToGLBudgetName;
GLBudgetEntry."G/L Account No." := "G/L Account No.";
GLBudgetEntry.Date := Date;
GLBudgetEntry.Amount := Amount;
GLBudgetEntry.Description := Description;
GLBudgetEntry.INSERT;
EntryNo := EntryNo + 1;
You can also look at
http://www.mibuso.com/dlinfo.asp?FileID=8110 -
Hello,
Why don't use the Excel Mapping Tool in Nav Standard?
This is not "standard" function? :roll:0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions