Export to an Existing Excel Sheet

sabzam
sabzam Member Posts: 1,149
edited 2010-08-19 in NAV/Navision Classic Client
Hi all,

Is there a way to export to excel and instead of creating new lines just overwrite existent rows?

Regards,

Comments

  • sabzam
    sabzam Member Posts: 1,149
    Hi All,

    Any news regarding this issue please?

    Regards
  • jannestig
    jannestig Member Posts: 1,000
    What is it you want to Replace ?

    Posted entries, Setup lines etc EG customers or just something like importing a journal?

    It is possible using the rim toolkit but its not designed for that purpose
  • FDickschat
    FDickschat Member Posts: 380
    You will need to create a new function in Table Excel Buffer. You can copy Create Sheet into UpdateSheet and make the necessary mods. It's in fact rather easy. Just look at the code and delete what you don't need.

    When writing into an Excel sheet:
    Fill the Excel Buffer with at least Row No., Column No. and CellValueAsText.
    Run OpenBook with the existing Filename, next UpdateSheet and GiveUserControl last
    Frank Dickschat
    FD Consulting
  • jannestig
    jannestig Member Posts: 1,000
    Actually isn't this already done for GL budgets export and import ?

Categories