def test_count(self):
count = Sheet.count()
assert_equal(count, 3)
def test_add_after(self):
Sheet.add(after=Sheet.count())
assert_equal(Sheet(Sheet.count()).name, Sheet.active().name)
Sheet.add(after=1)
assert_equal(Sheet(2).name, Sheet.active().name)
def test_count(self):
count = Sheet.count()
assert_equal(count, 3)
def test_add_after(self):
Sheet.add(after=Sheet.count())
assert_equal(Sheet(Sheet.count()).name, Sheet.active().name)
Sheet.add(after=1)
assert_equal(Sheet(2).name, Sheet.active().name)
try:
wbTarget = Workbook(TargetPath)
Excel_Path = os.path.join(CWPath, 'Result-Output.xlsx')
wb = Workbook(Excel_Path)
#rename worksheet
Sheet('Result',wkb=wb).name=NewSheetName
wb.set_current()
#Copy All Range
AllRRow = len(Range('A1').vertical.value)
AllRCol = len(Range('A1').horizontal.value)
print AllRCol,AllRRow
RangeLimit = ('A1:B%d' % AllRRow)
TempData = Range(RangeLimit).value
wbTarget.set_current()
lastSheetVal = Sheet.count()
OriginSArr=[]
for SheetName in xrange(1,lastSheetVal+1):
OriginSArr.append(Sheet(SheetName).name)
if NewSheetName not in OriginSArr:
print "I should Add new array"
Sheet.add('abc',after=lastSheetVal)
Sheet('abc').name=NewSheetName
#Paste Data
Range(RangeLimit).value=TempData
#hypelink
for hyperRow in xrange(2,AllRRow):
RangeName=('B%d' % (hyperRow))
address=Range(RangeName).value
def sheetCount():
return Sheet.count()
