Ohloh by Black Duck

 Follow @ Meta   Join Now

 Settings |  Report Duplicate
Moderate Activity
9

News

  Analyzed about 2 hours ago based on code collected about 2 hours ago.
 
New Post: Format Text with leading apostrophe
Posted about 5 hours ago by savvi189
Need to format the header row of my file to be formatted as that when you view the cell in the Excel spreadsheet it shows as HEADER but when you click that cell in the formula bar it shows 'HEADER.

I've tried seemingly just about everything ... [More] with no luck. Whatever i try displays it in the cell as 'HEADER. However if I double click that cell in Excel it autoformats the way I want and strips the apostrophe out of the cell and leaves it in the formula bar.
And excel does that as well in a new cell where I type 'WHATEVER it will just display WHATEVER in the cell and still display 'WHATEVER in the formula bar.

How can I do this so it's already displayed that way when I create my Excel file with phpExcel?

This is how I'm inserting the values right now.

$objPHPExcel->getActiveSheet()->setCellValueExplicit($currentColumn.$currentRow, $data, PHPExcel_Cell_DataType::TYPE_STRING);

$data would just be a string preceded by an apostrophe. [Less]
Commented Unassigned: iOS Numbers Spreadsheet Read Data Problem [19868]
Posted about 7 hours ago by Sebassis
Hi All,

We've been working on a site that reads and parses data out of spreadsheets and this is all working fine. Well it was until we tried reading in a an xls spreadsheet that was created with iOS Numbers on an iPad. Whenever we try to ... [More] read in the data from a Numbers spreadsheet we get the number of rows to be 0. We just don't seem to be able to get any data out of the spreadsheet even though it opens fine in MS Excel.

Has anyone else had this problem? Anyone got a solution?

Thanks,
Steve.
Comments: ** Comment from web user: Sebassis ** Here's the file. [Less]
Commented Unassigned: iOS Numbers Spreadsheet Read Data Problem [19868]
Posted about 7 hours ago by Sebassis
Hi All,

We've been working on a site that reads and parses data out of spreadsheets and this is all working fine. Well it was until we tried reading in a an xls spreadsheet that was created with iOS Numbers on an iPad. Whenever we try to ... [More] read in the data from a Numbers spreadsheet we get the number of rows to be 0. We just don't seem to be able to get any data out of the spreadsheet even though it opens fine in MS Excel.

Has anyone else had this problem? Anyone got a solution?

Thanks,
Steve.
Comments: ** Comment from web user: Sebassis ** Hi All,

I've now finally been able to get onto an iPad and export out a test spreadsheet so you can try it yourself. I'm using the latest build of phpexcel downloaded from GitHub and here's the code:

```
require_once 'Classes/PHPExcel/IOFactory.php';
$objReader = new PHPExcel_Reader_Excel5();
$objReader->setReadDataOnly(true);
$objPHPExcel = $objReader->load("ios_numbers_spreadsheet.xls");

for ($i=1 ; $i<=20 ; $i++) {
foreach(range('A','N') as $a) {
$storeArray[$a . $i] = $objPHPExcel->getActiveSheet()->getCell(($a . $i))->getValue();
}
}

var_dump($storeArray);

```

and here's a sample of the output I'm getting:

> array(280) {
["A1"]=>
NULL
["B1"]=>
NULL
["C1"]=>
NULL
["D1"]=>
NULL
["E1"]=>
NULL
["F1"]=>
NULL
["G1"]=>
NULL
["H1"]=>
NULL [Less]
New Post: Generate pdf from .xlsx
Posted about 8 hours ago by duyleduc
Is that possible to conserve all format (resultat of formulas, header and footer, image) when converting a .xlsx to .pdf? Which 3rd party (mpdf or tcpdf or dompdf) should we use?
My serveral code is in the following:
$rendererName = ... [More] PHPExcel_Settings::PDF_RENDERER_MPDF;
$rendererLibrary = 'mpdf';

$rendererLibraryPath = '../includes/PHPExcel_1.7.9/'. $rendererLibrary;
if (!PHPExcel_Settings::setPdfRenderer(
$rendererName,
$rendererLibraryPath
)) {
die(
'Please set the $rendererName and $rendererLibraryPath values' .
PHP_EOL .
' as appropriate for your directory structure'
);
}
$header = PHPExcel_IOFactory::createReader('Excel2007');
$obPHPExcel = $header->load($pathFile.'/Bilan de puissance.xlsx');

$objWriterPDF = new PHPExcel_Writer_PDF($obPHPExcel);
$objWriterPDF->save("test.pdf");

It can't keep the header, image and formulas's result [Less]
New Post: HLOOKUP function PHPEXCEl not working with dynamic data: Workaround
Posted about 14 hours ago by amerov
Cool! Thanx for the update!!!
New Post: add image & text to the header
Posted about 15 hours ago by duyleduc
AzriMan wrote:

--edited although excel2007 allows to add both images and text to header/footer

How can you do that? I use excel2007 and I can't add both +;=
New Post: Add Image and Text in header Excel5 v1.7.9
Posted about 16 hours ago by duyleduc
How can I add both image and text to header in excel5 with v1.7.9? (Does it support to do it)

Thanks :)
New Post: Possible to ensure columns are max width and fit all content?
Posted about 19 hours ago by LWol
You can use (from doc 4.6.28):
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
New Post: Problem setCellValueExplicit with PHPExcel_Cell_DataType::TYPE_STRING
Posted about 21 hours ago by eamaya
Thank..
New Post: Problem with load function
Posted 2 days ago by LWol
Line 1702 in reader is : $docSheet->getPageSetup()->setPrintArea(implode(',',$newRangeSets));

This line is called if there is one or more defined print areas.
I do not know what led to have #N/A at this location (a few quick tests ... [More] show a range valid or not name).

Quick fix: adds a test to this line checking the absence of #N/A in $extractedRange before calling setPrintArea.
(There are more elegant solutions but this should troubleshoot you quickly)

I think that Mark will have a look at this file or know how it manages to get this case [Less]
 

 
 

Project Summary

Code Data

SCM Data

Community Data

 

Creative Commons License Copyright © 2013 Black Duck Software, Inc. and its contributors, Some Rights Reserved. Unless otherwise marked, this work is licensed under a Creative Commons Attribution 3.0 Unported License . Ohloh ® and the Ohloh logo are trademarks of Black Duck Software, Inc. in the United States and/or other jurisdictions. All other trademarks are the property of their respective holders.