0

I'm using gspread module to login to a 1) Google spreadsheet 2) download a column of cells 3) print/save them to a text file.

I can use string filtering, but it removes some commas that I want to keep. So using string filters is not an option. The format gives plain-text when I use "val = worksheet.acell('B1').value". But it doesn't give me plain-text when I use "cell = worksheet.cell(1, value_render_option='FORMULA').value"

I'm using burnash gspread API to login and pull the data.

sheet = spreadsheet.open('Spreadsheet Name').worksheet('Worksheet Name')

col = sheet.col_values(1, value_render_option='FORMULA')

print str(col)

The problem is, it gives the values as ['[u\'Text in Row 1', u\'Text in Row 2', u\'Text in Row 3'] instead of "Text in Row 1Text in Row 2Text in Row 3" (which is what I want the output to show)

Tiam Abderezai
  • 3
  • 2

1 Answers1

0

'u' is the text representation of the corresponding Unicode string.

Suppose u' occurs in a variable test, it could be removed by:

test.encode("utf-8")

Checkout This link for more ways.

And for List like

test_list = ['Text in Row 1','Text in Row 2','Text in Row 3']

Run the following code:

test_list = ['Text in Row 1','Text in Row 2','Text in Row 3']

output_list = " ".join(str(x) for x in test_list)

print(output_list)

And the output would be :

Text in Row 1 Text in Row 2 Text in Row 3

Lakshya Srivastava
  • 659
  • 9
  • 22