search

asimlqt / php-google-spreadsheet-client

A PHP library for accessing and manipulating Google Spreadsheets
Other
543 stars 154 forks source link

How to edit cell in spreadsheet ? #152

Open shubaivan opened 8 years ago

shubaivan commented 8 years ago

Use asimlqt/php-google-spreadsheet-client bundle I crated spreadSheet 5x5 and add some subject and I dont't know how to add bold text for some cell or how paint for some color cell ?

I have image and I need 

    $spreadsheet = $spreadsheetService->getSpreadsheetById($spreadsheetId);
    $spreadsheet->addWorksheet('AOG', 5, 5);
    $worksheet = $worksheetFeed->getByTitle('AOG');
    $cellFeed = $worksheet->getCellFeed();

    $cellFeed->editCell(1, 1, 'Hourly report ');
    $cellFeed->editCell(2, 1, 'Consultant');
    $cellFeed->editCell(3, 1, 'Customer');