I have a Matlab WebApp deployed on which I want to build an excel file with 3 different sheets that have ["Input Data", "Matlab Plots", "Export Data"]. On the "Input data" sheet, I save all the input parameters from Matlab Webapp. On the "Matlab plots" sheet, I save all the images from the WebApp plots. "Export Data" sheet has a list of coordinates X,Y,Z based on a certain no. of points.
I need to create this excel without the actxserver('Excel.Application') method as I don't have an available excel installation on the server... Is it possible with writeTable() or other methods to import the images into excel?
I would appreciate an idea on how to export string data and image data in one bundle file...
Thank you in advance!
CodePudding user response:
I found a solution to build the xlsx file from scratch without excel installed. I decompose(unzip) a template xlsx file and then change the images inside of the new folder structure, the data and so on. After this, the folder structure with xml files is rebuilt as a zip arhive and changed to xlsx format. Phew :) More info on: How to properly assemble a valid xlsx file from its internal sub-components?