Author Topic: Import xlsx  (Read 4960 times)

Prabhakar Thummala

  • Newbie
  • *
  • Posts: 7
    • View Profile
Import xlsx
« on: May 05, 2020, 08:52:48 pm »
Is there an example to import xlsx file (if possible with AngularJS)?

Thanks.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6122
    • View Profile
Re: Import xlsx
« Reply #1 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

Prabhakar Thummala

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Import xlsx
« Reply #2 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.

Prabhakar Thummala

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Import xlsx
« Reply #3 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.

Prabhakar Thummala

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Import xlsx
« Reply #4 on: May 07, 2020, 12:39:45 am »
Another question:
 
Is pqGrid 508 compliant?
(sorry about multiple questions in the same post).

-Prabhakar.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6122
    • View Profile
Re: Import xlsx
« Reply #5 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.

Prabhakar Thummala

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Import xlsx
« Reply #6 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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6122
    • View Profile
Re: Import xlsx
« Reply #7 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.

Prabhakar Thummala

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Import xlsx
« Reply #8 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

Prabhakar Thummala

  • Newbie
  • *
  • Posts: 7
    • View Profile
Re: Import xlsx
« Reply #9 on: May 14, 2020, 12:03:36 am »

Could you please reply to my question?

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

-Prabhakar.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6122
    • View Profile
Re: Import xlsx
« Reply #10 on: May 14, 2020, 09:18:45 am »
Only xlsx import / export is available.