work with excel files in memory excel files in memory can be manipulated directly without saving it to physical disk and vice versa this is useful in excel file handling at file upload or in excel file download for exampleimport pyexcel content " , , \ , , sheet pyexcel get_sheet(file_type="csv"file_content=contentsheet csv ' , , \ \ , , \ \nfile type as its attributes since version each supported file types became an attribute of the sheet and book class what it means is that read the content in memory set the content in memory for exampleafter you have your sheet and book instanceyou could access its content in support file type by using its dot notation the code in previous section could be rewritten asimport pyexcel content " , , \ , , sheet pyexcel sheet(sheet csv content sheet array [[ ][ ]read any supported excel and respond its content in json you can find real world example in examples/memoryfiledirectorypyexcel_server py here is the example snippet def upload()if request method ='postand 'excelin request fileshandle file upload filename request files['excel'filename extension filename split(")[- obtain the file extension and content pass tuple instead of file name content request files['excel'read(if sys version_info[ in order to support python have to decode bytes to str content content decode('utf- 'sheet pe get_sheet(file_type=extensionfile_content=contentthen use it as usual sheet name_columns_by_row( respond with json return jsonify({"result"sheet dict}return render_template('upload html'request files['excel'in line holds the file object line finds out the file extension line obtains sheet instance line uses the first row as data header line sends the json representation of the excel file back to client browser support the project