Why some text aren't export in excel with phpexcel but showing in my database and array?

159 Views Asked by At

I am using phpexcel to export my data into excel but some words are not exporting into excel but these words are showing in Array when I print_r my data

These are few lineswhich are not exporting but showing in array -

  1. Over 44 million Microsoft customers using leaked passwords

  2. New Zealand's White Island Volcano Suddenly Erupted While Tourists Were Visiting

  3. K'taka bypolls: BJP leads in 10, Congress, JD-S in 2 each

  4. Ten Cool and useful gadgets that make great last-minute gifts and all are under $50

  5. The farmer who left GOP: Trump 'has failed' at replacing NAFTA

  6. Huge investment in Odisha by Centre: President

  7. 44 million Microsoft customers using leaked passwords

Here is my PHP code -

if ($result['type'] == "WEB") {
    $sheet->setCellValue('M' . ($results + 2), $result['headline']);
   //exporting headline data
    $sheet->getCell('M' . ($results + 2))->getHyperlink()->setUrl($result['url']);
    $sheet->getCell('M' . ($results + 2))->getHyperlink()->setTooltip('Navigate to website');
}
0

There are 0 best solutions below