Dyntools Overwrite Excel Sheet

camerond12
3 ●6 ●7 ●8

Hello,

I am using dyntools to output data to excel.

dyntools.CHNF.xlsout(xlsresult, channels=[], show=False, xlsfile=xlsoutput, outfile=outfile, overwritesheet = True)

This is the code I am using, I believe that overwritesheet = True should overwite sheet1 every time I run the script.

I currently need to delete the old excel sheet every time I re run my script or else the excel workbook will create new sheets of the same data, which causes the file to become huge.

What should I do?

Thanks

add a comment

5 answers

Sort by » oldest newest most voted

answered May 10 '19

jconto
2756 ●10 ●30 ●41

In v.33.12, the overwritesheet setting works as expected. The following is the code I used:

   try: 
     chnfobj.xlsout(channels=mychannels, 
                    outfile=filei,
                    xlsfile=XLSfile,
                    sheet=sheetname,
                    overwritesheet = True,
                    show=False 
                    )
   except:
     print '\n ERROR: Exporting Channels to %s Excel file, sheet %s failed.'%(XLSfile,sheetname)

link

add a comment

answered May 10 '19

drsgao
76 ●5 ●7 ●11

I found that even if you set overwritesheet = True, it does not always overwrite it. In fact, I have encountered multiple cases where I wanted it to be overwritten but new sheets were added to the workbook instead. Could be a bug.

link

add a comment

answered Aug 17 '18

Juan
21 ●18 ●19 ●23

I have the following problem Dyntools does not extract data from file out

** LINES PER PAGE for FILE OUTPUT set to 60

Output completed Traceback (most recent call last): File "C:\0-C\0-Simulaciones\Caso\Simulación.py", line 227, in <module> datosexcel = dyntools.CHNF(archivoout + '.out') File ".\dyntools.py", line 1023, in init File ".\dyntools.py", line 351, in outextractdata File ".\dyntools.py", line 321, in outextractid

Couldn't open Python file: C:\0-C\0-Simulaciones\Caso\Simulación.py

link

Comments

check my post at "Multi-Threading using xlsout"

jconto (Aug 17 '18)

HI, Thanks

Juan (Aug 21 '18)

Hello, I don't know how to solve this problem, but my opinion is that you should never use orthographic accent in Python even in comments or files names.

SAE_2016 (Sep 7 '18)

add a comment

answered Mar 29 '18

haveityourwa
15 ●14 ●15 ●19

if you also have lots of sheets you could delete a folder and remake it instead of each sheet,

if os.path.exists(PathDir + r"\sheets"):
    shutil.rmtree(PathDir + r"\sheets")
    os.makedirs(PathDir + r"\sheets")

Tried this as a comment but no formatting was available. Sorry if you got spammed with notifications of me changing the comment a bunch

link

add a comment

answered Mar 22 '18

camerond12
3 ●6 ●7 ●8

I think that this overwritesheet = true option will overwrite latest sheet if it is called more than once during simulation.

In my case, I am re running the script rather than using the dyntools command more than once in the same script.

To overcome this, I check for and delete existing excel file in directory by adding the following code just before using dyntools.CHNF.xlsout(..)

if os.path.exists(xlsoutput):
   try:
      os.remove(xlsoutput)
   except WindowsError:
      print 'file is open'

link

add a comment

Dyntools Overwrite Excel Sheet

5 answers

Comments

Your Answer

Question Tools

Stats

Related questions