Regarding Read data back from Excel after updating excel from NAV through NAS

VSN
VSN Member Posts: 1
in NAV Three Tier
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.

Categories