{"action":"closed","issue":{"url":"https://api.github.com/repos/tealeg/xlsx/issues/102","labels_url":"https://api.github.com/repos/tealeg/xlsx/issues/102/labels{/name}","comments_url":"https://api.github.com/repos/tealeg/xlsx/issues/102/comments","events_url":"https://api.github.com/repos/tealeg/xlsx/issues/102/events","html_url":"https://github.com/tealeg/xlsx/issues/102","id":64896647,"number":102,"title":"merged cell","user":{"login":"linlexing","id":834303,"avatar_url":"https://avatars.githubusercontent.com/u/834303?v=3","gravatar_id":"","url":"https://api.github.com/users/linlexing","html_url":"https://github.com/linlexing","followers_url":"https://api.github.com/users/linlexing/followers","following_url":"https://api.github.com/users/linlexing/following{/other_user}","gists_url":"https://api.github.com/users/linlexing/gists{/gist_id}","starred_url":"https://api.github.com/users/linlexing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/linlexing/subscriptions","organizations_url":"https://api.github.com/users/linlexing/orgs","repos_url":"https://api.github.com/users/linlexing/repos","events_url":"https://api.github.com/users/linlexing/events{/privacy}","received_events_url":"https://api.github.com/users/linlexing/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/tealeg/xlsx/labels/waiting%20for%20confirmation%20from%20user","name":"waiting for confirmation from user","color":"c7def8"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-03-28T04:19:09Z","updated_at":"2015-10-02T21:26:57Z","closed_at":"2015-10-02T21:26:57Z","body":"Do not see how to read and write the merged cell.Such as：\r\n\r\n<table>\r\n<tr><td>A</td><td>B</td></tr>\r\n<tr><td colspan=2 align=center>C</td></tr>\r\n</table>\r\n\r\nat (https://github.com/SheetJS/js-xlsx)\r\n>ws['!merges']: array of range objects corresponding to the merged cells in the worksheet. Plaintext utilities are unaware of merge cells. CSV export will write all cells in the merge range if they exist, so be sure that only the first cell (upper-left) in the range is set.\r\n\r\nbut not found read and write the merged cell at this project."}}