Reading Excel File on S3


#1

What is the best way to read an xlsx file stored on S3? For example, var files = File.make('fileLocation').readObjs() throws Unsupported content type for serialization: application/vnd.c3xcel. If the data from the Excel file doesn’t correspond to an existing type, is there any way to read the data into an object or objects?


#2

contentType should be “application/vnd.c3.data+excel”, ( future more standard excel content types will be supported.
at this time, readObjs({serType: typeName}) would give objects for C3Type. ExcelSheet or Cells are not supported as C3 data types.

see reading the content as binary and using library to parse…