Import xlsx

[Prabhakar Thummala]

Is there an example to import xlsx file (if possible with AngularJS)?

Thanks.

[paramvir]

Hi Prabhakar

Following is the example for import of Excel xlsx file:

https://paramquery.com/pro/demos/import-xlsx

[Prabhakar Thummala]

Thanks for the demo code.

Could you please reply to the below?
1. I get the error: "Uncaught TypeError: JSZip is not a constructor" when running the demo code on my local with the evaluation files. (Note: I am not using spectrum code).
2. Does the Import Excel support Drop down list in the Excel file?

Thanks
Prabhakar.

[Prabhakar Thummala]

JSzip error is gone after referring jszip ver 2.5.

Please reply if the grid supports excel file with drop down list.

Thanks
Prabhakar.

[Prabhakar Thummala]

Another question:
 
Is pqGrid 508 compliant?
(sorry about multiple questions in the same post).

-Prabhakar.

[paramvir]

Prabhakar

1. grid doesn't support import/export of dropdown list from Excel currently.

2. It's only partially 508 compliant.

[Prabhakar Thummala]

1. Are there any alternative solutions (achieve by add/change code) for import/export excel with drop down list? Do you have any plans to implement this soon?
2. Can I export pqgrid to PDF?

-Prabhakar

[paramvir]

Hi Prabhakar

1.Plan is to bring most of the features of the spreadsheet into ParamQuery eventually and dropdown import from Excel seems to be a cool feature, but can't promise how soon it would be implemented. Your request can be definitely added in the feature request and implemented according to the priority.

2. Export to PDF feature is not implemented due to lack of unicode support in most of the js PDF libraries. Easy and more practical way is to export the pqgrid to HTML table and use the inbuilt feature of modern browsers like Chrome to save HTML table as pdf. You may try this example https://paramquery.com/pro/demos/export_group_columns by exporting to HTML and then save as PDF in Chrome.

[Prabhakar Thummala]

Thanks for the reply.

I could not import an excel file with extension .xls  (not .xlsx) using pqgrid. Is there any example available?

-Prabhakar

[Prabhakar Thummala]

Could you please reply to my question?

Does pqgrid support importing .xls file (not .xlsx)?

-Prabhakar.

[paramvir]

Only xlsx import / export is available.