It’s the same values/tuple that I am passing back and it does not work - why??? [otherwise the code is of no significance - just trying out the various methods]
def Hello(*args, **kwargs):
doc = XSCRIPTCONTEXT.getDocument()
sheet = doc.Sheets[0]
col = sheet.Columns[0]
cell = sheet.getCellByPosition(0,0)
visible_cells = sheet.queryVisibleCells()
for item in dir(visible_cells):
print(item, ' ', end=' ')
for srvc in visible_cells.getSupportedServiceNames():
print(srvc)
import inspect
x = sheet.getColumnDescriptions()
print(x, type(x)) #sheet.Data
try:
sheet.setColumnDescriptions( x ) #<-------------------------------
except Exception as e:
print(dir(e))
raise
There is no task - I am just trying to learn/familiarize myself with it… (the methods) I was able to pull the column names (‘Column A’, ‘Column B’, ‘Column C’, ‘Column D’, ‘Column E’, ‘Column F’, ‘Column G’) <class ‘tuple’> BUT I can’t set them!
