Flexgrid import/export Excel/PDF

Flexgrid import/export Excel/PDF

Posted by: adriana on 14 September 2017, 11:12 am EST

• 

  adriana

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 September 2017, 11:12 am EST

  Hello,
  
  I would like to know about the possibility of import and export the Wijmo 5 Flexgrid to Excel and PDF.

  Regards,
  
  Adriana

• 

  bernardo

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:12 am EST

  Hi Adriana

  We will post a new sample tomorrow that shows how you can import/export to Excel. I really like this sample because it does everything client-side. This new sample is called ExcelImportExport.

  The sample does not do PDF, but that would be a logical next step. For now, you could export to XLSX and then use Excel to convert that into PDF.

• 

  adriana

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:12 am EST

  Thank you Bernardo.

  I have been studying the possibility of our company to use a Wijmo component for the grids of a LOB application.
  
  We are looking for features like sort, filter, pagination, import/export, row selection, column selection, dragging, row double click, etc.

  I have been working more with Wijmo 5 Flexgrid, as you can tell, but now I am evaluating the Flexgrid against the SpreadJS.
  
  I would like to know what component you advise and if both components will continue to “grow up” or if only one of both will stand out in the future.

  Regards,
  
  Adriana

• 

  bernardo

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:12 am EST

  That’s a great question.

  The FlexGrid and SpeadJS obviously have quite a few things in common. They are both capable, full-featured grids, and both are made by the same company, and both will continue to “grow up” and even to compete against each other.

  I am personally biased towards the FlexGrid, because that’s the product I helped design and implement. I love it because it is small, fast, and flexible. I also love the way you can style it with CSS, use cell templates, etc.

  But SpreadJS is a great product as well. Unlike the FlexGrid, SpreadJS is very Excel-oriented, in look and feel as well as features. It has built-in support for many things that you would have to implement yourself in the FlexGrid (like cell borders, sparklines, and a formula engine for example).

  So I guess my answer is you would do well with either product. If you need Excel-specific features like the ones I listed above, SpreadJS would probably make more sense. If you don’t need those, and prefer a much lighter control, the FlexGrid would be a better choice.

• 

  adriana

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:12 am EST

  Thank you for your advise Bernardo.

  I will continue to use the FlexGrid and I will be attentive to the import / export functionality.

  Regards,
  
  Adriana

• 

  bernardo

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:12 am EST

  Hello Adriana

  The ExcelImportExport sample has been published. You can see it in action here:

  http://demos.componentone.com/wijmo/5/Angular/ExcelImportExport/ExcelImportExport/

  And you can get the source by downloading the eval as usual.

  I really like this sample. It does rich Excel import/export all on the client. No round-trips needed, no server implementation needed. It supports hidden rows and columns, grouping, and subtotals.

• 

  adriana

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:12 am EST

  Hello Bernardo.
  
  Thank you for notifying me about the sample.

  Adriana

• 

  bernardo

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:12 am EST

  You’re very welcome Adriana.

  If you have any questions or suggestions about the sample please let me know.

• 

  gordondrewgnesys-co-uk

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:12 am EST

  Bernardo,

  Can you tell me if this export facility is available with the Wijmo 5 license or do you need Enterprise?

  Gord

• 

  bernardo

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 11:12 am EST

  Hi Gordon

  You can use this with a regular Wijmo 5 license.

  The import/export code is 100% javascript, 100% client side. There’s no round-trip to send/get data to/from the server, and nothing to run on the server at all.

  I really like this export mechanism.

• 

  vishalramdas.jagtap

  • Post Options:
  • Link
    Copy

  Posted 6 June 2018, 7:44 am EST

  Hi Bernardo,

  I am using wijmo 5 with Angularjs for one of our project.
  
  Where we have a requirement of showing huge data ( 2 lac + rows ) in flexgrid

  Two issues related to the same:

  1. Grid is responding slowly ( we have hierarchical data )
  2. When trying to export such huge data i get an Yellow banner saying-
     
     “A web page is slowing your browser. What would you like to do? Stop or Wait”

  I had used AsyncSave method of jszip.js

  Is there any efficient way of doing it on server side ?

  Thanks in advance,
  
  Vishal