0

I created custom admin grid in my module. And CSV Export for it works fine, but Excel XML Export does not contain any rows data

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet">
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office"></OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel"></ExcelWorkbook>
<Worksheet ss:Name="transactions_listing.xml"><Table><Row><Cell><Data ss:Type="String">Transaction ID</Data></Cell><Cell><Data ss:Type="String">Customer Name</Data></Cell><Cell><Data ss:Type="String">Amount</Data></Cell><Cell><Data ss:Type="String">Comment</Data></Cell><Cell><Data ss:Type="String">Created At</Data></Cell></Row></Table></Worksheet>
</Workbook>

So, there are only column names in it

Any ideas why's that?

0

It works after I added this to my Collection.php

/**
 * Id field name
 * @var string
 */

protected $_idFieldName = 'transaction_id';
1
  • i am also facing same issue...can you post complete answer . – Anand Ontigeri Feb 23 '17 at 8:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.