We have some custom requirement to export our data into excel with custom and conditional cell styling. We have explored two libraries (xlsxjs and syncfusion) and would like to know whether it is compatible with salesforce Lightning Web Components.
Please suggest if there is any other way to achieve the same without the mentioned libraries.
PFA sample of expected excel file on export.
Asked
Active
Viewed 539 times
0
anish samant
- 183
- 1
- 4
- 13
-
Yes it is possible to reference custom js in LWC. If you use LWC on-platform, your mileage may vary due to locker service. What have you tried? – zaitsman May 29 '20 at 05:15
1 Answers
-1
Greetings from Syncfusion.
It is possible to create Excel document using Syncfusion XlsIO similar to the shared screenshot.
But you have mentioned that you are exporting data to Excel, and we request you to share the below details.
- Platform you are using
- Control you are using to export data to Excel.
It would be helpful for us if you could share these details, so that we will check the compatibility from our side.
You can also mail the requested details to support@syncfusion.com
I work for Syncfusion.
Regards, Mohan.
Mohan Chandran
- 26
- 4
-
I have mentioned above the technology stack that we are using is **Salesforce's Lightning Web Components** (SAAS). We want a grid like structure with conditional formating/styling, cell merge and dynamic cell creation as per data. @Mohan Chandran – anish samant May 19 '20 at 04:18
-
We don't need to show the preview of export on the UI, but directly generate the output based on certain parameters and data available and export to excel on a button click. – anish samant May 19 '20 at 04:26