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
Regarding Read data back from Excel after updating excel from NAV through NAS
VSN
Member Posts: 1
Hi Experts,
I need to read data back from excel after updating excel from NAV.
I have data in Excel with 3 sheets. First, I need to update Average Value in (Column:B,Row:7) Sheet1 from NAV.
Based on this value in Sheet3 (Using formulas) Values will be calcultaed. So I need to import the sheet3 data into NAV
through NAS.
This requirement could be reached using dotnet variables XlApp,XlWrkBk,XlWrkSht(Microsoft.Office.Interop).
But these dotnet variables are working on Clientside only, When I tried through NAS these are not working.
By using ExcelBuffer standard procrdures, I could update the data(in sheet1), But after updating It can't be imported(from Sheet3).
Here after updating excel need to save through coding (I coudn't find any save method in Excel Buffer standard procedures).
So Regarding this any one have solution please suggest me.
Thanks in Advance.
I need to read data back from excel after updating excel from NAV.
I have data in Excel with 3 sheets. First, I need to update Average Value in (Column:B,Row:7) Sheet1 from NAV.
Based on this value in Sheet3 (Using formulas) Values will be calcultaed. So I need to import the sheet3 data into NAV
through NAS.
This requirement could be reached using dotnet variables XlApp,XlWrkBk,XlWrkSht(Microsoft.Office.Interop).
But these dotnet variables are working on Clientside only, When I tried through NAS these are not working.
By using ExcelBuffer standard procrdures, I could update the data(in sheet1), But after updating It can't be imported(from Sheet3).
Here after updating excel need to save through coding (I coudn't find any save method in Excel Buffer standard procedures).
So Regarding this any one have solution please suggest me.
Thanks in Advance.
0