ParamQuery grid support forum

General Category => ParamQuery Pro Evaluation Support => Topic started by: Prabhakar Thummala on May 05, 2020, 08:52:48 pm

Title: Import xlsx
Post by: Prabhakar Thummala on May 05, 2020, 08:52:48 pm

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

Thanks.

Title: Re: Import xlsx
Post by: paramvir on May 06, 2020, 07:13:17 am

Hi Prabhakar

Following is the example for import of Excel xlsx file:

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

Title: Re: Import xlsx
Post by: Prabhakar Thummala on May 06, 2020, 10:19:33 pm

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.

Title: Re: Import xlsx
Post by: Prabhakar Thummala on May 06, 2020, 10:47:14 pm

JSzip error is gone after referring jszip ver 2.5.

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

Thanks
Prabhakar.

Title: Re: Import xlsx
Post by: Prabhakar Thummala on May 07, 2020, 12:39:45 am

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

-Prabhakar.

Title: Re: Import xlsx
Post by: paramvir on May 07, 2020, 06:50:25 am

Prabhakar

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

2. It's only partially 508 compliant.

Title: Re: Import xlsx
Post by: Prabhakar Thummala on May 08, 2020, 07:13:18 pm

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

Title: Re: Import xlsx
Post by: paramvir on May 11, 2020, 08:37:50 pm

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.

Title: Re: Import xlsx
Post by: Prabhakar Thummala on May 11, 2020, 10:53:54 pm

Thanks for the reply.

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

-Prabhakar

Title: Re: Import xlsx
Post by: Prabhakar Thummala on May 14, 2020, 12:03:36 am

Could you please reply to my question?

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

-Prabhakar.

Title: Re: Import xlsx
Post by: paramvir on May 14, 2020, 09:18:45 am

Only xlsx import / export is available.