Perform Styling in the excel download using javascript/jquery

Dinesh 1 Reputation point
2021-11-03T10:44:11.857+00:00

i am trying to export the selected records of a sharepoint List as an excel. First i place the selected record information in an html table and convert it as an excel using XLSX.utils.table_to_book. then i am downloading using XLSX.writeFile function. The downloaded excel has so many columns and data. So i would like to style it(like colured headings, width of the cell etc ). kindly suggest how to do it.

Microsoft 365 and Office | Development | Office JavaScript API
0 comments No comments
{count} votes

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.