Hi, I have created small APP to build configuration details based on few inputs which will provide two column of output in html. i would like this to have exported in excel file with some href icon or as a default option…
Need some advice over here please.
So first you want to decide where you want to create this file and then you can select an appropriate library to help you do it.
Thanks Ken for prompt support.
My requirement is to give output on excel so that end user can use it better. My current html output looks as follows. Kindly assist on suitable method.
Everything else follows from that.
The next step is to find a library that you’re comfortable with that will do what you want. There are a number of different libraries available to do this.
SheetJS is perhaps one of the better-known ones. There are others - some searching around will help you locate them.
I don’t have any specific recommendations - the only time I do any exporting of data to an xlsx file is from datatables, which has its own mechanism for handling that.
Maybe someone else with more direct knowledge will jump in here with other recommendations.
Actually i am not exporting the data from tables to excel; instead i have populated some output on html which is based on some value on existing table fields, and i need this data to be exported into excel.
Right. That’s where SheetJS can help you. (Or any of the other available alternatives.)