DataSink save to excel fails
Hello,
I have the latest version of SoapUI on a trail.
I have the Swagger addon installed.
Now i use a DataSink component. I use a REST testcase request. I want to save the result to file. when i select 'CSV' all is well. The data that i wanted to saved correctly and when i open the file the data is correct.
Now the problem. I don't really want to save to CSV but to excel. So i select 'Datasink' Excel
File: Not sure what to put here. I want to save data not read data
Out File: Here i create a brand new excel file
worksheet: "Blad1" (Dutch excel. This is the basic tab name)
Start at cell: A1
I click '(re)generate properties and i see the data correctly in the data log.
Now when i run this, it does create the xls file but when i try to open from explorer i first get the error File in use (OK SoapUI is open i can live with that) then i get a file corrupt error and when i do open the sheet is empty. However the tab name is now the same name as the file name. I tried namking the "worksheet" the same as the filename but no difference.
Anyone know why the excel sheet comes up emtpy and corrupt? I do know the data i save it correct and i can create a CSV with the data. I use Microsoft Excel 2013 up-to-date
Help would be appreciated
I have the latest version of SoapUI on a trail.
I have the Swagger addon installed.
Now i use a DataSink component. I use a REST testcase request. I want to save the result to file. when i select 'CSV' all is well. The data that i wanted to saved correctly and when i open the file the data is correct.
Now the problem. I don't really want to save to CSV but to excel. So i select 'Datasink' Excel
File: Not sure what to put here. I want to save data not read data
Out File: Here i create a brand new excel file
worksheet: "Blad1" (Dutch excel. This is the basic tab name)
Start at cell: A1
I click '(re)generate properties and i see the data correctly in the data log.
Now when i run this, it does create the xls file but when i try to open from explorer i first get the error File in use (OK SoapUI is open i can live with that) then i get a file corrupt error and when i do open the sheet is empty. However the tab name is now the same name as the file name. I tried namking the "worksheet" the same as the filename but no difference.
Anyone know why the excel sheet comes up emtpy and corrupt? I do know the data i save it correct and i can create a CSV with the data. I use Microsoft Excel 2013 up-to-date
Help would be appreciated
