How to give Autofitwidth to xlsx file using alasql

danilo_fme wrote:

Hi @sandeepreddy124, in your Workspace did you use the transformer JavaScriptCaller?

Thanks,

Danilo

Hi Danilo,

 

 

No, I did not use transformer JavaScriptCaller. Instead I have used alasql.min.js

 

Thanks,

 

Sandeep

 

danilo_fme wrote:

Hi @sandeepreddy124, in your Workspace did you use the transformer JavaScriptCaller?

Thanks,

Danilo

Hi Danilo,

 

 

Here is the sample query that i am using please suggest me to get the column in the xlsx file as autofitwidth.

 

 

alasql('SELECT name as Name,class as Class,scholl_name as Scholl_Name, student_gaurdian as Gaurdian INTO XLSX("Details.xlsx",{sheetid:"Student_details"}) FROM ?', [arr]);

 

 

Thanks

 

Sandeep