{"action":"created","issue":{"url":"https://api.github.com/repos/agershun/alasql/issues/615","repository_url":"https://api.github.com/repos/agershun/alasql","labels_url":"https://api.github.com/repos/agershun/alasql/issues/615/labels{/name}","comments_url":"https://api.github.com/repos/agershun/alasql/issues/615/comments","events_url":"https://api.github.com/repos/agershun/alasql/issues/615/events","html_url":"https://github.com/agershun/alasql/issues/615","id":139010347,"number":615,"title":"Excel file : how to custom header with the name of index from javascript array","user":{"login":"Dosix","id":4478235,"avatar_url":"https://avatars.githubusercontent.com/u/4478235?v=3","gravatar_id":"","url":"https://api.github.com/users/Dosix","html_url":"https://github.com/Dosix","followers_url":"https://api.github.com/users/Dosix/followers","following_url":"https://api.github.com/users/Dosix/following{/other_user}","gists_url":"https://api.github.com/users/Dosix/gists{/gist_id}","starred_url":"https://api.github.com/users/Dosix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Dosix/subscriptions","organizations_url":"https://api.github.com/users/Dosix/orgs","repos_url":"https://api.github.com/users/Dosix/repos","events_url":"https://api.github.com/users/Dosix/events{/privacy}","received_events_url":"https://api.github.com/users/Dosix/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-03-07T15:41:56Z","updated_at":"2016-03-15T21:51:13Z","closed_at":null,"body":"Hii,\r\n\r\nI would like custom my header with the name of index from javascript array\r\n\r\n```\r\n{\"Blog international\": [\r\n{\r\n\"email\":\"email1@mydomain.fr\",\r\n\"mark\":31.25,\r\n\"coef\":1\r\n},\r\n{\r\n\"email\":\"email2@mydomain.fr\",\r\n\"mark\":49.24,\r\n\"coef\":1\r\n},{\r\n\"email\":\"email3@mydomain.fr\",\r\n\"mark\":50,\r\n\"coef\":1\r\n}],\r\n\"PowerPoint\":[\r\n{\r\n\"email\":\"email1@mydomain.fr\",\r\n\"mark\":31.25,\r\n\"coef\":1\r\n},\r\n{\r\n\"email\":\"email2@mydomain.fr\",\r\n\"mark\":49.24,\r\n\"coef\":1\r\n},{\r\n\"email\":\"email3@mydomain.fr\",\r\n\"mark\":50,\r\n\"coef\":1\r\n}],\r\n\"Culture WEB\":[\r\n{\r\n\"email\":\"email1@mydomain.fr\",\r\n\"mark\":31.25,\r\n\"coef\":1\r\n},\r\n{\r\n\"email\":\"email2@mydomain.fr\",\r\n\"mark\":49.24,\r\n\"coef\":1\r\n},{\r\n\"email\":\"email3@mydomain.fr\",\r\n\"mark\":50,\r\n\"coef\":1\r\n}]}\r\n```\r\n\r\nI want get a Excel file like this : \r\n\r\n```\r\nEmail | Blog international | PowerPoint | Culture WEB\r\nemail1@mydomain.fr  |  31.25 |  31.25 |  31.25\r\nemail2@mydomain.fr  | 49.2 | 49.2 | 49.2\r\nemail3@mydomain.fr  | 50 | 50 | 50\r\n```\r\n\r\nAny ideas how to do that ?"},"comment":{"url":"https://api.github.com/repos/agershun/alasql/issues/comments/197040533","html_url":"https://github.com/agershun/alasql/issues/615#issuecomment-197040533","issue_url":"https://api.github.com/repos/agershun/alasql/issues/615","id":197040533,"user":{"login":"nbdamian","id":16768293,"avatar_url":"https://avatars.githubusercontent.com/u/16768293?v=3","gravatar_id":"","url":"https://api.github.com/users/nbdamian","html_url":"https://github.com/nbdamian","followers_url":"https://api.github.com/users/nbdamian/followers","following_url":"https://api.github.com/users/nbdamian/following{/other_user}","gists_url":"https://api.github.com/users/nbdamian/gists{/gist_id}","starred_url":"https://api.github.com/users/nbdamian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nbdamian/subscriptions","organizations_url":"https://api.github.com/users/nbdamian/orgs","repos_url":"https://api.github.com/users/nbdamian/repos","events_url":"https://api.github.com/users/nbdamian/events{/privacy}","received_events_url":"https://api.github.com/users/nbdamian/received_events","type":"User","site_admin":false},"created_at":"2016-03-15T21:51:13Z","updated_at":"2016-03-15T21:51:13Z","body":"@mathiasrw \r\nIt seems as though an opts object is required. I believe we need a workaround to make it not required.\r\nin the alasql.into.XLSXML function,\r\nDirectly after\r\n```\r\nif(typeof filename == 'object') {\r\n\topts = filename;\r\n\tfilename = undefined;\r\n}\r\n```\r\nadd\r\n```\r\n  opts = opts || {}\r\n```\r\n\r\n@Dosix \r\nhttps://jsfiddle.net/kprk8dh1/7/\r\nShould now Download."}}