PHPExcel was great tool for reading and manipulating Excel files. I'm grateful to find these.

And i would like to request some usefull function:

- function $objPHPExcel->getAllSheetsIntoArray() : this function will fasten the coder rather than to write the iteration for all the sheets

- function $objPHPExcel->setActiveSheetByName('Sheet XXX') : why we only have index, while we have to iterates all the sheets above than doing an array_flip to get its index than assign as the name provided. That taken too much useless script.

- setCellValue('A20', ... we should provide another naming convention of the column like A20 into 1:20, because sometimes coder may create a loop on the column, if we create 1 to 100 column than we should make a translator function like 1 as A, 2 as B, xx as AA, xx as AB, xxx as ABC, ... (the hell to make it), so i suggest to make another name function like setCellValue('1:20', ... and then the function will translate itself, its easy isn't it programmers?

I believe that will make them a Perfect tools for reading Excel. Thank You.

Oh yeah another great request, don't know if its already provided though:

is it possible to make a search function in the range provided, maybe something like this:

function searchContent(FROM_CELL,TO_CELL,STRING_HAYSTACK)

ex: searchContent("A1","K10","haystack") => will return an array of value along with its position ex: array("A2"=>'haystack1',"A10"=>'haystack2',"B5"=>'haystack3')

this function will be a great help i think, thanks.

brilien wrote:

- function $objPHPExcel->getAllSheetsIntoArray() : this function will fasten the coder rather than to write the iteration for all the sheets

How does this compare with the current $objPHPExcel->getAllSheets() ?

brilien wrote:

- function $objPHPExcel->setActiveSheetByName('Sheet XXX') : why we only have index, while we have to iterates all the sheets above than doing an array_flip to get its index than assign as the name provided. That taken too much useless script.

Now implemented:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=11529

brilien wrote:

- setCellValue('A20', ... we should provide another naming convention of the column like A20 into 1:20, because sometimes coder may create a loop on the column, if we create 1 to 100 column than we should make a translator function like 1 as A, 2 as B, xx as AA, xx as AB, xxx as ABC, ... (the hell to make it), so i suggest to make another name function like setCellValue('1:20', ... and then the function will translate itself, its easy isn't it programmers?

I'm a bit worried about this notation. '1:20' look like the selection of rows 1 through 20.

We already have setCellValueByColumnAndRow(0, 20, ...). Does it not suffice?

brilien wrote:

is it possible to make a search function in the range provided, maybe something like this:

function searchContent(FROM_CELL,TO_CELL,STRING_HAYSTACK)

ex: searchContent("A1","K10","haystack") => will return an array of value along with its position ex: array("A2"=>'haystack1',"A10"=>'haystack2',"B5"=>'haystack3')

this function will be a great help i think, thanks.

Perhaps this can be expressed in terms of Excel functions? If so, it may already be available via the calculation engine?

koyama wrote:

How does this compare with the current $objPHPExcel->getAllSheets() ?

not that simple, but well if you insists that will do.

koyama wrote:

Now implemented:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=11529

that will be awesome

koyama wrote:

I'm a bit worried about this notation. '1:20' look like the selection of rows 1 through 20.

We already have setCellValueByColumnAndRow(0, 20, ...). Does it not suffice?

well that will be a help. but the fact is you have that naming convention in all of your modules.

for example some other function like "$objPHPExcel->getActiveSheet()->getStyle('A12')->getFont()->setBold(true);", did you really have the function like getStyleByColumnAndRow(('1','12') too ???

I think you should rearrange all of the modules with the new cell pointer convention, off course you should be worried of that :-)

and that naming convention doesn't have to be in my requested format (1:20), you can add another character delimiter (it's up to you) such as 1_20 or 1,20 or 1/20 or anything else

the only purpose is that user will iterate it more freely using digits rather than using alphabet-digit iteration

I've been gooling awhile for php excel, some of them like excelReader or excelWriter support the digits pointer convention rather than using excel original alphabet-digit pointer

Make it possible to shift selected range(cells) or entire row and column either vertically or horizontally.

I'm suggesting an API like this.

$sheet->getCell('A1')->shift(PHPExel_SomeShifter::CELL_RIGHT);
$sheet->getCell('A1')->shift(PHPExel_SomeShifter::CELL_DOWN);
$sheet->getCell('A1')->shift(PHPExel_SomeShifter::ROW); //might be similar to insertNewRowBefore
$sheet->getCell('A1')->shift(PHPExel_SomeShifter::COLUMN);

$sheet->getCells('A1:B1')->shift(PHPExel_SomeShifter::CELL_RIGHT);
$sheet->getCells('A1:B1')->shift(PHPExel_SomeShifter::CELL_DOWN);
$sheet->getCells('A1:B1')->shift(PHPExel_SomeShifter::ROW);
$sheet->getCells('A1:B1')->shift(PHPExel_SomeShifter::COLUMN);

brilien wrote:

and that naming convention doesn't have to be in my requested format (1:20), you can add another character delimiter (it's up to you) such as 1_20 or 1,20 or 1/20 or anything else

the only purpose is that user will iterate it more freely using digits rather than using alphabet-digit iteration

I've been gooling awhile for php excel, some of them like excelReader or excelWriter support the digits pointer convention rather than using excel original alphabet-digit pointer

I'm a bit worried about this notation. '1:20' look like the selection of rows 1 through 20.

We already have setCellValueByColumnAndRow(0, 20, ...). Does it not suffice?

I see your point. When I think about it there is also the possibility that we can allow the familiar R1C1 notation, e.g. getCell('R20C1') as equivalent of getCell('A20')

We need to think.

marfillaster wrote:

Make it possible to shift selected range(cells) or entire row and column either vertically or horizontally.

I'm suggesting an API like this.

$sheet->getCell('A1')->shift(PHPExel_SomeShifter::CELL_RIGHT);
$sheet->getCell('A1')->shift(PHPExel_SomeShifter::CELL_DOWN);
$sheet->getCell('A1')->shift(PHPExel_SomeShifter::ROW); //might be similar to insertNewRowBefore
$sheet->getCell('A1')->shift(PHPExel_SomeShifter::COLUMN);

$sheet->getCells('A1:B1')->shift(PHPExel_SomeShifter::CELL_RIGHT);
$sheet->getCells('A1:B1')->shift(PHPExel_SomeShifter::CELL_DOWN);
$sheet->getCells('A1:B1')->shift(PHPExel_SomeShifter::ROW);
$sheet->getCells('A1:B1')->shift(PHPExel_SomeShifter::COLUMN);

Adding this as a work item so that others can vote.

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=11552

Ok then... to Mr Koyama i've already sent you a PM regarding the alphabetical naming, maybe you just get too busy so i think i should put it here, so we won't miss it.

I contribute this function and hope that you put one similar function in your code that can be called anywhere anytime, lately i found problem from iterating my data in X direction, and errors occured because i'm not prepared for the worst possibility of data explosion in X direction.

Here:

function numeric_to_excel_alpha($integer=1){
    $div=floor($integer/26);
    $mod=$integer%26;
    if($mod==0){
        $div=$div-1;
        $mod=26;
    }
    if($div>0){
        return numeric_to_excel_alpha($div).chr(64+$mod);
    }else{
        return chr(64+$mod);
    }
}

Hope this help.

Keep the great job!

Btw i never try it intensively, if you put 0 or minus integer or floating point for the $integer, i don't know will happen. I haven't put the errors callback. But that's the main point.

brilien wrote:

I contribute this function and hope that you put one similar function in your code that can be called anywhere anytime, lately i found problem from iterating my data in X direction, and errors occured because i'm not prepared for the worst possibility of data explosion in X direction.

You mean something like PHPExcel_Cell::stringFromColumnIndex() or its sister helper method PHPExcel_Cell::columnIndexFromString() ?

Yes that's what i'm looking for, I've got the same replied from Mr Koyama. That's solve my problem for the excel naming convention.

Seems that you should put that in the first page of the documentation.

Thanks for that.

Hello

Thank you for this awesome library.

Here is my feature request : ability to style column or rows.

For example :

$objPHPExcel->getActiveSheet()->setSharedStyleByRow($style, 2);
$objPHPExcel->getActiveSheet()->setSharedStyleByColumn($style, 'A');

$objPHPExcel->getActiveSheet()->getStyleByRow(2);
$objPHPExcel->getActiveSheet()->getStyleByColumn('A');

Thomas

twitomato wrote:

Hello

Thank you for this awesome library.

Here is my feature request : ability to style column or rows.

For example :

 

$objPHPExcel->getActiveSheet()->setSharedStyleByRow($style, 2);
$objPHPExcel->getActiveSheet()->setSharedStyleByColumn($style, 'A');

$objPHPExcel->getActiveSheet()->getStyleByRow(2);
$objPHPExcel->getActiveSheet()->getStyleByColumn('A');

 

Thomas

Can you check this work item:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=7333

You should already now be able to style row and columns like, e.g. this:

$objPHPExcel->getActiveSheet()->getStyle('2')->applyFromArray(...);
$objPHPExcel->getActiveSheet()->getStyle('A')->applyFromArray(...);

I'd like the ability to change the default workbook view (ex. Normal, Page Layout, Page Break Preview).

Thanks.

Being able to set the indexed colors on the fly would be a good feature. Ref: http://phpexcel.codeplex.com/discussions/249098

Some methods to edit the indexed colors array would seem to be a logical choice.

Feature request :All dynamically objects (In priority order) :

• Checkbox (Checkboxes + Templates)
• Text Box
• Ellipse
• Right Connector

acrooks wrote:

I'd like the ability to change the default workbook view (ex. Normal, Page Layout, Page Break Preview).

Thanks.

+1

Thank you for your good work!