Alasql: Export to XLSX with cells formatting

[akob]

Hi!

I want to export some data to .xlsx file with additional styles like different column width, bold heder and cells with differnt background. But I've found how it will be done only for .xls.

https://jsfiddle.net/dsn9xobr/

https://github.com/agershun/alasql/wiki/XLSX
alasql.promise('SELECT * INTO XLSXML("restest280b.xls",?) FROM ?',[mystyle,data])

Is it possible to use your ALASQL for this pupose?

[akob]

Hi! Are there any updates?

[mathiasrw]

@agershun any inputs on this?

[akob]

Hey!
Is this project alive?

[kanghj]

@akob, I think the project is alive, but there doesn't seem to be anyone familiar with the xls/xlsx part of it who's still maintaining the project. As far as I can tell, pull requests are very welcome though.

[nickdeis]

Personal input and experience: I only use the xlsx/xls plugin for very simple sheets. Basically, when I need to export multiple tables.
Anything else, I think it's far better to either:

• Do it programmatically
• Silently render a fully inlined styled HTML4 table and export that instead. See this gist

The latter option is almost always ideal because you can get a very good idea about how it will look exported.
The former option is not such a great ideal, but gives you access to custom properties.

React has been a great tool for in-lining styles into static html.

[Suncatcher]

@nickdeis does your approach support multi-sheet export?

[nickdeis]

Hey @Suncatcher,
Excellent question, never had that requirement (amazingly).
Didn't think you could, but apparently it's possible?
I'd still use inline styling instead of data attributes.
Cheers,
Nick

[Suncatcher]

Didn't think you could, but apparently it's possible?

I read this SO question before, but unfortunately all of those answers involve javascript function expressions which my environment (SAP) doesn't support (( So I cannot use them.
BTW, is there any service which converts function expressions into usual functions? :) As i got it, they don't require special libs or JS version (am I wrong?), and are just a special form of function writing.

[nickdeis]

Huh, you mean even like something like this wouldn't work?
```javascript
var x = function x(){/Scope code here/}()
````

[Suncatcher]

Huh, you mean even like something like this wouldn't work?

Yeah, unfortunately it doesn't.

[nickdeis]

Nor this?

function x(){/*Scope code here*/};
x();

[Suncatcher]

Nor this?

But this is not expression, it's regular function.

[nickdeis]

Yea, but you can still scope code in the function. It's effectively an IIFE expression, you just have to declare it as a function.