search

PHPOffice / PHPExcel

ARCHIVED
Other
11.47k stars 4.19k forks source link

Set Viewarea possible? Viewport #392

Open ToxSox opened 10 years ago

ToxSox commented 10 years ago

I search a funtion in phpexcel that allows me to set the viewarea after open the Excel Sheet. I tried to set the selected Cell with:

->getActiveSheet()->setSelectedCell('FD1');

but that only selects the Cell but the file open and the View shows from beginning A1 ...

It is possible to set the viewport?

MarkBaker commented 10 years ago

Take a look at the worksheet's setSheetView() method. The sheetView object allows you to set normal, page layout and page break preview options using the setView() method

dirtyrobinson commented 9 years ago

I know its almost been a year since this was asked but I'm wondering is it possible to set the view area when the file is opened?