Try to search your question here, if you can't find : Ask Any Question Now ?

How to add title row and cell formatting when exporting data to excel using alasql in angular js application?

HomeCategory: stackoverflowHow to add title row and cell formatting when exporting data to excel using alasql in angular js application?
Avatarbhawya asked 4 months ago

In my angular application I want to export the data to an excel file, I have used alasql for the same.
How do I add the title which should be a row with cell merged and also show the filter parameters on which the data is generated in the excel sheet?

var mystyle = {
    headers: true,
    column: { style: { Font: { Bold: "1" } } },
};

let dataCopy = JSON.parse(JSON.stringify(dataFiltered));
alasql('SELECT * INTO XLSX("' + reportName + '",?) FROM ?', [mystyle, dataCopy]);

I have filterParams array which contains the filter parameters with value in the key value pair.

I want to generate the excel sheet with the title of the table in the first row below which the data should be generated.
After the title should come the parameters which are to be displayed.

1 Answers
Best Answer
AvatarFernando answered 4 months ago
Your Answer

17 + 2 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com