I am just starting to use this project, and I can't get the .change_workbook("…") to function correctly. It does not throw an error, but the active workbook does not change. I am using Windows and Excel 2007.
Everything else seems to work fine so far, except pasting a large array onto another sheet, but that is probably due to poor coding. If you care to help, I have this:
Thanks for the bug report. I'm suddenly having issues with workbooks, which I have never had before. Something you should do is try ending the "EXCEL.exe" process and trying again. Sometimes the com system breaks (because of excel, not me… I think).
As for the code, it is another bug. Stupid microsoft wants you to give them the data in the form "[, , , … " if it is going down a column. Just be thankful you don't have to deal with this crap!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am just starting to use this project, and I can't get the .change_workbook("…") to function correctly. It does not throw an error, but the active workbook does not change. I am using Windows and Excel 2007.
Everything else seems to work fine so far, except pasting a large array onto another sheet, but that is probably due to poor coding. If you care to help, I have this:
bigArray = wb[23:1827,4] wb.change_sheet("nextSheet") wb[4:,57] = bigArrayAll of the target cells are filled, but each is filled with the first value in bigArray.
Thanks for the bug report. I'm suddenly having issues with workbooks, which I have never had before. Something you should do is try ending the "EXCEL.exe" process and trying again. Sometimes the com system breaks (because of excel, not me… I think).
As for the code, it is another bug. Stupid microsoft wants you to give them the data in the form "[, , , … " if it is going down a column. Just be thankful you don't have to deal with this crap!