I am using Excel v4.1, Windows 7 and 64 bit OS.
When I try to run the update query, it is successfully executed and the test is completed.
But when I open the excel sheet, I am getting "File Error: data may have been lost) and seeing a .bak file.
Can you please help me in resolving this issue?
By the way, does Excel v4.1 support Windows 8 (64 bit) and MAC OS as well?
Please find my code as below:
properties = new Properties();
properties.setProperty("delayedClose", "-1");
Class.forName("com.hxtt.sql.excel.ExcelDriver");
workFlowExcel_RunManager_Connection = DriverManager.getConnection("jdbc:excel:/" + workFlowFolderName
+ "?WRITE=true", properties);
workFlowExcel_RunManager_Statement = workFlowExcel_RunManager_Connection.createStatement();
String updateMainSheetQuery = "UPDATE Main SET Result = '"
+ testCasestatus + "', Elapsed_Time = '"
+ testCaseElapsedTime + "', Execution_Start_Date_Time = '"
+ testCaseStartTime + "', Execution_End_Date_Time = '" + testCaseEndTime
+ "' WHERE Test_Case_Name = '" + testCaseName + "'";
workFlowExcel_Update_Main_Statement.execute(updateMainSheetQuery);
workFlowExcel_Update_Main_Connection.commit();
|
>But when I open the excel sheet, I am getting "File Error: data may have been
> lost) and seeing a .bak file.
>Can you please help me in resolving this issue?
Failed to recur your issue. Please email us your xls sample.
>By the way, does Excel v4.1 support Windows 8 (64 bit) and MAC OS as well?
Supports.
|