Is there any way to prevent pssexcel from closing excel
I am running a couple of macros off of excel.
These macros then launch batch files which run python macros, who in turn convert PV results to excel using the pssexcel function.
However, once I Import pssexcel, it closes all of the excel sheets that are already open, and as such I cant copy the PV results onto the output spreadsheet.
Any Ideas?
Sounds like a pretty complicated system. Try importing `excelpy` does it also close all your Excel sheets?
I just did. And it does not close excel. However, how do I have excelpy print my PV results automatically. With pssexcel I can use this line to print the results so I do can analyze the results automatically in excel and then print the results of the analysis.
ran out of space above pssexcel.pv(pvOutputFile,string,colabel=colabel,xlsfile=xlsfile,sheet=sheet,overwritesheet=overwritesheet)
Ok, can you try one more thing. What about importing `pssexceluserin` Does that shut down the sheets too? I ask because I can't see anything that would shut the sheets in the `pssexcel.py` file.
Nope, pssexceluserin does not shut down the sheets. Just to confirm, I created a new file with a single line "import pssexcel" and ran it in PSSE with a single file open in excel, and it closed excel. I repeated the same single line file with pssexceluserin and excelpy and excel stayed open.