search

a-marenkov / gsheets

A Dart library for working with Google Sheets API.
Other
79 stars 31 forks source link

Import/Export functionality #47

Closed JTPenn-EG closed 2 years ago

JTPenn-EG commented 3 years ago

Adding import/export functionality from csv/xlsx will be extremely helpful in alot of situations, for example when you need to give offline versions of the spreadsheet to your customers which they can edit however they want and receive their edited version and decide whether to import it to the original spreadsheet or not.

a-marenkov commented 3 years ago

@JTPenn-EG Hi, what api do you have in mind?

nsvetlakov commented 3 years ago

Good afternoon, How can I download a table(sheet) in pdf format? Or send only a sheet in pdf format to the mail?

a-marenkov commented 3 years ago

Good afternoon, How can I download a table(sheet) in pdf format? Or send only a sheet in pdf format to the mail?

Hi @nsvetlakov

There's no such functionality in gsheets.

You can try to download spreadsheet in csv (maybe in pdf also) see https://stackoverflow.com/questions/11619805/using-the-google-drive-api-to-download-a-spreadsheet-in-csv-format/51235960#51235960

a-marenkov commented 3 years ago

Good afternoon, How can I download a table(sheet) in pdf format? Or send only a sheet in pdf format to the mail?

Hi @nsvetlakov i tried to export file and seems to work even with private spreadsheets

added following method https://pub.dev/documentation/gsheets/latest/gsheets/Spreadsheet/export.html

nsvetlakov commented 3 years ago

Good afternoon, How can I download a table(sheet) in pdf format? Or send only a sheet in pdf format to the mail?

Hi @nsvetlakov i tried to export file and seems to work even with private spreadsheets

added following method https://pub.dev/documentation/gsheets/latest/gsheets/Spreadsheet/export.html

Great, It will need to be redone in my application.

And so I found a way to download pdf)))

I copied the sheet to another table and downloaded it using the curl link and then saved it.

nsvetlakov commented 3 years ago

Good afternoon, How can I download a table(sheet) in pdf format? Or send only a sheet in pdf format to the mail?

Hi @nsvetlakov i tried to export file and seems to work even with private spreadsheets

added following method https://pub.dev/documentation/gsheets/latest/gsheets/Spreadsheet/export.html

Awesome!!! Thank you very much!!!