Skip to content

v2.6.2

Latest
Compare
Choose a tag to compare
@ryuichiueda ryuichiueda released this 03 Jul 00:47

This version gets the feature for handling xlsx files.

### T["sheet name"] is a DataFrame object of Pandas ###
$ opy -t xlsx '{a = T["Sheet1"].values};[a]' ./testdata/test.xlsx
[[123 datetime.datetime(2021, 1, 1, 0, 0) nan]
 ['危険シェル芸' 'ドラゴン曲線' nan]
 ['キュアエンジニア' '素数' nan]
 ['エ"ク"シ"ェ"ル"芸' '変,態,シ,ェ,ル,芸' nan]
 [1 2 3.0]
 [nan nan nan]]
$ opy -t xlsx '[T["Sheet1"][0][0]]' ./testdata/test.xlsx 
123