3
 Followers
25
 Likes

[Service Studio] RecordListToExcel should able to export to several sheets

Backend
On our radar
Like we have the possibility to import from several sheets, it should be possible to export to several sheets of an excel file.

There are widgets in "Component Downloads" tab that do this, so it could be easy to reuse it and integrate with Service Studio.

Cheers,

Nelson Freitas
Created on 30 Nov 2011
Comments (7)
Merged this idea with 'Better column naming ability for list to excel conversion' (created on 2017-05-05 14:43:46 by Jason Herrington)

Especially in cases where a list has multiple tables in it, it would be very nice to be able to A) control the name shown on the column in the excel export and B) easier way to edit the order of these columns.  As it is now, you don't have much ability to edit the name of the column which can become very confusing to our users when they try to decipher the excel sheet.



Merged from 'Better column naming ability for list to excel conversion' (idea created on 2017-05-05 14:43:46 by Jason Herrington), on 2017-05-12 10:44:43 by André Vieira

This has been requested a number of times in other ideas. :(

J.Ja



Merged from 'Better column naming ability for list to excel conversion' (idea created on 2017-05-05 14:43:46 by Jason Herrington), on 2017-05-12 10:44:43 by André Vieira

Especially in cases where a list has multiple tables in it, it would be very nice to be able to A) control the name shown on the column in the excel export and B) easier way to edit the order of these columns.  As it is now, you don't have much ability to edit the name of the column which can become very confusing to our users when they try to decipher the excel sheet.



Merged from 'Better column naming ability for list to excel conversion' (idea created on 2017-05-05 14:43:46 by Jason Herrington), on 2017-05-12 10:44:43 by André Vieira

This has been requested a number of times in other ideas. :(

J.Ja



Merged from 'Better column naming ability for list to excel conversion' (idea created on 2017-05-05 14:43:46 by Jason Herrington), on 2017-05-12 10:44:43 by André Vieira
Merged this idea with 'Exporting Multiple Result Records In Different Sheets Withing Same Excel' (created on 18 Feb 2019 09:54:18 by Pranav Pandey)

Currently in the excel export function we can export one record list to excel based on the selected structure . The data is exported in the first excel sheet . Can we updated the excel export component to export multiple records sets in a similar way to different sheets within same excel file.

[There is already a component that we can use but that very lengthy process and prone to error, also its very hard to maintain and update the logic].



This comment was:
- originally posted on idea 'Exporting Multiple Result Records In Different Sheets Withing Same Excel' (created on 18 Feb 2019 by Pranav Pandey)
- merged to idea '[Service Studio] RecordListToExcel should able to export to several sheets' on 18 Mar 2019 10:08:37 by Vasco Pessanha

Hello Pranav, 

When you say "Can we updated the excel export component", are you talking about update a specific forge component?

Cheers,

Magda Pereira



This comment was:
- originally posted on idea 'Exporting Multiple Result Records In Different Sheets Withing Same Excel' (created on 18 Feb 2019 by Pranav Pandey)
- merged to idea '[Service Studio] RecordListToExcel should able to export to several sheets' on 18 Mar 2019 10:08:38 by Vasco Pessanha

Hi Magda Pereira,

Sorry for the misunderstanding  . I was talking about 'Record List To Excel ' component . 



This comment was:
- originally posted on idea 'Exporting Multiple Result Records In Different Sheets Withing Same Excel' (created on 18 Feb 2019 by Pranav Pandey)
- merged to idea '[Service Studio] RecordListToExcel should able to export to several sheets' on 18 Mar 2019 10:08:38 by Vasco Pessanha
views
475
Followers
3