Author Topic: Test using the demo program (import-xlsx)  (Read 674 times)

Richard

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 41
  • Richard
    • View Profile
Test using the demo program (import-xlsx)
« on: March 03, 2022, 06:26:16 am »
Hi.
I found that all the functions of the program I want to make are included in the demo program
(https://paramquery.com/pro/demos/import-xlsx),
and I processed it as follows to display it as same in the web browser on my PC.

1. I copied the demo program's source (HTML, Javascript, CSS) and made it into a single file (test.html) and saved it to my computer.

2. I added the link below to the source file (test.html).
<link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/themes/smoothness/jquery-ui.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/jquery-ui.min.js"></script>
<link rel="stylesheet" href="/paramquery-pro/pqgrid.min.css" />
<link rel="stylesheet" href="/paramquery-pro/pqgrid.ui.min.css" />
<link rel='stylesheet' href='/paramquery-pro/themes/bootstrap/pqgrid.css' />
<script src="/paramquery-pro/pqgrid.min.js"></script>
<script src="/paramquery-pro/localize/pq-localize-en.js"></script>
<script src="/paramquery-pro/pqTouch/pqtouch.min.js"></script>
<script src="/paramquery-pro/jsZip-2.5.0/jszip.min.js"></script>

3. I clicked the download button in the demo program to create a pqGrid.xlsx file and save it in the same folder.

4. I modified the part that reads the Excel file from the source file (test.html).
pq.excel.importXl( {url: 'pqGrid.xlsx'}, function( wb ){

After working as above, I started the web browser and opened the http://127.0.0.1/test.html file,
but it was not displayed the same as the demo program.

Please help me what the problem is.
I’m beginner to pqGrid that it is very difficult to start the test.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Test using the demo program (import-xlsx)
« Reply #1 on: March 03, 2022, 12:45:39 pm »
Can you share a screenshot of the output you are getting.

If you are loading xlsx file from localhost then you have to change the url accordingly.

or you can load the xlsx /csv from icon in the toolbar.

Complete example: https://stackblitz.com/edit/paramquery-demo-import-xlsx?file=index.js

Richard

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 41
  • Richard
    • View Profile
Re: Test using the demo program (import-xlsx)
« Reply #2 on: March 03, 2022, 01:44:47 pm »
I used the Complete example you gave me and it works fine.

Thank you.