nao-pon/flysystem-google-drive

How to get sheet data using sheet name in spreadsheet?

w99910 opened this issue · 4 comments

w99910 commented

I'm trying to import sheet data using laravel excel package and the following is what I did before.

\Maatwebsite\Excel\Facades\Excel::import(new \App\Imports\DataImport(), 'spreadsheetId', 'google', \Maatwebsite\Excel\Excel::XLSX);

It loaded all data inside the spreadsheet. But what if I wanna load certain sheet inside the spreadsheet?

In my google drive, I have 'abcdedfg' spread sheet and it has 'test' named sheet. How can I get data inside 'test' sheet?

I have been finding the answer for so long but didn't find it yet.

PaolaRuby commented

This is a google drive package, only read, upload and download, you need a \Google_Service_Sheets package for that, look at this example GoogleSheetsPathManager.php, also you can download all the file content, update it on local, and upload all the file content again, overwriting old file

  • ❤️1
pankajthakur007 commented

@PaolaRuby Can i create spreadsheet using nao-pon/flysystem-google-drive package? OR is there any package in laravel 8 for create spreadsheet

PaolaRuby commented

This is a google drive package, only read, upload and download, you need a \Google_Service_Sheets package for that, look at this example GoogleSheetsPathManager.php, also you can download all the file content, update it on local, and upload all the file content again, overwriting old file

@pankajthakur007 Wow, I thought that I had made it clear that nao-pon/flysystem-google-drive package is not good for that, also I left an example of how to do it, you didn't even check it for sure, also there is Google Search and Packagist for package's search, this place is for flysystem-google-drive's issues

w99910 commented

This is a google drive package, only read, upload and download, you need a \Google_Service_Sheets package for that, look at this example GoogleSheetsPathManager.php, also you can download all the file content, update it on local, and upload all the file content again, overwriting old file

Hi @PaolaRuby
Sorry for late reply. I will try as you suggested. Thanks for your message.
Best regards,

  • 👍1