How to save spreadsheet to xlsx/pdf with java as webserver
Hello,
I have two questions.
The first one:
I want to export data to Excel and Pdf. I've read the below link and found it requires Server Configuration (
ASP.NET).
https://ej2.syncfusion.com/vue/documentation/spreadsheet/open-save/
Is there a way to save spreadsheet to xlsx/pdf with java as webserver?
The second one:
I found some sheets will change after importing. Please see the following screenshots：
Could you please help me to solve the problems? Thanks for your help.
Best Regards,
Dengpan
Hi Dengpan,
Query #1: JAVA library for open/save functionality
We have done the Open/ Save (server side) functionality in ASP.NET only. We don’t have open/save support for spreadsheet in JAVA (.jar formats). We are using the syncfusion XLSIO library for open/save action in spreadsheet. So, we suggest you to use the local ASP.NET web service for open/save action to achieve your requirement in your end.
And we have published our API services in the GitHub location, for more details please refer the below links.
Service sample Location: https://github.com/SyncfusionExamples/EJ2-Spreadsheet-WebServices/
https://ej2.syncfusion.com/vue/documentation/spreadsheet/open-save/
And we have already logged this as a feature from XLSIO team and it will be available in any of our upcoming releases. Please find the link below.
XLSIO Feedback: https://www.syncfusion.com/feedback/13225/xlsio-java-library
Query #2: Shape support in spreadsheet
Currently we don’t have shape (drawing, object) support in spreadsheet. However, we have already logged this feature request. You can track the status of this feature using below link from our feedback portal. We appreciate your patience until then.
Feedback Portal Link: https://www.syncfusion.com/feedback/29819/add-and-preserve-shapes-and-text-boxes-in-spreadsheet
Query #3: Text style is different before import
We have imported your provided excel file and the text style is imported properly in our end with our latest version. Please find the screenshot below in our demo site. So, please check this issue with our latest version(20.1.55) and get back to us with more details like spreadsheet customization codes. Based on that we will check and provide you a better solution quickly.
Could you please check the above details and get back to us, if you need any further assistance on this.
Regards,
Sangeetha M
Hi Sangeetha,
Thanks for your reply.
For Query #3, I tested again and found the brower zoom will influence the layout of spredsheet. When I set it as 100%, it shows like this:
When set it as other percentage, it will display correctly:
Best Regards,
Dengpan
