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.

LearnerLearner Posts: 3Questions: 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!

Answers

  • colincolin Posts: 88Questions: 0Answers: 15

    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

  • LearnerLearner Posts: 3Questions: 2Answers: 0

    Thank you Colin. I'll try that and see how it works for me.

Sign In or Register to comment.