| || |
Problem with Java Utility accessing Excel after Export
I have an Excel spreadsheet that I import. I insert some data and then I export it. The exported spreadsheet is used to supply data to a Java utility that creates XML files. In my script I run this Java Utility via the command prompt. The problem is after I export the spreadsheet the Java Utility does not seem to be able to access the spreadsheet. After exporting I tried opening, saving, and closing the spreadsheet manually and then re-running the Utility, this works. Ive tried coming up with a workaround by using CopyFile, MoveFile via QTP and also Copy via the command prompt. None of these work. Does anyone know what the problem with the export could possibly be? Does QTP save the spreadsheet in a way that the Java Utility does not understand?
Thank You ,
Re: Problem with Java Utility accessing Excel after Export
This issue may have been related to the size of my excel spreadsheet, not sure, but maybe. So instead of exporting the datatable I wrote the data straight out into the excel file by creating an excel object. I got the code off Problem ID: 28332 in the Mercury Knowledge Base.