New answers tagged

1

Hope it's not too late... Suppose you want to dump new data (called here "datanew" and generated somehow) into a new sheet of an existing Excel file named "oldfile.xlsx" containing (in sheet 1) data ("dataold"). What I do is: SetDirectory[NotebookDirectory[]] dataold=Import["oldfile.xlsx"] Export["oldfile.xlsx",{dataold,datanew}] What you are doing is ...


2

Using NETLink we can come close to your specs. Note that passworded.xlsx is the password protected file, the password is "peter" and notPassworded.xlsx is the temp copy of a non-protected file. Needs["NETLink`"] LoadNETType["System.GC"]; excel = CreateCOMObject["Excel.Application"]; excel[Visible] = True; workbook = excel@Workbooks@ ...


7

I know this is an old question, but I ran into this problem myself. The permanent solution for me was to alter the settings of JLink directly. As for most commenters too, increasing the heap-space by giving commandline options to ReinstallJava and friends didn't work. Specifically, I tried to increase the heap-space by specifying the complete CommandLine ...



Top 50 recent answers are included