Skip to main content
Question

How to give Autofitwidth to xlsx file using alasql

  • February 6, 2018
  • 3 replies
  • 19 views

Hi can anyone please help me to find an answer to keep autofitwidth to all columns in xlsx file

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

danilo_fme
Celebrity
Forum|alt.badge.img+52
  • Celebrity
  • February 10, 2018

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

Thanks,

Danilo


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

 


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