In Excel auf eine Reihe zugreifen
Verfasst: Freitag 12. Januar 2007, 12:06
Hallo Pythoncommunity,
ich habe folgendes Problem:
Mit
lese ich eine ganze Excelzeile ein. v hat dann dann type 'instance'.
und folgenden Inhalt:
((u'OPC-Item', u'Einheit', u'Beschreibung\ndeutsch / englisch', u'Bemerkungen de
utsch / englisch', u'Beschreibung\ndeutsch', u'Bemerkungen deutsch', u'Beschreib
ung\nenglisch', u'Bemerkungen englisch', u'Beschreibung\nfranz\xf6sisch', u'Beme
rkungen franz\xf6sisch', u'Beschreibung\nspanisch', u'Bemerkungen spanisch', u'B
eschreibung\nxxxxx', u'Bemerkungen xxxxx', None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None),)
Jetzt meine Frage. Ich möchte das in einer Liste haben, bekomme das aber nicht hin egal wie ich "v" wandle oder anderen Typen zuweise. Habt ihr einen Tip für mich?
Vielen dank
alpha
ich habe folgendes Problem:
Mit
Code: Alles auswählen
v = MyWorkSheet.Rows(i)
und folgenden Inhalt:
((u'OPC-Item', u'Einheit', u'Beschreibung\ndeutsch / englisch', u'Bemerkungen de
utsch / englisch', u'Beschreibung\ndeutsch', u'Bemerkungen deutsch', u'Beschreib
ung\nenglisch', u'Bemerkungen englisch', u'Beschreibung\nfranz\xf6sisch', u'Beme
rkungen franz\xf6sisch', u'Beschreibung\nspanisch', u'Bemerkungen spanisch', u'B
eschreibung\nxxxxx', u'Bemerkungen xxxxx', None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None, None, None, None, None, N
one, None, None, None, None, None, None, None, None, None, None, None, None, Non
e, None, None, None, None, None, None, None, None, None, None, None, None, None,
None, None, None, None, None, None, None, None, None),)
Jetzt meine Frage. Ich möchte das in einer Liste haben, bekomme das aber nicht hin egal wie ich "v" wandle oder anderen Typen zuweise. Habt ihr einen Tip für mich?
Vielen dank
alpha