Export to an Existing Excel Sheet

sabzam

Hi all,

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

Regards,

sabzam

Hi All,

Any news regarding this issue please?

Regards

jannestig

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

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

jannestig

Actually isn't this already done for GL budgets export and import ?