Magento – Magento export products in Excel format without third party library

exportformatmagento-1.9product-gridproducts

I am using Magento CE-1.9.2.x in my website.

Now I want Catalog >> Manage Products >> Actions select box to include the Export Products to XLS option, with only a custom controller and custom action in background to be able to export products to xls format.

I have seen content-type of application/octet-stream is allowed in _prepareDownloadResponse() function, how this can help me and also what should be column-separator for xls format ?

I want this with default Magento functions without the use of any third party libraries.

I have searched a lot on Google but couldn't find a reliable code block or post for this.

Hope anyone here can help me out.

Best Answer

.csv use "," seperated.

while .xls format uses tab seperated.

so remove "," and replace with Tab or "\t".

I hope this will help you.

Related Topic