Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Can any one suggest me
ismailthesacrificer1@gmail.com
Member Posts: 76
I followed this process but unable to import the data in page.
Microsoft Dynamics NAV 2017
Microsoft Excel.
Steps:
1. Create a table with fields and populate it with data.
2. Create a excel file which you want to import.
3. A page is created with action button to Import data from excel.
4. A Report is created using Excel Buffer(table id 370) as a Data Item. The report property Processing Only is set to yes. Standard ‘ReadSheet’ function of the table Excel buffer is used to read the data from the Excel file.
5. A function is used to calculate the total number of rows and columns using Excel Buffer table.
6. On the PreReport function of the report we write the following code.
7. In the Insert Data function it initializes the table created in step 1, sets the range from the matching fields and if found it inserts values in the table.
8. To open the Excel file and selection of sheet we write a code in the Request Page in the Report. We use File Management codeunit to upload file.
9. Now run the page and click on the action Import then select the excel file.
Microsoft Dynamics NAV 2017
Microsoft Excel.
Steps:
1. Create a table with fields and populate it with data.
2. Create a excel file which you want to import.
3. A page is created with action button to Import data from excel.
4. A Report is created using Excel Buffer(table id 370) as a Data Item. The report property Processing Only is set to yes. Standard ‘ReadSheet’ function of the table Excel buffer is used to read the data from the Excel file.
5. A function is used to calculate the total number of rows and columns using Excel Buffer table.
6. On the PreReport function of the report we write the following code.
7. In the Insert Data function it initializes the table created in step 1, sets the range from the matching fields and if found it inserts values in the table.
8. To open the Excel file and selection of sheet we write a code in the Request Page in the Report. We use File Management codeunit to upload file.
9. Now run the page and click on the action Import then select the excel file.
0
Answers
Seems like you wanted to show us the screenshots but there are no any. Could you upload them correctly?
Thanks logger for responding...