Hi,

I am using "7.x-3.0-beta7" version of this module. When I open the exported XLS file in windows or mac excel readers there are no grid lines displayed in the .xls file. But, when open this file on ubuntu Libre office, I get the proper grid layout.

Please help me in this.

Thanks in advance.

Comments

shree.yesare’s picture

shree.yesare CreditAttribution: shree.yesare commented
Status: Active » Closed (fixed)

:(
Just added, table border="1"
and it solved the issue.

bundes’s picture

bundes CreditAttribution: bundes commented

if you really want gridlines you can add a views-data-export-xls-header.tpl.php to your theme and paste the following code into it:

<html xmlns:x="urn:schemas-microsoft-com:office:excel">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <!--[if gte mso 9]>
    <xml>
    <x:ExcelWorkbook>
    <x:ExcelWorksheets>
    <x:ExcelWorksheet>
    Name of the sheet
    <x:WorksheetOptions>
    <x:Panes>
    </x:Panes>
    </x:WorksheetOptions>
    </x:ExcelWorksheet>
    </x:ExcelWorksheets>
    </x:ExcelWorkbook>
    </xml>
    <![endif]-->
  </head>
  <body>
    <table>
    <?php print $header_row; ?>
    <tbody>
brunoxc’s picture

brunoxc CreditAttribution: brunoxc commented

Hi, I've put a border: 1px, but the line keeps to thick when exported to excel, I just want a simple one. What can I do?

suman.abc’s picture

suman.abc CreditAttribution: suman.abc commented

Solution #2 provided by @bundes really works.

kohinur’s picture

kohinur CreditAttribution: kohinur commented

yes really works solution #2