Server side excel export

Question

What are the advantages / disadvantages of excel export on the server and client side?

I know it depends on the situation, but I want to know what are the exact risks using one?

I have a java / angularjs application (with soothing ws) that displays data on the client side. Excel export function required. As a rule, it is best to use the server side (for example, Apache POI). But I also come across js (angularjs) solutions. Before it was difficult to export excel from the client side (flash needed). And with the growing power of client-side encoding and html5, there are many plug-ins for client-side excel export.

And I just wonder if it takes time to use the client side, as well as reduce adventures such as styling and network traffic. Any suggestions?

Answer 1

Typically, client-side boot using a flash system is a security issue. In HTML5, you can use the property downloadfor <a>, but this is not compatible in all browsers. However, I believe that the best way (for a cross browser) is to load the server side.

Read more ... w3School