search

a-marenkov / gsheets

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

Add functionality to extract Links from image Columns (Raw function values) #61

Open KevinCCucumber opened 2 years ago

KevinCCucumber commented 2 years ago

I will just give an example. I want the imagelink from column 2 and 3 from this spreadsheet:

My code is: 

List<List<String>> allRows = await tabSheet.values.allRows();

print(allRows);

This is the print from the first row:

[acid-washed jeans, , , Black, No, 1320, 330, 51, Black, Black, 1x1, 1200, Poki, Able Sisters, Available from either Mabel's temporary shop or Able Sisters shop, NA, NA, All Year, Autumn, NA, Free, Simple, Simple, everyday; outdoorsy, 1, No, For sale, 1.0.0, Yes, BottomsTexPantsNormalChemical1, 649, 11385, a7HNjgRFkCznkDLLH]

Currently if I fetch the sheet, it prints an empty string into the place I would expect the "image("link")" function.

I would like to have an optional bool like getAllRows(getRawvalues: true) where you can enable that functions get casted to strings so I get the raw text from that column.