Looking for some information on how to open an existing xlsx file which is on server-side.
Looking for some information on how to open an existing xlsx file which is on server-side.
Learner
Posts: 4Questions: 2Answers: 0
Hi all,
I have a xlsx file which is created and saved on server and has ~30K rows.
I want to open this xlsx from an html page that is created on same server.
Can someone please direct me to a demo/instructions on how to do this using DataTables?
This is first time I am using DataTables as it really seemed like a great way to customize the tables I am displaying in HTML.
I had to display tables with 30-50,000 rows.
So I created the table using json file that I created on server and using "fixedHeader": true to make the page load faster.
Now I have to export this table in excel so I have created xlsx file with same data in it on server side and just want to open that xlsx file from html page.
Thanks in advance!
This discussion has been closed.
Answers
Hi Learner,
Yep, you need a server side script that can pass that XLS file's contents back when DataTables on the client-side makes an Ajax request. Take a look at this page here, which talks about server-side processing, and here, for the Ajax customisation.
Cheers,
Colin
Thank you Colin. I'll try that and see how it works for me.