2021年4月27日星期二

About using alasql export to set column width

My data is in array format,as follows:

                var arr = [                  ["culomn1", "culomn2", "culomn3", "culomn4", "culomn5"],                  ["a1", "a2", "a3", "a4", "a5"],                  ["b1", "b2", "b3", "b4", "b5"]];                    var opts = {                  headers: false,                  column: { style: 'width:200px'}              };                               alasql.promise('SELECT * INTO XLSX("' + self.dateFormat(new Date(), 'yyyyMMddhhmm') + '_Detail' + '.xlsx",?) FROM ?', [opts,arr])                  .then(function (data) {                      if (data == 1) {                          self.notification.toastSuccess($translate.instant('modules.common.exportSuccess'));                      }                  })  

But it didn't work,Is there any solution? Thank you for your help

https://stackoverflow.com/questions/67293214/about-using-alasql-export-to-set-column-width April 28, 2021 at 11:09AM

没有评论:

发表评论