Convert Excel BLOB to javascript array

Question

Using Google Apps Script, I seek to extract the cell contents of an Excel file (.xls) (delivered as a Gmail attachment) and deposit those cell contacts into a 2-dimensional javascript array[ ][ ].

var excelFile = GmailApp.getInboxThreads(0,1)[0].getMessages()[0].getAttachments()[0];

At this point, I have a BLOB with ContentType = "application/vnd.ms-excel".

How do I convert this “Excel” blob into a 2D (Google Apps Script / javascript) array I can use?

Illustrative note: I want to do what’s described here only using Google Apps Script / javascript.

UPDATE: Methods for accomplishing this the way I have described seem sparse. Approaching it differently, perhaps I could (programatically) convert the Excel file to a Google Drive Spreadsheet? Then the data extraction is trivial using Google Apps Script. Perhaps someone from Google support could explain how to programatically convert an Excel file in a Gmail attachment to a Google Drive spreadsheet using Google Apps Script?

Srik · Accepted Answer · 2012-09-03 05:09:48Z

2

There is no way you can do it using Apps Script now, but there is an open issue requesting for this feature. You can star the issue to vote for it and be notified of updates.

answered Sep 3, 2012 at 5:09

Srik

7,9952 gold badges22 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert Excel BLOB to javascript array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related