Page 1 of 1
Excel import/export
Posted: 01 Apr 2019
by keusch
Hello,
is there a possibility for the end user to export the entries in the edit form to excel and later on to import the data back from an excel file? e.g. with a button using javascript?
best regards
Christian
Re: Excel import/export
Posted: 02 Apr 2019
by Nikita Kurguzov
Dear Christian,
What's the point of exporting to Excel would be? I mean, you can export form to PDF, so the presentation is kept the same way, but form data is not normally exported to Excel. It's usually done for the List as a whole.
If you are using SharePoint Online, you can try Microsoft Flow.
Re: Excel import/export
Posted: 05 Apr 2019
by keusch
Nikita Kurguzov wrote: ↑02 Apr 2019
Dear Christian,
What's the point of exporting to Excel would be? I mean, you can export form to PDF, so the presentation is kept the same way, but form data is not normally exported to Excel. It's usually done for the List as a whole.
If you are using SharePoint Online, you can try Microsoft Flow.
Dear Nikita,
the idea was to allow an employee without access rights on the sharepoint list to adapt data entries and then the one with all rights could reimport the data. By using PDF the main workload remains at the employe with sharepoint access.
best regards
Christian